Hyper-V

Monitoring Hyper-V Performance with Server Performance Advisor

Monitoring Hyper-V Performance with Server Performance Advisor provides a great way to collect performance data in Hyper-V and compare to best practices

When working with virtualization platforms, monitoring gathering information concerning performance is a necessary part of keeping an eye on key performance indicators in the environment. When working with Microsoft Hyper-V as a virtualization platform, there are a lot of third party tools out there that can gather performance information from Hyper-V environments. However, there is a free tool from Microsoft that allows pulling information from Hyper-V environments and analyzing them based on built in templates for analysis. Let’s take a look at Monitoring Hyper-V Performance with Server Performance Advisor and see how this little utility provides some really great insights into a Hyper-V environment.

Server Performance Advisor Requirements and Installation

Server Performance Analyzer is an aging tool, however, provides some really good insights into performance with a variety of products. Server Performance Analyzer is a little tool that can help with the following things in a server infrastructure environment:

Manage server performance and troulbeshooting performance issues
Providing reporting and recommendations regarding configuration and performance issues
Provide recommendations based on collected data

The great thing also about Server Performance Analyzer is that it contains specific Advisor Packs for various Microsoft Products. It includes the following Advisor Packs by default

  • Microsoft Hyper-V Advisor Pack V2
  • Microsoft AD Advisor Pack
  • Microsoft CoreOS Advisor Pack V2
  • Microsoft IIS Advisor Pack V2

However, more can also be downloaded and implemented into the Server Performance Advisor. This allows it to have specific expertise according to Microsoft Best Practices recommendations for those products.ย  Additionally, the features of SPA allow for the following according to Microsoft:

  • Can perform analysis against servers running Windows Server 2012 R2, Windows Server 2012, Windows Server 2008 R2, and Windows Server 2008.

  • Supports remote analysis capability, which allows SPA 3.1 to collect and analyze data from a central console, with no need to install code on the servers to be analyzed.
  • Uses a Microsoft SQL Server for data analysis and storage, which enables processing and storing large amount of data.
  • Separates the tool from the Advisor Packs. Performance analysis logic for each server role is released in the form of an advisor pack, which can be released or updated separately from the tool.
  • Provides Advisor Packs that are developed in SQL scripts with an open architecture. Non-Microsoft parties can develop advisor packs or extend the existing advisor packs from Microsoft to cover special needs.
  • Supports new features like side-by-side comparison reports, and trend and historical charts to help you find abnormalities.
  • Provides features such as modify, import, and export thresholds to help you fine tune the reports and notifications and share those tunings with other SPA users.
  • Supports multiple projects, which can be used to group targeted servers.
  • Provides recurring data collection from within the SPA console.
  • Enables custom queries and report generation by using Microsoft SQL Server (for advanced users).
  • Customized Windows PowerShell cmdlets are available to use with SPA
  • Backward compatible for importing and viewing reports from a SPA 3.0 database

A note with regard to the above, in my testing, I ran the SPA utility against a Windows Server 2016 Server running Hyper-V and it seems to work fine.

Installing Server Performance Advisor is fairly straightforward.ย  The installation is downloaded as aย CAB file instead of an executable, msi, etc.ย  You can download the CAB file here:

Once you have the CAB file downloaded for your specific architecture, you can extract the CAB file by using the commands:

  • 32-bit systems –ย extrac32.exe /e /a /l “d:SPA” “d:SPASPAPlus_x86.cab”
  • 64-bit systems –ย extrac32.exe /e /a /l “d:SPA” “d:SPASPAPlus_amd64.cab”

Monitoring Hyper-V Performance with Server Performance Advisor

After extracting the CAB file, simply launch theย SpaConsole.exe file in the folder created during the extraction.

Launching-Server-Performance-Advisor-after-extracting-CAB-file
Monitoring Hyper-V Performance with Server Performance Advisor

Click onย File >> New Project to begin creating a new Hyper-V project for analyzing Hyper-V servers.

Creating-a-new-project-in-Server-Performance-Advisor
Creating a new project in Server Performance Advisor

Part of the New Project Wizard that launches is configuring an SPA project database.ย  You will need to have access to a SQL Server for this purpose.

Starting-the-SPA-Project-Configuration-Wizard
Starting the SPA Project Configuration Wizard

The New Project Wizard will create the DB so no need to create it beforehand.

Creating-a-Server-Performance-Advisor-Database-for-projects
Creating a Server Performance Advisor Database for projects

