Databases Reference
In-Depth Information
Working with Data Collector Sets
In addition to the provided Data Collector Sets, you can also create user-dei ned Data Collector Sets
consisting of your own counters and settings. Real-time monitoring is great when a quick snapshot
is required, but it can be difi cult to identify patterns and trends when observing a server “live.” It's
usually more convenient to capture performance data to a i le and then analyze that log i le — either
manually or using one of the tools you'll look at later in this chapter. This section walks through
coni guring a user-dei ned Data Collector Set to monitor system performance.
User-dei ned Data Collector Sets in Windows Server 2008 replace the Performance Logs and Alerts
from Windows 2000/2003 but the principle is the same. To access them, from Reliability and
Performance Monitor select Data Collector Sets. Right-click User Dei ned and choose New
Data
Collector Set. A short wizard launches to create the new collector set. The i rst choice is to create
from a template or create manually. Creating a collector set from a template provides three template
collectors: Basic, System Diagnostics, and System Performance. You can use these templates as a
starting point, adding and removing counters as required. Because these templates are Windows-
generic, there's nothing especially interesting about them from a SQL Server perspective. Therefore,
choose the second option, Create manually (Advanced), and give the new collector a useful name, as
shown in Figure 10-5.
➪
FIGURE 10-5
The next step is to select Create Data Logs or Performance Counter Alerts. In most situations
you'll use the Performance Counter data log because you will likely be interested in gathering
some system-wide performance data, rather than use PerfMon to i re an alert when a threshold is
exceeded. Three types of data can be captured in the data log, as summarized in Table 10-2.
Search WWH ::
Custom Search