Automating Analysis of the DMVs  for Query Exec, Index Usage Stats, and Execution Plans

by Joe Chang

The DMVs introduced in SQL Server 2005 have been really helpful in identifying the top SQL queries to tune, and in identifying unused indexes. Still, it can be tedious to manually examine each XML execution plan, and to find out which execution plans reference infrequently used indexes.

This presentation will show you much of this can be automated with a free SQL Exec Stats utility, and will help you get most out of these DMVs.

Registration site: http://www.clicktoattend.com/?id=140632
Event Code: 140632