Logo
HOW TO
Windows XP
Windows Vista
Windows 7
Windows Azure
Windows Server
Windows Phone
 
 
Windows Server

SQL Server 2008 R2 : Performance Monitoring Tools (part 11) - Creating Data Collector Sets in Performance Monitor

5/10/2013 6:16:30 PM
Creating Data Collector Sets in Performance Monitor

A Data Collector Set is the building block of performance monitoring and reporting in Windows Performance Monitor. It organizes multiple data collection points into a single component that can be used for review or to log performance counters. A Data Collector Set can be created and then recorded individually, grouped with other Data Collector Sets and incorporated into logs, viewed in Performance Monitor, or configured to generate alerts when thresholds are reached. You can set up schedules on your Data Collector Sets to have them run the data collection at specific times.

Data collector sets can contain the following types of Data Collectors:

  • Performance counters

  • Event trace data

  • System configuration information (Registry key values)

Performance counters are measurements of system state or activity. They can be included in the operating system or can be part of individual applications. When you install SQL Server, a number of SQL Server–specific performance counters are installed . Windows Performance Monitor requests the current value of performance counters at specified time intervals.

Event trace data is collected from trace providers, which are components of the operating system or of individual applications that report actions or events. Output from multiple trace providers can be combined into a trace session.

Configuration information is collected from key values in the Windows Registry. Windows Performance Monitor can record the value of a Registry key at a specified time or interval as part of a log file.

The easiest way to created a Data Collector Set is to create a custom view of counters in Performance Monitor (similar to what was shown in the previous section). When you are satisfied with the counters and settings you have configured, right-click on the Performance Monitor node in the Monitoring Tools folder, select New, and then select Data Collector Set. This starts the Create Data Collector Set Wizard, which walks you through the following steps:

1.
The wizard prompts for a name for the Data Collector Set. Enter a name and click Next.

2.
Specify the root directory where the Performance Monitor log files will be written and click Next.

3.
Specify if you want the Data Collector to run under a different user ID and if you want to start the Data Collector immediately or to just save the Data Collector Set. Click Finish to return to Performance Monitor.

The newly created Data Collector Set is listed under the User Defined folder in the Data Collector Sets node in Performance Monitor.

You can also create a Data Collector Set manually or from a template by right-clicking on the User Defined folder in the Data Collector Sets node and selecting New, Data Collector Set. This launches a modified version of the Create New Data Collector Set Wizard, as shown in Figure 23.

Figure 23. The Create New Data Collector Set Wizard.

You first specify a name for the collector set and then choose whether to create it from a template or manually. Then you click Next.

If you choose to create from a template, the next screen displays the built-in templates provided with Windows; these standard templates focus on general system performance or diagnostics. You can also choose to import your own templates by clicking on the Browse button.

Note

Creating your own Data Collector Set templates in Performance Monitor is relatively easy. If you have a Data Collector Set that you’ve set up with the performance counters and settings that you would like to reuse, simply right-click the Data Collector Set you want to export and click Save Template. Select a directory in which to store the collector set as an XML file and click Save. You can now copy this template for use on other computers.


After selecting the template, navigate to the next screen to specify the root directory for the log files. On the final screen, you have the option again to start the collector immediately, save it, or open the properties for the Data Collector Set so you can make further modifications to it, such as specifying a schedule or how it should handle.

If you choose to create a new Data Collector Set manually instead of using a template, you are presented with the screen shown in Figure 24. You have the option to create a Data Collector Set that generates data logs or to create a Performance Counter Alert. If you are creating data logs, you can specify what sort of information you want to include in the collector set (in this example, we’re logging performance counters only).

Figure 24. Creating a new Data Collector Set manually to capture performance counters.

Depending on the Data Collector types you select, you are presented with dialogs to add Data Collectors to your Data Collector Set. In this example, you are presented with the dialog to add performance counters, as shown in Figure 24.

After defining the counters, and so on, you are presented with the familiar options to specify the root directory and whether to save, run, or edit the properties of the Data Collector Set.

