This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Very high memory usage on SQL server for SolarWinds NPM and NTA

vccy118 over 12 years ago

According to NPM requirements for SL2000, 4GB RAM for the SQL server should be enough. Which is why we are quite shocked to see these:

This has a direct impact to the performance of the web client. Loading pages takes a long time, especially for the NTA module.

We are monitoring only 603 elements, 23 nodes and 580 interfaces.

Any possible way to overcome this problem? Thanks.

0 Nandish over 12 years ago

I would recommend to open a support ticket to look into this issue.
Cancel
Vote Up 0 Vote Down

Cancel
0 smargh over 12 years ago

This is normal for MSSQL - it will use all available memory for caching rather than having to hit the disk all the time.
Have you tried limiting memory?
The slowness of the web UI might be a different problem. I notice that you've got Microsoft's AV running - have you told it to ignore the SQL folders for realtime scanning? http://support.microsoft.com/kb/309422
Cancel
Vote Up 0 Vote Down

Cancel
0 FormerMember over 12 years ago in reply to smargh

Just to confirm the above post - SQL Server will use as much memory as it can for caching. If you're worried about SQL performance then monitor the performance counters (I reference www.sqlteam.com/.../topic.asp to remind me what counters to watch). If you have APM (or try the eval) you could also apply the SQL Server template for the stats.
What specific web pages are slow? Graphs? What retention settings do you have for storing data, and what is the default graphing period when you view graphs? You may also want to check for fragmented tables/indexes on the database - have a look here sqlserverperformance.wordpress.com/.../ and download the diagnostic queries, a lot of them will point out problems for you.
Andy.
Cancel
Vote Up 0 Vote Down

Cancel
0 vccy118 over 12 years ago in reply to FormerMember

Thanks, smargh! I will try that and hopefully it helps.

Generally all NTA pages are quite slow, even when accessing the webclient on the server itself which has a 1gbps link to the sql server. However the most pressing matter is the loading of the graphs. For 24 hours plotting it will take a few minutes and half the time the graphs failed to load or stuck at loading. I will try APM eval and the links you posted, thanks!
Cancel
Vote Up 0 Vote Down

Cancel
0 vccy118 over 12 years ago in reply to vccy118

Attached below is the stall time table from the SQL query I did on the Microsoft SWL 2008 R2 server for SolarWinds. I don't really know how to analyse this, can anyone help me with it? Thanks!

SQL Server 2008 Diagnostic Results (July 2011).xls
Cancel
Vote Up 0 Vote Down

Cancel