Configuring .Net Application Performance Monitoring in SCOM 2012 and Analyzing with IT Analytics

By Rob Reyes at 8/19/2011 9:17 AM
Filed Under: APM, Application Performance Monitoring, AVIcode, Install/Config, IT Analytics, OpsMgr, SCOM 2012

System Center Operations Manager (SCOM) 2012 beta is here!  The goal of this post is to demonstrate how to configure .Net Application Performance Monitoring in SCOM 2012, and then analyze that data with IT Analytics.

 

AVIcode Configuration

 

After SCOM 2012 has been installed and SCOM agents deployed, we then configure Application Performance Monitoring (APM).  All of the necessary agent functionality is now integrated within the SCOM 2012 agent.  All we need to do is configure a monitor to get up and running!

 

First, APM is .NET exclusive in 2012, so we need to identify and create a monitor for a specific .Net Application.  We click on "Add Monitoring Wizard", as shown on the following screen:

 

Click to view larger image

 

On the first page, we select the type of monitor:

 

Click to view larger image

 

Next, we name the monitor, give a brief description and select and existing Management Pack (MP) or create a new MP. In our example we created a new MP named AVIcode. Please note that the Monitor name cannot be changed once created.

 

Click to view larger image

 

On the next page, we specify what sites we are going to monitor.  The SCOM 2012 agent is able to scan and return .NET compatible applications.  This discovered data populates the component list, making it easier to select which applications to monitor.

 

 

In SCOM 2012, AVIcode monitors are specific to the application, regardless of what server it is located on.  To track performance of an application on a specific server, you specify these servers by clicking on the "Search" button in the Monitored Servers section and select any default group or user created groups.

 

Click to view larger image

 

For Server Side Monitoring, we leave the default options and performance event threshold.  We click on the checkbox so we can gather data on the end user experience as well.

 

Click to view larger image

 

Here, we have enabled client side monitoring for the site we are interested in.  We have not excluded any pages at this time.

 

Click to view larger image

 

This next page allows us to refine the monitor even more.

 

Click to view larger image

 

Last page is a summary of the settings.

 

Click to view larger image

 

Now that our monitor is created the final sep is to restart IIS on any servers the monitor applies to in order to enable monitoring.

 

Out of the box Reporting

The SE Viewer has been brought back in SCOM 2012, see:

 

Click to view larger image

 

The raw performance data about the site can bee seen at the URL http://localhost/AppDiagnostics/ on the SCOM server.

 

Click to view larger image

 

Management Pack reporting is consistent as well:

 

Click to view larger image

 

AVIcode Data Analysis with IT Analytics

To view all the available AVIcode/APM performance data, we create a pivot view where we filter on the "Operations Manager APM Library" and break this down by the available counters.

 

 

We filter on the "Avg. Request Time" counter and add "Entity - Name" to see each site we are tracking.

 

Click to view larger image

 

Next, we will convert this in to a chart.

 

Click to view larger image

 

To investigate that API further, I switch back to a table, filter on that App and look at the daily trending.

 

Click to view larger image

 

The 11th of August has an unusual spike.  I'll filter on that date and add "Performance Evaluation Time - Hour" to my table to get more detail.

 

Click to view larger image

 

Looks like this spike was an anomaly.  To see the trending for the remainder of the day, I exclude the "0" hour, and change this table to a chart.

 

Click to view larger image

 

Summary

The tighter integration of .Net Performance Monitoring in to SCOM 2012 will prove very beneficial, and the setup is fairly straight forward.  Once that data has been collected, the OpsMgr cubes in IT Analytics enable you to analyze that APM/AVIcode data in a fast and flexible manner, giving you the insight you need when you need it! 

Using IT Analytics as a datasource for a Reporting Services Drilldown Report

By Rob Reyes at 8/9/2011 4:29 PM
Filed Under: IT Analytics, OpsMgr, Private Cloud, SSRS, VMware

Most out of the box reports are designed to answer a specific question at a given point in time. However, business requirements change frequently and limit the effectiveness of out of the box reporting. These changes require the constant tuning and even recreation of standard reports. By using IT Analytics for Microsoft System Center, another option is creating a drill down report that shows a high level summary of key data that also allows the user to click on the report to view detailed information.

 
In this post, we will show you how to quickly and easily create your own custom drill down report using IT Analytics and SQL Server Report Builder.
 

For this use case, our reporting requirement is to list the number of machines that require a software update and the percent complaint. We also want the ability to click on the required computers count to see a list the computers that require that software update. 

 
To make this drill down report possible, we will follow a three step process: create an overview report, a details report, and finally the necessary parameters.
 
Overview Report 
Using the steps outlined in a previous post, we create a report that includes the software update, the count of required computers, and the count of installed computers.  Lastly, we create a calculated field showing overall compliance for a bulletin.
  
 Click to view larger image
 
 Here is a preview of the report.
 
Click to view larger image
 
 
Details Report 
For the Details Report, we include the bulletin name, computer name and required computer count:
  
Click to view larger image
 
Here is a preview of the report:
 
Click to view larger image
 
 
Parameters 
 
To make the drilldown work, we need to add a parameter on both reports to pass the correct value to present the correct information.
 
On the Patch_L1 report, in the "Required Computer Count" column, we right click to bring up the "Text Box Properties" dialog box:
 
  Click to view larger image
 
For now, we leave the default options and only edit the "Actions" section:
 
 
 
In "Actions," we click "Go to Report" and select the "patchdetails" report.  
  
 
 
We also add a parameter called "pSoftwareUpdate" and the following formula:
 
="[Software Update].[Software Update - Bulletin ID].&[" +Fields!Software_Update___Bulletin_ID.Value + "]"
 
This formula will contain the same values as presented in the report.
 
 
Next, in the "patchdetails" report, we will add a new parameter:
  
Click to view larger image
  
 On the first page, we will give the parameter a name, title, data type and make the parameter visible.  
  
  
  
Next, we will set the available values.  We will get the values from a query to the dataset so the values match.  The parameter dataset is the same dataset used for the report, the value field is set to "ParameterValue" and the label field is "ParameterCaption."  The reason we recommend these settings is to match the data as it exists within IT Analytics.
  
 
To maintain consistency, we set the default value to "All." The formula used below is a direct reference to the IT Analytics cube:
  
 
 
Last, we leave the default settings:
 
 
 
Report Review
In the overview report, we now see that our cursor changes when we hover over the "Required Computer Count" number.
 
Click to view larger image
 
Here is the resulting details report:
 
Click to view larger image
 
 
Summary
Using the power of Report Builder and the available data within IT Analytics, we were able to build out a detailed drilldown report in a very short time without writing any additional code or SQL queries.  Our admins are able to present data quickly and easily, while our management team is informed and can navigate the data at their convenience!