Here you can provision advisor packs.ย  The screen I captured below didn’t correctly see the advisor packs that are included as in my case the extraction didn’t work correctly on the first run.ย  I re-extracted the CAB and was able to see the included advisor packs.ย  We will see them below.

Provisioning-Advisor-Packs-Server-Performance-Advisor
Provisioning Advisor Packs Server Performance Advisor

Here on theย Configure Servers screen, you setup the connections to your Hyper-V servers.ย  The File Share Location must also be populated.ย  This is where the logs will be stored from SPA.

Configuring-Hyper-V-Server-connections-Server-Performance-Advisor
Configuring Hyper-V Server connections Server Performance Advisor

Now, we have the connections setup for the Hyper-V servers.ย  You can simply check the box next to the servers or the check all box, and then hit theย Run Analysisย button.

Hyper-V-Server-connections-established-in-Server-Performance-Advisor
Hyper-V Server connections established in Server Performance Advisor

If like me, you want to make sure you have the correct Advisor pack(s) configured, click tehย Configurationย >> Configure Advsior Packs menu option.ย  Note, below, theย Microsoft Hyper-V Advisor Pack V2ย is not installed.ย  Click the pack and hit theย Provision button when it activates.

Configuring-Hyper-V-Advisor-Pack-in-Server-Performance-Advisor
Configuring Hyper-V Advisor Pack in Server Performance Advisor

After provisioning, you will see theย Installed Version column populated.

Hyper-V-Advisor-Pack-installed-in-Server-Performance-Advisor
Hyper-V Advisor Pack installed in Server Performance Advisor

In the Run Analysis screen, choose the advisor pack you want to use in the run.ย  Here is where you also configure the run duration and you can also choose toย Repeat collection everyย option.

Running-Analysis-with-the-Hyper-V-Analysis-Pack
Running Analysis with the Hyper-V Analysis Pack

Next, you will be prompted to enter credentials for the target servers.

Prompted-to-enter-credentials-for-Hyper-V-Server-connections
Prompted to enter credentials for Hyper-V Server connections

The data collection begins collecting data.

Analysis-of-Hyper-V-servers-running-collecting-data
Analysis of Hyper-V servers running collecting data

After the run finishes, you will see three buttons in the results for each server that allow the following:

  • View Latest Report
  • Find report
  • View Charts
Viewing-results-of-the-analysis-collection-against-Hyper-V
Viewing results of the analysis collection against Hyper-V

In clicking the View Charts option, you will get to pick the server, advisor pack name and the start and finish dates for displaying the data.

Viewing-Chart-Data-from-Hyper-V-Server-Performance-Advisor-run
Viewing Chart Data from Hyper-V Server Performance Advisor run

Very similar to Performance Analyzer, Server Performance Advisor displays the relevant data.

Chart-data-from-Hyper-V-after-a-Server-Performance-Advisor-data-collection-run
Chart data from Hyper-V after a Server Performance Advisor data collection run

In my opinion, the real value in this took is in the reporting side.ย  Here, SPA actually gives recommendations based no the analyzing of data from the run.ย  As you can see, the SLAT support is flagged for this host (running as a nested ESXi installation).

Viewing-the-Server-Performance-Advisor-Report-from-the-data-collection
Viewing the Server Performance Advisor Report from the data collection

Takeaways

Monitoring Hyper-V Performance with Server Performance Advisor provides a powerful way for Hyper-V administrators to collect performance data and also have recommendations based on best practices provided by Microsoft.ย  The built-in advisor packs allow having very specific expertise applied base on the product being analyzed, as in this case – Hyper-V.ย  The tool is easy to install, provision, and intuitive to operate.ย  Be sure to check out SPA if you are looking at Monitoring Hyper-V Performance and also maybe looking to validate a Hyper-V installation.

Subscribe to VirtualizationHowto via Email ๐Ÿ””

Enter your email address to subscribe to this blog and receive notifications of new posts by email.



Brandon Lee

Brandon Lee is the Senior Writer, Engineer and owner at Virtualizationhowto.com, and a 7-time VMware vExpert, with over two decades of experience in Information Technology. Having worked for numerous Fortune 500 companies as well as in various industries, He has extensive experience in various IT segments and is a strong advocate for open source technologies. Brandon holds many industry certifications, loves the outdoors and spending time with family. Also, he goes through the effort of testing and troubleshooting issues, so you don't have to.

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.