936
Part VII: Monitoring and Auditing
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 specifi c 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.Summary
Analyzing where SQL Server spends its time waiting should be one of the fi rst steps you
take for performance tuning. You need to realize that high wait values represent smoke,
not fi re. Use them as a compass to fi nd where you may be experiencing performance
problems on your SQL Server instance.c39.indd 936c39.indd 936 7/31/2012 10:04:46 AM7/31/2012 10:04:46 AM
http://www.it-ebooks.info