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-vdi-performance-summit

The VDI Performance Summit - Virtual Conference and Expo

Visit the VDI Performance Summit to gain knowledge and experience about performance and tuning VDI, improving End-User Experience and IT service. Join us at the ONLY virtual event 100% dedicated to VDI performance and tuning | May 2, 2019 This 1-day event offers key-notes presented by the best VDI performance experts in the world, technical and business oriented breakout sessions, the possibility to chat with experts directly to discuss your own situation, and a virtual exhibit hall featuring… Continue Reading

Scalability testing Parallels Remote Application Server with Login VSI

Recently I went to VMworld in Barcelona where Login VSI had a booth on the expo... While I can’t remember exactly how many conversations I had - there had been so many that I lost my voice on day one. What was new this year is that quite a few people asked if our software is compatible with the solutions from Parallels specifically their Remote Application Server (RAS) (Datasheet). Continue Reading
Login VSI Blog Article - Microsoft Windows 10 Default FTA Associations - Teaser Image

Windows 10 Default File Type Associations and Login VSI

When Login VSI 4.1 was released, the majority of desktops were running Windows 7 and life was easy. We’d set the default filetype for an application and it would simply work. The default and industry standard workloads in Login VSI include launching and using Adobe Reader as part of the virtual user simulation. Because Login VSI doesn’t always know which version of Adobe Reader is installed, or where it’s installed, the workload relies on the file type association (FTA) for .pdf documents to be… Continue Reading
Login VSI - Press Release - IGEL - Login VSI Partner to Optimize End User Computing Experience Image

[Press Release] IGEL Partners with Login VSI to Optimize the End User Computing Experience

Login PI enables organizations to better protect the performance and availability of their IGEL OS-powered virtual desktop environments San Francisco, USA, Feb. 6, 2019: IGEL, a world leader in software-defined endpoint optimization and control solutions for the secure enterprise, today announced that it is partnering with Login VSI, provider of software solutions to test and actively monitor the performance and availability of virtual desktop environments, including VDI and… Continue Reading
Login VSI - Blog - Login PI Blog Teaser Image - Windows Virtual Desktop: How To Monitor User Experience With Login PI

Windows Virtual Desktop – How to Monitor User Experience?

Microsoft has just announced the public preview of their new Windows Virtual Desktop (WVD) offering at Microsoft Ignite on Tour in Amsterdam today. For those of you who’ve not followed the rumors or the private beta, here’s the outline... Continue Reading
Investigating Online Application Performance with Login PI

Investigating Online Application Performance with Login PI

As many companies do, we use a CRM system. Recently, I have been getting complaints about our cloud CRM system, Microsoft Dynamics, being slow. I tried to investigate this by shadowing one of our users to see what was wrong. As expected, everything was fast. 15 minutes later, the same user reported slowness again. How could I investigate this without bothering the users? Continue Reading
Cookie Settings