After you create a Data Collector Set, you can add additional Data Collectors to it as desired. They can be additional performance counter event traces, configuration Data Collectors, or performance counter alerts.

Other -----------------
- Microsoft Systems Management Server 2003 : Package Distribution and Management - Monitoring Status
- Microsoft Systems Management Server 2003 : Configuring the Client (part 4) - Managing the Advanced Client Download Cache, Advertised Programs Process Flow
- Microsoft Systems Management Server 2003 : Configuring the Client (part 3)
- Microsoft Systems Management Server 2003 : Configuring the Client (part 2) - Running Advertised Programs on Clients - Advertised Programs Wizard
- Microsoft Systems Management Server 2003 : Configuring the Client (part 1)
- Microsoft Systems Management Server 2003 : Package Distribution and Management - Creating an Advertisement
- SharePoint 2010 : Connecting and Disconnecting Servers with Windows PowerShell, Additional Functionality in SharePoint 2010
- Microsoft Dynamics CRM 4 : Digital Phone Integration (part 3) - c360 CTI for Microsoft CRM
- Microsoft Dynamics CRM 4 : Digital Phone Integration (part 2) - Cisco Unified CallConnector for Microsoft Dynamics CRM
- Microsoft Dynamics CRM 4 : Digital Phone Integration (part 1)
 
 
REVIEW
- First look: Apple Watch

- 10 Amazing Tools You Should Be Using with Dropbox

- 3 Tips for Maintaining Your Cell Phone Battery (part 1)

- 3 Tips for Maintaining Your Cell Phone Battery (part 2)
 
VIDEO TUTORIAL
- How to create your first Swimlane Diagram or Cross-Functional Flowchart Diagram by using Microsoft Visio 2010 (Part 1)

- How to create your first Swimlane Diagram or Cross-Functional Flowchart Diagram by using Microsoft Visio 2010 (Part 2)

- How to create your first Swimlane Diagram or Cross-Functional Flowchart Diagram by using Microsoft Visio 2010 (Part 3)
 
Popular tags
Microsoft Access Microsoft Excel Microsoft OneNote Microsoft PowerPoint Microsoft Project Microsoft Visio Microsoft Word Active Directory Biztalk Exchange Server Microsoft LynC Server Microsoft Dynamic Sharepoint Sql Server Windows Server 2008 Windows Server 2012 Windows 7 Windows 8 Adobe Indesign Adobe Flash Professional Dreamweaver Adobe Illustrator Adobe After Effects Adobe Photoshop Adobe Fireworks Adobe Flash Catalyst Corel Painter X CorelDRAW X5 CorelDraw 10 QuarkXPress 8 windows Phone 7 windows Phone 8 BlackBerry Android Ipad Iphone iOS
Popular keywords
HOW TO Swimlane in Visio Visio sort key Pen and Touch Creating groups in Windows Server Raid in Windows Server Exchange 2010 maintenance Exchange server mail enabled groups Debugging Tools Collaborating
Top 10
- Microsoft Excel : How to Use the VLookUp Function
- Fix and Tweak Graphics and Video (part 3) : How to Fix : My Screen Is Sluggish - Adjust Hardware Acceleration
- Fix and Tweak Graphics and Video (part 2) : How to Fix : Text on My Screen Is Too Small
- Fix and Tweak Graphics and Video (part 1) : How to Fix : Adjust the Resolution
- Windows Phone 8 Apps : Camera (part 4) - Adjusting Video Settings, Using the Video Light
- Windows Phone 8 Apps : Camera (part 3) - Using the Front Camera, Activating Video Mode
- Windows Phone 8 Apps : Camera (part 2) - Controlling the Camera’s Flash, Changing the Camera’s Behavior with Lenses
- Windows Phone 8 Apps : Camera (part 1) - Adjusting Photo Settings
- MDT's Client Wizard : Package Properties
- MDT's Client Wizard : Driver Properties
 
Windows XP
Windows Vista
Windows 7
Windows Azure
Windows Server
Windows Phone
2015 Camaro