We use SolarWinds SAM software to monitor servers and applications. We started using it to monitor our SQL servers through the performance counters.
We started getting alerts two to three times daily saying that the "Total Server Memory" and "User Connections" counters were too high. We get these alerts at the same time for all three servers...almost like it's synchronized to go off at the same time. The alerts reset maybe 3 minutes after going off.
I haven't been able to find any reason why this is happening. Any idea what may be causing this, or how to track down the cause?
The queries used to pull the data are as follows.
For "User Connections":
SELECT cntr_value FROM sys.dm_os_performance_counters WHERE object_name LIKE '%:General Statistics%' AND counter_name = 'User Connections'
For "Total Server Memory":
SELECT cntr_value FROM sys.dm_os_performance_counters WHERE object_name LIKE '%:Memory Manager%' AND counter_name = 'Total Server Memory (KB)'