April 23, 2012At TeamQuest Technology Summit, we have presentations geared toward the business as well as geared toward the technical usage of TeamQuest Performance Software. Below is a recap of the first two technical breakout sessions that proved to be quite informative for the audience.
How Derived Tables Can Help with Analysis and Reporting - Jim Smith
The first question you might have is, "What are Derived Tables and why would I need them?" Well, TeamQuest IT Service Analyzer/Reporter presents performance data collected by the TeamQuest agents in the form of tables. You can pull together data from multiple tables into a single table. Then you can add fields to those tables whose values are calculated from other fields in the same table. This capability is referred to as Derived Tables.
TeamQuest Global Services pro Jim Smith ran through a few real life examples of how to put Derived Tables into action. The first example was using Derived Tables to see data from a User Agent with TeamQuest Service Analyzer. The second was performing mathematical functions on an existing table and creating new fields. And the last example was combining tables together to report on business metrics with system level metrics.
Smith walked through the details of exactly how to create Derived Tables to drive business value in your organization. A very useful tool!
Modeling Database Consolidation - Nell Owens, Midwest Independent System Operator (MISO)
Many business create large and complex databases due to the nature of their business and consolidating databases may be one of the more tricky tasks to take on. But Nell Owens provided a real life case study of how MISO handles consolidation of their databases.
Owens began by giving an overview of their current database infrastructure supporting 17 databases on 4 servers. By analyzing the CPU utilization of the infrastructure they uncovered a bottleneck that needed to be addressed in order to prevent potential down time and service delivery impacts.
By using TeamQuest Model to analyze a variety of "what if" scenarios, Owens was able to identify the appropriate configuration that would allow for smooth sailing with MISO's database consolidation project. A great real life example of the power of TeamQuest Performance Software!