Should I remove physical memory monitoring for SQL Servers?

Jason_TF

I'm configuring SolarWinds for the first time on my environment. Currently I'm just completed adding my SQL database servers into monitoring & boom my dashboard showing reds on all my SQL databases, apparently due to physical memory utilization. High physical memory utilization is quite normal for any SQL database servers as SQL instance will manage it's own memory setting.

So is it a good choice to remove physical memory monitoring for SQL servers?

ryan88

Hi,

In my opinion i tend to keep it, but reconfigure the warning and critical thresholds in line with what my DBA's advise. obviosuly they can allocate large chunks of memory for SQL jsut to consume, however they will also be aware that if other processes are running it could indicate a performance issue.

I think changing the warnign and critical threshold for memory should be adapted with relevant logic on there that says if it happens for X out of Y polls then it is a problem. That way you can alert off abnormlities you want to know about in a consist way to all other nodes.

It is too risky to have SQL hosts exempt from Memory monitoring, especially if they are business critical. If the SQL DBA's are allocating too much memory and it causes problems the monitoringwould indicate resource contention that needs managing.