Databases Reference
In-Depth Information
Starting Out with Data Collector Sets
Data Collector Sets are groups of data-gathering tools. They can include kernel tracing, perfor-
mance logs, and coni guration data. Three Data Collector Sets are provided out-of-the-box, includ-
ing a system performance collector that consists of a kernel trace and a PerfMon log. To utilize a
pre-dei ned data collector, select Data Collector Sets
➪
System, right-click System Performance, and
select Start.
The system performance collector runs for 60 seconds. When collection has i nished, navigate to
Reports
System Performance, and choose the latest report. As shown in Figure 10-4,
the report presents data in a very readable layout.
➪
System
➪
FIGURE 10-4
The System Performance report begins with a summary of the four key resources: CPU, Disk,
Memory, and Network. Figure 10-4 shows memory utilization at 94% and the diagnostic results
indicate excessive paging and low memory, recommending either adding more memory or reducing
system load. The Resource Overview section shows memory status with a red trafi c signal, high-
lighting a memory issue.
The small effort required to start the system performance collector, wait 60 seconds, and launch the
report results in a conclusive initial investigation. In this case, the top process shown in the memory
summary is SSMS (SQL Server Management Studio), and the next step would be to identify the
problem session and resolve the issue.
Search WWH ::
Custom Search