SIM 5.0: SQL or MSDE

[Frank Norgan]

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

[Harry Galanos]

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.

[David Claypool]

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

[jim goodman]

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

[Frank Norgan]

Harry, David, Jim;

Thanks guys for great information.


Frank

[Mark Wolf_2]

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

[Frank Norgan]

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