BUSINESS METRICS AGGREGATED BY CUSTOM HIERARCHY

• US 20080270469A1
• Filed: 04/26/2007
• Published: 10/30/2008
• Est. Priority Date: 04/26/2007
• Status: Abandoned Application

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Justus, Darren C., Moon, Carroll W., Pallini, Susan, Myerson, Neal R., Luniya, Jitendra
• Application Number:
  US11/740,740
• Publication Number:
  US 20080270469A1
• Time in Patent Office: Days
• US Class Current: 707/104.1
• CPC Class Codes: G06F 11/3409 for performance assessment
• CPC Class Codes: G06F 11/3476 Data logging G06F11/14, G06F11/2205 take precedence
• CPC Class Codes: G06F 2201/86 Event-based monitoring
• CPC Class Codes: G06Q 10/0637 Strategic management or analysis, e.g. setting a goal or target of an organisation; Planning actions based on goals; Analysis or evaluation of effectiveness of goals

Abstract

A metrics generation system provides IT computing system metrics that are aggregated by a custom hierarchy. The custom hierarchy is specified by a user through configuration files. The metrics generation system retrieves IT system health data, processes and aggregates metrics from the retrieved data and displays the metrics based on user defined parameters and instructions in the configuration files. The metrics generation system is flexible in that it can be changed to extract data from different IT data sources, calculate different metric information having a hierarchy of attribute types and values, and display a variety of metric data in different formats.

Claims

1. A method for providing metrics, comprising:

accessing a first configuration file having metric parameters for one or more metrics and one or more attribute parameters for each metric, the one or more attribute parameters forming a hierarchy for each metric;

accessing a second configuration file having extraction parameters for one or more servers, each of the one or more servers having data within a different schema;

generating one or more queries for the one or more servers from the extraction parameters querying the one or more servers to extract system health data;

loading the system health data into one or more tables having the same schema; and

processing the system health data into one or more metric hierarchies, each metric hierarchy associated with a metric and generated from the metric parameters and one or more attribute parameters for each metric.

2. The method of claim 1, wherein the first file defines one or more metrics, one or more attribute types for each metric, and one or more attribute values for each attribute type, the extracted data corresponding to one or more attribute values.

3. The method of claim 1, wherein the second file includes server identification information for one or more servers and database identification information for one or more databases located on each of the one or more servers.

4. The method of claim 1, wherein said step of querying includes:

executing the extraction tasks by a staging database to extract data values and time stamps from SQL servers having a different schema.

5. The method of claim 4, wherein said first file and said second file are accessed by the staging database.

6. The method of claim 4, wherein a metrics engine generates the extraction tasks and provides the tasks to the staging database.

7. The method of claim 1, wherein said step of processing includes:

calculating one or more metrics from the extracted data, said step of calculating based on the metric parameters; and

loading the metrics into one or more metric hierarchies.

8. The method of claim 1, further comprising:

accessing one or more display configuration files; and

displaying the one or more metrics based on the display configuration files.

9. The method of claim 8, configuring a user interface from the display configuration files.

10. The method of claim 9, wherein the display configuration files reference hierarchy levels from other configuration files for of each metric to be displayed.

11. One or more processor readable storage devices having processor readable code embodied on said processor readable storage devices, said processor readable code for programming one or more processors to perform a method comprising:

retrieving metric parameters and one or more sets of attribute parameters for each of one or more metrics, each of the one or more sets of attribute parameters defining a hierarchy for one of the one or more metrics;

retrieving server parameters for two or more servers which contain IT data;

extracting the IT data from the two or more first servers based on the server parameters;

generating metric data from the extracted IT data;

loading the metric data into one or more metric hierarchies, each metric hierarchy associated with a metric and having one or more levels, each metric hierarchy level associated with an attribute parameter for the metric, wherein each attribute has a universal attribute type and a specific attribute value for each metric; and

aggregating additional IT data for each metric hierarchy level for each metric.

12. The one or more processor readable storage devices of claim 11, wherein said step of generating metric data includes:

loading the extracted IT data into a staging database; and

performing calculations on the loaded data based on the metric parameters.

13. The one or more processor readable storage devices of claim 12, wherein said step of performing calculations include generating a measure or an availability value.

14. The one or more processor readable storage devices of claim 11, wherein said step of aggregating additional IT data includes:

extracting additional IT data from a second server, the second server having a different interface than each of the one or more first servers; and

processing the additional extracted IT data into the one or more hierarchies.

15. The one or more processor readable storage devices of claim 11, wherein said step of aggregating additional IT data includes:

determining an aggregation type defined in the metric parameters for each metric; and

aggregating said additional IT data based on the aggregation type for the particular metric.

16. The one or more processor readable storage devices of claim 11, wherein said aggregation type may be a summarization, average, minimum, or maximum.

17. The one or more processor readable storage devices of claim 11, wherein the metric parameter and attribute parameters are contained in one or more configuration files in XML format.

18. A method for providing metrics, comprising:

retrieving a first configuration file having metric parameters and a set of attribute parameters for each of one or more metrics, the set of attribute parameters defining a hierarchy for each metric, wherein each level in a hierarchy is associated with an attribute;

retrieving a second configuration file having extraction parameters for two or more servers