Hi, I have recently purchased a copy of solarwinds and have set it up to monitor my SQL server.
Straight away it has brought loads of critical errors mainly on the following
Workfiles Created/Sec - Average 35 out of hours, 250+ in hours, sometimes its as high as 600
Worktables Created/Sec - Average 25 out of hours, 90 in hours
Page Splits/Batch Request - 0.35 out of hours, 1.45 in hours
Page Splits/sec - 20 out of hours, 143 in hours
Nobody has reported any issues regarding performance.
Is this something that is safe to just adjust where the critical alerts were?
Originally the server had 96Gb of ram, and it was using 100% of the ram, I upped the ram to 256Gb, but weirdly its only using around 60Gb now.
I have tracked down a lot of cross database / server queries and I have changed the way they run to reduce the CPU time on them. However it has made little difference to the results.
If anyone has any advice on the counters, what are safe limits etc I would really appreciate it.