Skip to content

Analyzing Performance with Server Performance Advisor 3.0


In this post I will address the use of the SPA, how to install it and what information return to assist the system administrator.

This recently updated tool for Windows 2012 is available in


When you run the application folder will be created with the binaries and configuration files of the SPA, as the image below, where you should run the SPAConsole.exe to perform the installation:

13-03-2013 13-30-51

The installation does not create any database or install SQL Express or another, but only installs the binaries required for running the application. The whole setup is performed on the first run, when creating projects.

Creating Analysis

To open the SPA create a project, what sets the database to store the server data analyzed. Below the project configuration screen:

13-03-2013 13-31-15

13-03-2013 13-31-46

In the sequel we choose which packages will be reviewed and may be Hyper-V, IIS and Windows Server Core:

13-03-2013 13-32-22

Following you define the servers that will be reviewed, and you can add or remove servers later, just by editing the project. Note that for each server will be created a shared folder where the SPA will write data and use for the metrics:

13-03-2013 13-34-41

13-03-2013 13-35-19

Running analyses

The next step is to run the analyses, by choosing the desired monitoring packages:

13-03-2013 13-35-00

13-03-2013 13-35-08

During the execution of analyses will be shown a screen monitoring, which can take a long time, both because of the number of servers as well as the amount of data in each of the selected analysis packages:

13-03-2013 13-35-23

After the execution, we see a dashboard with data alerted in each of the desired analysis packages:

13-03-2013 13-53-05

Analyzing the Data Collected

As can be seen in the image above, next to each server and analysis package it is possible to show the individual report. Are very presentable and well reports with drill-down of each item that was analyzed.

For example, below we see the CoreOS report where we have the alert notifications configuration details, CPU, memory, disk, and network. Note that the data contains the details of the analysis, while the notifications tab summarizes the problems encountered with suggestions of how to solve the bottleneck found:

13-03-2013 13-53-15

In addition to the notifications tab, in each one of analyzed data it is possible to compare with previous analyses on the button Actions >> as the example below where we are comparing previous network reports:

13-03-2013 13-54-34

Another form of data visualization is using performance charts. To do this click on the button next to each analysis package and choose the period that will be used for the drawing of graphics:

13-03-2013 13-54-54

Very similar to System Center Operations Manager dashboards, the SPA mount allowing graphs choose between all counters analyzed and summarized:

13-03-2013 13-55-11

After you select the period and the counters, the graph can be viewed as a general summary, by day of week or time of day in each of the 3 tabs.

13-03-2013 13-56-33


With this simple and functional application is possible that administrators have a detailed view of the performance of the servers, compare with previous analyses after making the corrections and updates, and finally presenting data consistently when necessary to justify investments in it.

  1. mete permalink

    Thank you for clear installation guide. When I run it for IIS after finishing collecting data it gives error logs stack trace as follow. Did it work well for IIS ? It works ok for ServerCore advisor BTW.

    (Sql 2014)

    SpaCore.dll Warning: 0 : Failed to generate report at: 28.5.2014 11:35:35.
    ========== Summary ==========
    + SpaException: Failed to generate report at: 28.5.2014 11:35:35.
    + SqlException: Conversion failed when converting the nvarchar value ‘Date-UTC’ to data type int.
    Warning! The maximum key length is 900 bytes. The index ‘idx’ has maximum length of 1208 bytes. For some combination of large values, the insert/update operation will fail.
    Warning: Null value is eliminated by an aggregate or other SET operation.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: