topic Re: SIM Database - SQL Versions/Sizing in Server Management - Systems Insight Manager

SIM Database - SQL Versions/Sizing

sgunelius — Mon, 17 Jul 2006 08:24:46 GMT

Good morning. I have a relatively small environment of 50+ ProLiant servers that I would like to monitor using SIM, but I think a full-blown version of SQL Server would be overkill. Is MSDE or SQL Server 2005 Express Edition supported as the database for a SIM implementation? Thank you in advance for your responses.

Re: SIM Database - SQL Versions/Sizing

Joel Rubenstein — Mon, 17 Jul 2006 08:29:28 GMT

yes, MSDE is supported but not recommended for environments larger than 500 servers.

Re: SIM Database - SQL Versions/Sizing

sgunelius — Mon, 17 Jul 2006 08:36:27 GMT

Joel,

Thank you for your prompt response. Would I be correct in assuming the capacity limitation of 500 monitored servers applies to SQL Server 2005 Express Edition as well?

Scott

Re: SIM Database - SQL Versions/Sizing

Joel Rubenstein — Mon, 17 Jul 2006 08:50:51 GMT

Scott,

I don't know specifically about SQL Server 2005 Express Edition. The latest release of SIM 5 SP5 supports MSDE, SQL 2000, SQL 2005 and Oracle 9i. If you are not going to use SQL 2000, SQL 2005 or Oracle I would recommend to install the version of MSDE that is bundled with SIM.

Re: SIM Database - SQL Versions/Sizing

sgunelius — Mon, 17 Jul 2006 09:15:37 GMT

Joel,

Thank you again for your response. I may have to revisit the idea of using SQL Server now because I would like to support the instances for SIM and our VMware VirtualCenter console (MSDE is supported, but not for production environments) on the same server.

From what I understand, VMware regards SQL Server 2005 Express Edition much the same as MSDE and therefore I wouldn't be operating a supported environment (not a good career move for me...). Thanks again.

Scott