troubleshooting Question

SQL Server performance

Avatar of CaptainGiblets
CaptainGibletsFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft SQL ServerSQLSolarWinds
5 Comments1 Solution194 ViewsLast Modified:
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.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 5 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros