topic Re: SIM 5.0: SQL or MSDE in Server Management - Systems Insight Manager

SIM 5.0: SQL or MSDE

Frank Norgan — Sat, 10 Sep 2005 18:16:44 GMT

Hello,

I'm getting ready to deploy SIM 5.0, and would like to know if there are any advantages to using a SQL back-end or MSDE.

Thanks
Frank

Re: SIM 5.0: SQL or MSDE

Harry Galanos — Sun, 11 Sep 2005 05:59:52 GMT

Hi Frank,

Both methods have advantages and disadvantages.

If you install MSDE it will be dedicated to HP SIM, stored locally and should be faster.

If you use an existing SQL database, you could slow it down once SIM grows, and you will be competing for CPU%.

I used MSDE and is seems to be running VERY well without problems. Maybe you can install it on another partition/drive.

Good luck.

Re: SIM 5.0: SQL or MSDE

David Claypool — Mon, 12 Sep 2005 10:29:31 GMT

There is a general rule-of-thumb, but as always, your mileage may vary:

MSDE: up to 500 devices and 5,000 events
SQL2000: up to 5,000 devices and 50,000 events

Re: SIM 5.0: SQL or MSDE

jim goodman — Mon, 12 Sep 2005 10:39:07 GMT

Frank my 2 pennies worth is if you have a remote SQL installation available use it.

Local MSDE has its limitations. If you use a remote SQL installation then you will keep the CMS well with resources and also you will have all of the advantages to managing the database with the robustness that only full SQL brings to the table.

- Jim

Re: SIM 5.0: SQL or MSDE

Frank Norgan — Mon, 12 Sep 2005 19:25:34 GMT

Harry, David, Jim;

Thanks guys for great information.

Frank

Re: SIM 5.0: SQL or MSDE

Mark Wolf_2 — Tue, 13 Sep 2005 11:30:38 GMT

Frank

The general rule-of- thumb is a good place to start with this caveat. HPSIM sends a prodigus amout of events in its default settings. It is very easy to bump up against the 5,000 limit if you are not watching. I find that the response time is noticibly slower long before you reach this limit.

Realize also that this is 500 devices not 500 servers.

Mark

Re: SIM 5.0: SQL or MSDE

Frank Norgan — Tue, 13 Sep 2005 15:52:21 GMT

All,

I'm sold on the SQL2000 back-end for SIM50!

We have an existing SQL2000 server (SP4)with existing databases on it.

Will SIM play nice with our existing SQL2000 server/database structure or does it need a dedicated SQL2000 server back-end?

I don't want the SIM installation to create havoc on existing SQL databases.

Frank