September 2010
Intermediate to advanced
1704 pages
111h 8m
English
As mentioned previously, SQL Server 2008 introduces a new performance monitoring tool called the Data Collector. The Data Collector is designed to collect performance-related data from multiple sources from one or more SQL Servers, store it in a central data warehouse, and present the data through reports in SQL Server Management Studio. The main purpose of the Data Collector is to provide an easy way to automate the collection of critical performance data. The Data Collector gathers information from Windows performance counters, snapshots of data grabbed from dynamic management views, and details on disk utilization.
Data collection can be configured to run continuously or on a user-defined schedule. You can adjust ...