Advanced Windows PowerShell Scripting Video Training

Advanced Windows PowerShell Scripting Video Training
Advanced Windows PowerShell Scripting Video Training

Wednesday, October 31, 2012

Export Your Performance Monitor Data to Excel

Updated: 2016MAY04

To clarify when this functionality is available, you can only save the view when you are viewing a Data Collection Set.  The "live" data cannot be saved in this way.

Performance Monitor in Windows Server give us the ability to see when our servers are having some issues.  Analyzing that data into something meaningful can be a problem.  You can export your data to Excel so you can better see what your performance data represents. 
First collect your data.
image
Right click the graph and select Save Data As.
Change the Save as type to Text file (comma delimited)(*.csv).
Give the file a name and save it where you want to store it.
Now open that file on a client with Excel installed on it.  By using excel, you will be able to present the data in a more meaningful format.

6 comments:

Saurabh Sinha said...

Thanks for this post jason, This helped me to analyse my data well

Jason Yoder, MCT said...

Saurabh,

Don't forget to look into PowerShell to help you analyze your data.

Jason

Anonymous said...

This would've added a lot more value to the internet if you explained how to create a graph from the output data, its not hard to double-click a CSV file.

Jason Yoder, MCT said...

Hey Anonymous,

Take a look at Technet or Bing/Google how to use Performance Monitor. Instructions on how to create this information is widely available.

Take care,
Jason

Deepak Rao said...

"Save Data As" is disabled. How to enable it?

Jason Yoder, MCT said...

The "Save data As" works only with Data Collection Sets, which is one of the features of Performance Monitor. I will update the blog to reflect this. You cannot do it with the live view, but only recorded data.