Introduction There are thousands of indicators (Perfmon Counters, system views, …) one can track to monitor SQL Server, but not all of them are relevant. If I need to pick one, that would be “Processes Blocked”.
Databases should be fast and simple to use. We make them so. Do not let your customers wait for a slow database response - hire a top professional! We are passionate about creating highly-tuned SQL Server systems. Do you want yours to become one? Simply call us or send email, and we will take care of the rest.
Vedran Kesegić, M.Sc.
SQL Server Database Consultant
A Random Thought
If nobody reacted to alert from monitoring system, that alert should not exist. Quality of alerts is measured by number of reactions divided by number of raised messages. Should be close to 100%. If below 50%, it is a spamming system, not alerting system. Nobody reacts to real alerts if so many false ones occur. Be savvy with alerts.