DaveWentzel.com            All Things Data

Performance Data Collector


Performance Data Collector
  • New in 2008
  • collects various performance statistics and saves them to a data warehouse. 
  • reports can then be created against that data.
  • collection sets by default are Disk Usage, Query Statistics, and Server Activities.
  • but you can create/customize your own collection sets.
  • To create a Profiler collection set you can write the SQL yourself or let Profiler do it for you.
  • File|Export to save the trace definition to "SQL Trace Collection Set"
  • Read the generated script carefully because certain parameters will need to be set up.