Other Ways to Gather Wait data
You can gather Wait data in other ways, including Extended Events, Management Data Warehouse, and the Activity Monitor.
Extended Events is a general event handling system in the database engine. You can use this feature to track waits as they occur in the database engine, such as tracking wait types at a given session level Use this tool when troubleshooting specific performance related issues. Chapter 40, “Extended Events,” covers Extended Events.
MDW is a SQL Server database populated by the Data Collector that tracks wait stats along with many other pieces of performance data. Use this tool when taking a holistic approach to performance troubleshooting as it can capture a very wide range of performance related data. Chapter 43, “Management Data Warehouse,” covers MDW.
Activity Monitor is a tool that you can launch through Management Studio that enables you to view performance information for your SQL instance. Through the Activity Monitor you can view active tasks, wait statistics, IO performance, and expensive queries. This tool provides a very nice snapshot view of the activity on a system at a given point in time.
Get Microsoft SQL Server 2012 Bible now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
