Skip to main content
Delphix

Collecting Perfmon Metrics Using a Counters Template (KBA8864)

 

KBA

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
6.0

6.0.0.0, 6.0.1.0, 6.0.1.1, 6.0.2.0, 6.0.2.1, 6.0.3.0, 6.0.3.1, 6.0.4.0, 6.0.4.1, 6.0.4.2, 6.0.5.0, 6.0.6.0, 6.0.6.1, 6.0.7.0, 6.0.8.0, 6.0.8.1, 6.0.9.0, 6.0.10.0, 6.0.10.1, 6.0.11.0, 6.0.12.0, 6.0.12.1

5.3

5.3.0.0, 5.3.0.1, 5.3.0.2, 5.3.0.3, 5.3.1.0, 5.3.1.1, 5.3.1.2, 5.3.2.0, 5.3.3.0, 5.3.3.1, 5.3.4.0, 5.3.5.0, 5.3.6.0, 5.3.7.0, 5.3.7.1, 5.3.8.0, 5.3.8.1, 5.3.9.0

5.2

5.2.2.0, 5.2.2.1, 5.2.3.0, 5.2.4.0, 5.2.5.0, 5.2.5.1, 5.2.6.0, 5.2.6.1

5.1

5.1.0.0, 5.1.1.0, 5.1.2.0, 5.1.3.0, 5.1.4.0, 5.1.5.0, 5.1.5.1, 5.1.6.0, 5.1.7.0, 5.1.8.0, 5.1.8.1, 5.1.9.0, 5.1.10.0

5.0

5.0.1.0, 5.0.1.1, 5.0.2.0, 5.0.2.1, 5.0.2.2, 5.0.2.3, 5.0.3.0, 5.0.3.1, 5.0.4.0, 5.0.4.1, 5.0.5.0, 5.0.5.1, 5.0.5.2, 5.0.5.3, 5.0.5.4

How to Task

Delphix Support may request Windows OS metrics that can be collected using the Windows Performance Monitor ("perfmon").  In this note we show how to configure a Data Collector Set that can be used to collect metrics or perfmon counters that may be useful for Delphix Support when investigating issues relating to vdb performance. The captured metrics can be written to a file or CSV. To save time, we provide in this note a template counters file containing the minimum counters we need to be collected . The collection should be started from just before , during and until after the performance issue/slowdown finishes. The collection could be ended earlier providing we have collected through a good time of the performance slowdown.
 

If you choose to create your own collector set , at a minimum,  the following is a useful list of counters to to be collected:

\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:
      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.
      3.  right-click on 'User Defined' under Data Collector Sets, select New

        ​​
      4. Under the 'Create new Data Collector Set', give a new name for the collector set and ensure that
        'Create from template'  is selected/enabled, as below:

      5. At the next screen, select 'Browse' and find the template file we have provided, and select the file and click 'Open':

      6. Select the template and click on Next
      7. At next screen , specify where the data/output file should be saved​, click on Next, specify which user you want to run Perfmon with , that has correct privileges, then click on Finish.


         
  3. Don't forget to change the output log format  (right-click on the Data collector name, then click on 'Properties)  and within the 'Performance Counters' tab, change Log format to 'Comma Separated'  and click on 'Apply'. Selecting 'comma separated' results in a '.csv' output file.

4. To start Perfmon metrics/counters data collection simply right click on the  Data Collector set, and select 'start'.

    To stop collecting data, right-click on the Data Collector Set, and then choose 'stop'.

 

Delphix_perfmon.xml

Related Articles

The following articles may provide more information or related information to this article:

  • link
  • link
  • link