topic Re: HP SIM63 default DB in Server Management - Systems Insight Manager

HP SIM63 default DB

Jamie Curran — Fri, 21 Oct 2011 20:41:45 GMT

What does HP SIm 6.3 Install as the default DB for WIndows ? Is it SQL express if so what version. I'm Looking at installing HP SIm 6.3 on Windows 2008 Standard or Enterprise SP1 R2. I will only be managing about 300-500 servers.

Thanks,

Re: HP SIM63 default DB

Bart_Heungens — Fri, 21 Oct 2011 21:19:39 GMT

Hi,

The default DB for SIM 6.3 is SQL 2008 R2 Express...

Kr,

Bart

Re: HP SIM63 default DB

shocko — Mon, 24 Oct 2011 08:30:27 GMT

The only thing to be mindful of is there is a limited size of the DB with Express flavors so if you have a very large environment, it may not suit.

Re: HP SIM63 default DB

Jamie Curran — Mon, 24 Oct 2011 13:04:27 GMT

What is the hardfast limit I think I saw 500-750 client machines? We are looking at strictly using it for hardware alerts for approximately 300 -500 machines initially it it expands we would look at going to a full blow version of SQL.

Re: HP SIM63 default DB

shocko — Mon, 24 Oct 2011 13:06:50 GMT

Can't remember of the top of my head but I'll try and look it up in the release notes.

Re: HP SIM63 default DB

Bart_Heungens — Mon, 24 Oct 2011 19:06:41 GMT

If I remember well, with SIM 6.0 you could go up to 1000 monitored items and with 6.3 this was raised to 2500 items or so? Can't remember well but it must be somewhere there...

When I am connected to my SIM server I will try to look it up...

500-750 shouldn't be a problem though...

Kr,

Bart

Re: HP SIM63 default DB

shocko — Tue, 25 Oct 2011 08:42:21 GMT

I agree with Bart. I monitor about 600 systems and the only issue I have had was with the java heap size for the CMS itself. the DB has been fine. I was looking around for hard figures but I can't seem to find anything other than a reference to 6.3 supporting 'thousands' of devices. I'd say there are no hard and fast figures as polling intervals, frequency of collections etc. all affect the heap/db size.

Re: HP SIM63 default DB

Jamie Curran — Tue, 25 Oct 2011 13:45:43 GMT

In the event we outgrow the SQL 2008 R2 express db is there an upgrade path to the full blow version of SQL 2008 R2???? I'm not a DB guy so any help would be greatly appreciated.

Thanks.

Re: HP SIM63 default DB

shocko — Tue, 25 Oct 2011 13:51:00 GMT

Yes, full blown SQL 2008 R2 engine will run the express DB. Alternatively you can run an export and import.