login vsi company logo login vsi company logo 250x40
  • 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.

About the author

Ryan Bijkerk (@Logitblog) is a Product Owner at Login VSI and a Microsoft MVP on Application Virtualization (App-V) technology. He is also involved in the independent research Project VRC and speaks at events. Besides working, Ryan enjoys writing for his blog and riding his MTB.


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

Popular Blogs

Login VSI - Blog - 4 Things to Consider when Running Office 365 in the Cloud

4 Things to Consider when Running Office 365 in the Cloud

Recently a customer decided to move their entire VDI infrastructure into the cloud. The VDI environment was approximately 20,000 users. As you can imagine there are a lot of design decisions necessary to ensure the success of this migration. Continue Reading
What's New in Login PI 3.6?

What's New in Login PI 3.6?

Public API, Enhanced support for Published applications, RDS Broker/Gateway and SQL Databases! Last month we released a new version of Login PI 3 (3.6), bringing more features and functions to the product. The biggest additions are a RESTful Public Web API, improved support for Citrix Virtual Apps (Published Applications), a connector for a RDS Broker and Gateway and the ability to now connect the virtual appliance to a Microsoft SQL Server database. Continue Reading
Login VSI and Ymor Form Partnership to Deliver Performance Improvement to Business-Critical Applications

[Press Release] Login VSI and Ymor Form Partnership to Deliver Performance Improvement to Business-Critical Applications

The partnership offers a total solution for enterprise organizations to monitor and test business-critical applications from end-to-end via VDI or in the Cloud. Ymor offers various monitoring solutions, used to test and monitor the performance of critical business chains from end-to-end. In VDI environments, Ymor can now offer the monitoring solutions of Login VSI. Continue Reading
[Press Release] IGEL Expands Alliance with Login VSI; Integrates Login Enterprise into IGEL OS 11.03

[Press Release] IGEL Expands Alliance with Login VSI

Integrating Login Enterprise into IGEL OS 11.03 The combined solution enables IT organizations to leverage their IGEL infrastructure to continuously test the performance and availability of virtual and cloud workspaces. Continue Reading
Windows Virtual Desktop - Update - December 2019

Windows Virtual Desktop Enhanced in the Latest Update

A lot has already been written about WVD in the last months. And while I had my initial concerns on this service many people are suggesting that they are willing to move to a platform like WVD in the next two years. Continue Reading
How Using a Virtual User can Quantify the Performance of SAP and Citrix

How Using a Virtual User can Quantify the Performance of SAP and Citrix

When interacting with enterprise applications, the user experience is important. Users must be able to smoothly and efficiently interact with the application to be productive and achieve the goals of the enterprise. The applications are expected to be responsive, dependable, and consistent in their presentation. Continue Reading