Previous Topic: ReportingNext Topic: Freeform Editing

AutoCollect - Creating User Defined DELTA Rowsets › Processing Data Outside of the AUTOCOLL Functions › Sample SERVER/SQL

Sample SERVER/SQL

Sample SQL query against the Delta table D_BUSINESS_VALUE_METRICS selecting just TYPE=LAST rows and placing the output into an Excel spreadsheet.

SELECT MUF_NAME AS MUF,
       DATE(D_MUF_DATETIME) AS DATE,    
       TIME(D_MUF_DATETIME) AS TIME,    
       CURRENT_CPU AS CPU,               
       PHYSICAL_IO AS IO,               
       DB_REQUESTS AS REQUESTS,         
       REQUESTS_2_CPU AS REQ_PER_CPU,   
       REQUESTS_2_PIO AS REQ_PER_IO,    
       ((CURRENT_CPU * 20)/DB_REQUESTS)+((PHYSICAL_IO*.01)/DB_REQUESTS) AS  
       COST_PER_REQ      
  FROM AUTOCOLLECT.D_BUSINESS_VALUE_METRICS    
 WHERE D_MUF_TYPE = 'LAST';

Returned as an Excel spreadsheet:

There is a wide variety of site specific functionality that could be added by using available tools to build and deliver the AutoCollect data to the user's performance and tuning group.