How to get performance monitor data in different formats

     After creating the data collector set in the performance monitor we need to get the report to analyze it further. There are 4 types of formats available in performance monitor to record the data. Types are as below

• Comma Separated
• Tab Separated
• SQL
• Binary

How to change data format for the data collector set

By default, all new data collector set will record data of type binary. Means graph. There are 2 ways to get the data in other formats. 

1. Can convert the recorded data to another format
2. Can make perfmon to record data with a defined format

How to convert data of one format to another in perfmon

1. Create a data collector set. Already covered in this article
2. Start the data collector set
3. After doing some action stop the data collector set
4. Logfile location will be set while creating the data collector set. Navigate to that folder
5. You will find the perfmon data file. Double click on that file
6. The graph will open. Right-click on the graph and select save data as
7. Store the file in the required format.

Data file 

How to change perfmon data type from one type to another

        1.  Once the data collector set is created navigate to that data collector. Left-click on the collector

    

        2. Double click on the collector name in the right panel. A window will be prompt

        3. Change the data format using the Log Format field

        4. Click Apply and then OK

I have created 4 data collector sets of different data formats. I started the data sets of different data formats. After some time stopped the collectors analyze the data. 

Navigate to respective folders and check the reports or check from perfmon data

We can also check reports from perfmon under the reports field

Comment us if any query on this post