In this session Joe Chang will teach us about his free SQL Exec Stats tool.
Objectives: What does SQL Exec Stats do? Automates collection of key DMVs for query tuning. Collates query exec stats with execution plan details. Saves XML plan for top queries, what plans reference infrequently used indexes. Cross reference index usage by execution plan. Save information directly to Microsoft Excel 2003 file format and in binary.
Purpose: Why do we need or want this? Simplifies performance data collection (sufficiently complete for query tuning). Encourages collection of performance data at regular interval, i.e. keep a history of system health. Automates several elements of performance analysis (reduces time and effort). Enable remote tuning assistance, key information is compact enough to be sent by email for some else to help.
Comments