Introduction to SQL 2008 Performance Data Collector

SQL 2008 includes a new Data Collector infrastructure that expands on the work done with the Performance Dashboard custom reports introduced in SQL2005 SP2 to allow you to easily configure and collect performance data from your SQL instances and store them in a Management Data Warehouse. In this session I'll cover the architecture and system data collection sets and demonstrate how to create your own custom collections. I'll also cover how to create custom reports hosted in SSMS to display and report on the collected data.
Presented by Jasper Smith at SQLBits II
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    Jasper is a member of the Database Services team at Nationwide Building Society focussed on High Availability, Scalability, Performance Tuning and Monitoring. He has been a SQL Server MVP since 2003 and runs with a focus on providing free tools for the SQL Server community including ExpressMaint, SQL 2005 Service Manager and Reporting Services Scripter.
  • Video
    The video is not available to view online.