Skip to main content

Collecting Perfmon Metrics Using a Counters Template (KBA8864)




KBA# 8864

Applicable Delphix Versions

Click here to view the versions of the Delphix engine to which this article applies
Major Release All Sub Releases





How to Collect Perfmon Metrics Using the Delphix Counters Template

Delphix Support may request Windows OS metrics to help troubleshoot performance issues. These metrics can be collected using the Windows Performance Monitor ("perfmon").

To assist in capturing the relevant data Delphix has created a template counters file containing the minimum counters generally required to progress performance related issues. The following instructions detail how to configure a Data Collector Set using the Delphix Template. The captured metrics can be written to a file or CSV.

The Delphix template is not a necessity, it is also possible to manually create a collector set. The following is a useful list of counters that should be included:

\Processor(*)\% Processor Time
\Processor(*)\% Privileged Time
\Processor(*)\% Idle Time
\Processor(*)\% Interrupt Time
\Processor(*)\% User Time
\VM Processor(*)\% Processor Time
\VM Processor(*)\CPU stolen time
\VM Memory\Memory Ballooned in MB
\VM Memory\Memory Reservation in MB
\VM Memory\Memory Swapped in MB
\Memory\Available Bytes
\Memory\Cache Bytes
\Memory\Pool Nonpaged Bytes
\Memory\Page Reads/sec
\Memory\Page Writes/sec
\Network Interface(*)\Bytes Received/sec
\Network Interface(*)\Bytes Sent/sec
\LogicalDisk(*)\Avg. Disk sec/Read
\LogicalDisk(*)\Avg. Disk sec/Write
\LogicalDisk(*)\Disk Read Bytes/sec
\LogicalDisk(*)\Disk Write Bytes/sec


Create the Collector Set Using the Template

  1. Download the template file, Delphix_perfmon.xml . Copy it to the host to be monitored.
  2. Import the file into Perfmon on the target host ( for example on the host machine hosting a SQL server vdb being investigated)  via creating 'User Defined' collector set:
    1. Access Perfmon. Examples:
      1. Via Windows Search: Open the Start Menu, search for Performance Monitor, and launch the Performance Monitor 
      2. Via Administrative Tools: Open the Control Panel and navigate to System and Security > Administrative Tools, then double-click the Performance Monitor shortcut.
    2.  Right-click User Defined under Data Collector Sets, and then click New.

    3. On the Create new Data Collector Set dialog, provide a new name for the collector set and select Create from template.

    4. Click Browse, and then find the template file provided above. Select the file and click Open.

    5. Select the template and click Next.
    6. Specify where the data/output file should be saved​, click Next, specify which user you want to run Perfmon (one that has the correct privileges), then click Finish.

  3. Do not forget to change the output log format (right-click on the Data collector name, then click Properties) within the Performance Counters tab, change Log format to Comma Separated, and then and click Apply. Selecting comma separated results in a .csv output file.
  4. To start Perfmon metrics/counters data collection, right-click the Data Collector set, and then click Start.
  5. To stop collecting data, right-click on the Data Collector Set, and then click Stop.