In this post, we shall go down an interesting road of looking up the SQL Server’s instance health using the scheduler_monitor_system_health_ring_buffer_recorded event for SQL Server 2012 instances.
Read this article..
Amit currently works as a Premier Field Engineer at Microsoft specializing in proactive and advisory assistance for SQL Server environments.
In the past, Amit was part of the SQL Server Escalation Services team at Microsoft. His day-to-day work involves fixing and troubleshooting complex issues related to SQL Server over a varied range of environments, which could be a deployment handling just 100 users or 10 million users.
Over the years, he has learned various ways of slicing and dicing diagnostic data collected for troubleshooting and picked up a few tricks & tid-bits about the internals of this ever-evolving product called SQL Server.
For more information about Amit, visit his blog at http://troubleshootingsql.com.
comments powered by