Wednesday 26 February 2014

Using Systems Capacity Data for Business Intelligence (5 of 9)


I promised you more sample reports of KPI’s and the next example is storage for IBM SAN controller running on SQL servers.


This information shows metrics bought in as a stacked chart so that you can see the total storage used for this group and you can then use this information for trending, to see when your storage is going to be a problem.

Next I’ve used the same storage example as a trend. I have aggregated all of the sequel servers up and you can see how this will look when you trend it.


This type of information allows us to be proactive as an organization, identifying ahead of time when and where the problems will occur so that we can take action and avoid the issues.

Whilst firefighting may grab people’s attention it is in the best interests of your organization to stop major incidents occurring, and far less costly. It is a much better option to be well planned but remember to ensure that your successes and value remain visible within the organization by reporting on them and making people aware of the consequences that have been averted. Show your value.

Let’s examine where to look for KPIs:

       Business and application transactions

       Transaction response times

       Infrastructure costs

       Budget and planning forecasts

       System and application metrics

       SAN storage metrics

       Network metrics

       Virtualization statistics


       Calculated metrics

These are a few examples but you need to determine what is going to be of most value and importance to you within your organization and look for KPI’s based around those.

Dale Feiste
Consultant

No comments:

Post a Comment