topic Re: HPSIM & MSSQL2000 in Server Management - Systems Insight Manager

HPSIM & MSSQL2000

Annette Jones_2 — Fri, 19 Nov 2004 07:13:42 GMT

The HPSIM install is as follows,
HPSIM dedicated server with 3gb RAM & 2.80GHZ processor, MSSQL2000 on another server with the HPSIM database, 3gb RAM & 3.06GHZ processor. Both server running W2K with sp4.

I find that when I use the HPSIM GUI either from the HPSIM server or from my client workstation, it's very very slow when trying to edit list I have setup or creating new server list or managed tasks.

Is this normal?

The network card on both server are 100mb/full and our network under utilised, I can only see that the query of sql2000 is the problem, anyone help with this?

Ta

Re: HPSIM & MSSQL2000

Aravindh Rajaram — Fri, 19 Nov 2004 08:38:16 GMT

With you server config., HPSIM should work at blazing speeds. But SQL Server with more than 2GB RAM requires some tweaking to be done. Have you done that? if not check out the article at http://support.microsoft.com/?id=274750

and then see how it works.

Re: HPSIM & MSSQL2000

Annette Jones_2 — Fri, 19 Nov 2004 09:30:32 GMT

Did the /PAE in the boot.ini, but doesn't seem to have made any difference.

I have in total about 200 servers and 6,000 workstations. The workstations are never included in any lists, they just exist to obtain numbers, could these workstations be slowing down the queries?

ta

Re: HPSIM & MSSQL2000

Aravindh Rajaram — Fri, 19 Nov 2004 10:26:03 GMT

HPSIM runs hardware status polling task for non servers every 10 minutes and for servers it is every 5 minutes. So if it's Ok with you to increase these intervals then you can gain some considerable speed. You can find both of these tasks under Logs-> View All Scheduled tasks.

Re: HPSIM & MSSQL2000

Annette Jones_2 — Fri, 19 Nov 2004 10:39:54 GMT

thanks,

I had already amended the non-server schedule to once a month, cause it's just a number count for us. As a test I am going to remove all the desktops to see if the queries speed up.

ta