Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Dec 6, 2016
Troubleshooting outages is stressful. Studies and Microsoft case files tell us that approximately 90% of all SQL Server related outages are due to blocking. Even with this knowledge in hand most SQL Server DBAs can’t walk you through the fundamentals of how to resolve SQL Server down scenarios. One of the greatest free tools on the market for DBAs is Adam Machanic’s sp_whoisactive. His tool provides us with everything we need to know in order to become adept at watching transactions and resolving outages. By definition a database is a container for objects. That’s what a database is but is but not what it does. What it does is process transactions. If you want to become proficient at troubleshooting outages, then you have to understand how transactions flow. In this lecture I’m going to cover the importance of watching transactions flow through SQL Server. Additionally, I’m going to show you how to use sp_whoisactive to resolve outages and how to use it as a starting point for your performance tuning efforts.