Configuration review - advise please

Question

Below are the specs of our setup\configuration. Any throughts on it and how I have the pollers setup? Anything you would recemmend changing? Our home page is setup for only 10 users who have it displayed all day long to watch for problems (refresh every 2 minutes). We are also using CPU/application/and node e-mail alerting.

From the engines table in our database:
elements - 1078
nodes - 117
interfaces - 403
volumes - 558
pollers - 1581
maxpollspersecond - 25 (seconds)
maxstatpollspersecond - 35 (seconds)
nodepollinterval - 15 (seconds)
interfacepollinterval - 60 (seconds)
volumepollinterval - 120 (seconds)
nodestatpollinterval - 2 (minutes)
interfacestatpollinterval - 5 (minutes)
volumestatpollinterface - 5 (minutes)
pollingcompletion percentage - 92.88847%

Home Page Modules Setup:
All Nodes - Tree (AJAX)
Top 50 Nodes by Physical Memory Used
Down Nodes
Nodes with Problems
Down Applications
Top 25 Nodes by CPU Load
Active Alerts
Top 10 Nodes by Current Response Time

Now our seperate SQL server CPU is almost always pegged at or near 100%, it is a 2GHz Quad Core with 2GB memory. Everything is DOG slow, browsing web pages etc on our SolarWinds site. When I shutdown SolarWinds the SQL server CPU drops to 5% - 10%. We are running NPM version 9.1 and APM version 2 SP1. I plan on installed AMP 2 SP2 tonight.

r0berth1 · Answer

if the answer to the Polls Per Second Utility is yes. you may want to check the page file of the sever and make sure that it is set to the recommended for the start value, and the double it for the max value, if you have enough disk space. Also you can check if the following settings are correct: On the server, right click on My Computer and click properties, the click the Advanced tab of the System Properties box, then select Settings under the Performance area. On the Performance options, choose "Adjust for Best performance" apply that, then click on advanced tab, you want adjust for best performance of: Background Services checked and under memory usage, you want System Cache checked. The Virtual memory section is where you want to adjust the page file by clicking on Change, That will open the Virtual Memory box. click on each drive and either choose System managed size or enter Initial Size and make it the recommended value then Double that number for Maximun Size and click set. then choose the next drive and enter the same settings (if you have more that one drive). Click on OK on the Virtual Memory box, then OK the Performance Options box, Then OK the System Properties box. this will ask you to reboot for the changes to take effect. If you have any Basic Alerts or Advanced alerts setup, I would turn them off before rebooting, otherwise you will get a ton of alerts after rebooting the SQL server.

mark_wiggans · Answer

Have you tried using the Polls Per Second Utility?

www.solarwinds.com/.../gaps.htm

FormerMember · Answer

NetPerfMon DB size is 8GB, running on a 2GHz Quad core with 2GB RAM. SQL 2000 Enterprise Edition.