HPSIM limitations when using the SQL Express edition
Hello !
We will soon update to HPSIM 6.2 and IRSA 5.50 at a customer site. We will install everything from scratch on a Windows Server 2008 Standard SP2 system.
Today, they are using HPSIM with the SQL Express edition that ships with the product. In the manuals it says we only support up to 500 monitored nodes when using SQL Express, and the customer is very near that limit. I have searched the documentation to try to find out more details about this limitation, but didn't succeed.
- What exactly does the 500 nodes limitaion mean? I suppose it's just a "performance" limit and that there isn't a hard limit for adding node number 501 and above.
- What are the alternatives if we reach the 500 nodes limitation in the future? If the customer buys the full featured SQL edition, is there a possibility to move the database from SQL Express?
Re: HPSIM limitations when using the SQL Express edition
Mikael,
I have seen customers go way past 500 nodes without serious degradation of performance. As long as you meet the hardware pre-requisites you should be ok. The thing you need to be most aware of is the OS you are working with. Before you do any installation of IRSA 5.50, make sure you disable user access control. Also, you will find if you are updating HPSIM as opposed to re-installing it, depending on what version of HPSIM you are upgrading from, you will need to update your SQL DB to SP3 if you are on HPSIM5.3, if you are on any version of HPSIM earlier than that then you would be better served to do an uninstall/reinstall.
