Video - Advanced Reporting in IT Analytics

By Darren Prager at 3/22/2013 6:44 AM
Filed Under: IT Analytics, IT Analytics for Client Server Management, IT Analytics for Symantec Data Loss Prevention, IT Analytics for Symantec Endpoint Protection

This video walks through the creation of a custom dashboard utilizing the underlying cube data provided by various IT Analytics content packs, while using Microsoft Report Builder as a 3rd party authoring tool. Report Builder uses wizard driven steps to easily connect to data sources and locate the desired fields for creating a report. Users can then publish these reports back into the Symantec Management Platform console for viewing, as well as other venues like SharePoint and Reporting Services.


Video - Working with Cubes in IT Analytics

By Darren Prager at 2/12/2013 5:40 PM
Filed Under: IT Analytics, IT Analytics for Client Server Management, IT Analytics for Symantec Data Loss Prevention, IT Analytics for Symantec Endpoint Protection

The videos provide a hands-on overview of browsing cubes in IT Analytics with the various content packs. You will learn how to browse cubes and configure pivot tables and pivot charts using common usage scenarios. The ad-hoc capabilities of IT Analytics are highlighted to showcase a simple and efficient way of creating custom reports on the fly, without previous knowledge of SQL or the DLP database schema.


"The Anson Probability" or Locating CPU spikes when we don’t know when the occurred…

By Rob Reyes at 2/10/2013 7:05 PM
Filed Under: IT Analytics, OpsMgr, Root Cause Analysis

I was chatting with my friend Mr. Anson today and he asked about a use-case a number of his end users were asking about.  They were asking Mr. Anson when CPU spikes were occurring on their server.  Unfortunately, the end users did not know when these spikes were occurring, just that some users were mentioning that their experience was being effected through the day.

 
In this blog post, we will show you how to locate CPU spikes and patterns by investigating SCOM data with IT Analytics.


Finding the Spikes
We first start with the SCOM Performance Daily cube and filter on the Windows 2008 Server Management Pack and the % Processor Time counter. This is across all 2008 servers and across all dates and times.

 

 

We then add the server name (Host Entity – Display Name) and sort descending.  What is listed are servers that have spiked at 100% across all time.  There are others (75% or less) that have not.

 

Click to view larger image

 

The next result set is to only look at the machines that have spiked 90% or greater.  There are a number of servers that have not spiked significantly (75% or greater).

 

Click to view larger image

 

Next, we only look at data from 2012:

 

Click to view larger image

 

There is an even smaller set of computers that have spiked over 90% in 2012.  We'll filter on those next.

 

Click to view larger image

 

These are the servers we will now be concentrating on. Next add month to see the trend for all servers.

 

Click to view larger image

 

We will filter on VMDCFTP001 to look at the daily trend.

 

Click to view larger image

 

Since the highest spike is at the first of the year, we re-create this chart in the SCOM Performance Hourly cube to see the hourly trend.

 

Click to view larger image

 

We then filter on dates 01/04/2012 – 01/21/2012 and add the Hour dimension to see what hour the CPU spikes are occurring.

 

Click to view larger image

 

Now that we know when these spikes are occurring, we can investigate other data by changing (or adding) the Management Pack and associated counters to see what other information is being gathered on that server and correlate that data to investigate the root cause of the discovered CPU spikes.

 

 

Rob has over 11 years of experience in software implementation and sales. Since joining Bay Dynamics in 2003, Rob has held a number of technical, sales, and sales engineering positions that have made him a valuable asset to the organization. He continues to assist clients in effectively optimizing both their physical and virtual infrastructure through the use of IT Analytics.