login vsi company logo login vsi company logo 250x40

 

Get the best possible VDI performance, density and availability with Login VSI
Our Solutions

  • Home
  • Blog
  • Login VSI
  • Quickly parse and filter external performance data with PPD - Login VSI Tips and Tricks

Quickly parse and filter external performance data with PPD - Login VSI Tips and Tricks

Quickly parse and filter external performance data with PPD - Login VSI Tips and Tricks

If you ask the Login VSI support department what they think is the most important part of a Login VSI test they will probably reply with “performance data”. External performance data from VMware ESXtop or Microsoft Performance Monitor is extremely valuable to fully understand the impact of a Login VSI test in a centralized desktop environment. But when it comes to parsing or filtering this performance data, it can be a pain in the butt because of three reasons:

1. Performance data files can be very large. The ESXtop file in the screenshot below is over 60MB.

login vsi tips and tricks quickly parse and filter external performance data with ppd large esxtop file

2. Loading this file takes quite some time and this can cause errors.

login vsi tips and tricks quickly parse and filter external performance data with ppd excel error esxtop file

3. Headers can be very difficult to read and this makes it difficult to locate the right metrics.

login vsi tips and tricks quickly parse and filter external performance data with ppd esxtop file headers

PPD (Parse Performance Data)

Even with the useful PowerShell trick from Mark Plettenberg “Login VSI Tips and Tricks: Cleaning up ESXtop log files using PowerShell” this still can take a while. Since I am performing a lot of performance tests with Login VSI, I was tired of having to wait a long time to collect external data so I decided to create a tool myself. This tool, named PPD (Parse Performance Data), can save your day in parsing/filtering these large CSV files.

PPD is a small command line based tool which filters these files and creates a clean Microsoft Excel sheet including charts (usually within seconds). This is done based on the metrics you specified that needs to be collected. It even creates charts so you quickly can see the trend in the metrics of the test.

You can download this tool for free right here.

You can use PPD by following these four easy steps:

1. Download PPD.zip and extract the files

2. Use Metrics.txt to configure the metrics that you would like to collect.

login vsi tips and tricks quickly parse and filter external performance data with ppd metrics txt

3. Open a command prompt and run PPD.exe with the /f and the CSV file as parameter.

login vsi tips and tricks quickly parse and filter external performance data with ppd cmd exe

4. Locate and open the new Excel sheet in the same directory

login vsi tips and tricks quickly parse and filter external performance data with ppd xlsx file

5. Done! The Excel sheet (in this case with VMware ESXtop performance data) even includes charts

login vsi tips and tricks quickly parse and filter external performance data with ppd vmware esxtop xlsx

It’s that easy. If you are doing a lot of performance tests with Login VSI, this tool is a must have in your toolkit!

Please note that I created this tool myself and I am offering this for free to the community. Login VSI does not offer any support for this tool.

 


 

Start using Login VSI today

Our industry-standard software is built to help you avoid problems, lower costs and improve performance. Request a Quote or get your free Trial below, and benefit from our award-winning services.

Free Price Request  Your Free Trial

 


About the company Login VSI

The company Login VSI provides end-user performance insights for virtualized desktop and server-based computing environments. Enterprise IT departments use flagship product Login VSI (for load testing) and Login PI (for continuity testing) in all phases of their virtual desktop deployment—from planning to deployment to change management—to build and safeguard a good performance, a high availability, and (as a result) a good and consistent end-user experience. For more information about Login VSI or for a free test license contact us.

Tags: How-to, Login VSI, Load Testing, Support, Scripts

Popular Blogs

Login VSI Blog - Ongoing Effects CPU Flaws

The Ongoing Effects of Intel CPU Flaws

The Ongoing Effects of Intel CPU Flaws Over the last year, we’ve seen many Intel CPU hardware flaws come to light and when news first broke about Meltdown & Spectre there was a lot of panic: "should we patch?", "What’s the performance impact?", "Can we still rely on this hardware?" Continue Reading
Login VSI Blog - Updating to Windows 10 1903? Make Sure to Test!

Updating to Windows 10 1903? Make Sure to Test!

Updating to Windows 10 1903? Make Sure to Test! It’s that time of the year again. Microsoft have released their spring update and the first IT-Pro’s are getting ready to move their VDI environment over. Continue Reading
Login AT Express offers Application Compatibility Testing for up to 50 applications for FREE

[Press Release] Login VSI introduces free license for award winning solution, Login AT

Login AT Express offers Application Compatibility Testing for up to 50 applications for FREE Atlanta, USA, May 22, 2019: Login VSI, the industry standard for VDI and SBC performance testing, announced today the availability of a new, free version of Login AT for Bulk Application Compatibility Testing. Continue Reading
Login VSI Blog - LVTE 2109 - Technology Advocates & Experts

Login VSI Technology Advocates and Experts 2019

About a year ago Login VSI, the industry standard in VDI performance testing, announced a new program Recognizing those individuals that have built and displayed extensive knowledge of the Login VSI software solutions, and visibly contribute to the End-User Computing (EUC) Community. Continue Reading
Introducing Login PI 3.4

Introducing Version 3.4 of Login PI

What’s New & Different - Introducing Version 3.4 of Login PI We've updated Login PI, the benchmark in unplanned-change and gradual-deterioration detection for VDI. New features include improving the way information is collected & distributed, the way customized workloads are created & the way actual tests are executed. Continue Reading
Login VSI Blog - What's New in Login PI 3.5

What's New in Login PI 3.5?

What's New in Login PI 3.5? Netscaler, SLA Reporting, Event Logging features and so much more! At the end of June, we released a new version of Login PI 3 bursting with new features and enhancements. There are so many that I could write pages of blog about it, but let’s just keep it simple and focus on some of the big items. Continue Reading
Cookie Settings