Databases Reference
In-Depth Information
TABLE 10-2:
Data Collector Set Logging Options
LOG TYPE
DESCRIPTION
Performance counter
Provides performance data for most aspects of Windows and SQL Server
Event trace data
Uses event tracing for Windows to provide low-level operating system
tracing
System confi guration
information
Captures Registry keys
After selecting Create Data Logs, select the Performance counter log type and click Next to con-
tinue. Now you'll add a small selection of interesting counters to get an overview of system perfor-
mance. Click Add, and select all counters as shown in Figure 10-6. Leave the sample interval at 15
seconds; the impact of the sampling interval is covered in the next section.
FIGURE 10-6
After adding the counters, select a folder to store the trace data. Ensure there is sufi cient space on
the disk to hold the trace i le (the size depends on how long the trace is running but normally 2GB
of free space should be i ne for a few hours of tracing). Click Next when you have entered a location
for the logs. At the i nal coni rmation dialog, click Finish to create the collector.
Starting, Stopping, and Scheduling Collectors
At this point, the data collector has been dei ned, but no data has actually been captured because
the collector has not been started. To start a collector, right-click on the collector name and choose
Search WWH ::
Custom Search