troubleshooting Question

monitoring configuration for SQL server DB

Avatar of marrowyung
marrowyung asked on
SQLMicrosoft SQL ServerMicrosoft SQL Server 2008
32 Comments1 Solution173 ViewsLast Modified:

right now we are reviewing SQL monitor parameters, we have this but please share what you think the correct value you guys use, we are receiving more and more alert on

1) Page Splits / Sec   >2000  will have warning.  > 10000 will have Critical message.
2) Index searches /sec  >1000 will have warning. >2000 will have critical message.
3) SQL Compilations/Sec >100 will have warning ,>300 will have critical message
4) Page Faults/sec,  >800 will have warning.  >1000 will have critical message.

for monitoring parameters like that, any suggested better value ?
Join our community to see this answer!
Unlock 1 Answer and 32 Comments.
Start Free Trial
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 32 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