Performance Data Collector for SQL Server 2008 - Revealed

  • Article

I’ve been getting many requests on what is this new Performance Data Collector tool and how does it work. First off, Performance Data Collector is simply a component as one of the tools in Management Studio (SSMS) involved in performance troubleshooting. These tools include the new Data Collector, System Collection Sets, the Management Data Warehouse, and historical reports for the collection sets. It also includes the ever popular tools like Profiler, DTA, Graphical Showplan, Activity Monitor, Client Statistics, and standard performance reports based on the SQL Engine DMVs.

To learn more about Performance Data Collector that released with the SQL Server 2008 November CTP, please check out my September 27 2007 TechNet webcast at: https://msevents.microsoft.com/cui/WebCastEventDetails.aspx?culture=en-US&EventID=1032349947&CountryCode=US

Cheers,
Bill Ramos

Comments

  • Anonymous
    January 17, 2008
    I’ve been getting many requests on what is this new Performance Studio tool and how does it work. First

  • Anonymous
    February 14, 2008
    This will be a quick and dirty post on data collection in SQL Server 2008. The next two posts will cover

  • Anonymous
    May 13, 2008
    Can this be used to collect info from SQL 2005 instances?