Neoview Workload Management Services Guide (R2.5)

Log File Format
At regular intervals (30 seconds by default), the Neoview Performance Analyzer (or the Neoview
Query Viewer) writes a new block of services data to the log file and appends this data to the
previously written services data. The data blocks are separated from each other by dashed lines.
Each data block contains this data:
---------------------------------------------------------------------------
Start of data block:
<Timestamp (GMT)>, <Timestamp (Local)>, <CPU Busy %>, <Memory Usage %>, <# Threshold
Violations>
First row:
<Timestamp (GMT)>, <Timestamp (Local)>, <CPU Busy %>, <Memory Usage %>, <[*] (threshold violation)
or blank (no threshold violation)>, <Service>, <State>, <Service Priority>, <Max CPU Busy>, <Max
Mem Usage>, <Max Rows Fetched>, <Active Time>, <SQL Plan>, <SQL Text>, <Exec Timeout>, <Wait
Timeout>, <Hold Timeout>, <SQL Defaults>
Rows for each
service:
Here is an example of a log file that contains several data blocks:
---------------------------------------------------------------------------
"Thu, 24 Jun 2010 16:07:35 GMT", 6/24/2010 4:07:35 PM, 1.60944008827209, 88.125, 5
"Thu, 24 Jun 2010 16:07:35 GMT", 6/24/2010 4:07:35 PM, 1.60944008827209, 88.125, , HPS_MANAGEABILITY, ACTIVE,
HIGH, 0, 0, 0, FROM 00:00 TO 24:00, NO_PLAN, NO_TEXT, 0, 0, 0, SET SESSION DEFAULT MASTER_PRIORITY '160';
"Thu, 24 Jun 2010 16:07:35 GMT", 6/24/2010 4:07:35 PM, 1.60944008827209, 88.125, [*], SERVICE1, ACTIVE, HIGH,
100, 100, 0, FROM 00:00 TO 24:00, NO_PLAN, NO_TEXT, 120, 720, 1440,
"Thu, 24 Jun 2010 16:07:35 GMT", 6/24/2010 4:07:35 PM, 1.60944008827209, 88.125, , HPS_TRANSPORTER, ACTIVE,
MEDIUM, 0, 0, 0, FROM 00:00 TO 24:00, NO_PLAN, NO_TEXT, 0, 0, 0, SET SESSION DEFAULT MASTER_PRIORITY '110';
"Thu, 24 Jun 2010 16:07:35 GMT", 6/24/2010 4:07:35 PM, 1.60944008827209, 88.125, [*], AGG_SERVICE, ACTIVE,
MEDIUM, 100, 85, 0, FROM 00:00 TO 24:00, NO_PLAN, NO_TEXT, 0, 0, 0,
"Thu, 24 Jun 2010 16:07:35 GMT", 6/24/2010 4:07:35 PM, 1.60944008827209, 88.125, [*], SERVICE2, ACTIVE, MEDIUM,
100, 85, 0, FROM 08:00 TO 24:00, NO_PLAN, NO_TEXT, 240, 1440, 0,
"Thu, 24 Jun 2010 16:07:35 GMT", 6/24/2010 4:07:35 PM, 1.60944008827209, 88.125, [*], HP_DEFAULT_SERVICE, ACTIVE,
LOW, 100, 85, 0, FROM 00:00 TO 24:00, NO_PLAN, NO_TEXT, 0, 0, 0,
"Thu, 24 Jun 2010 16:07:35 GMT", 6/24/2010 4:07:35 PM, 1.60944008827209, 88.125, [*], SERVICE3, ACTIVE, LOW,
85, 60, 2000, FROM 12:00 TO 24:00, NO_PLAN, NO_TEXT, 0, 0, 0,
"Thu, 24 Jun 2010 16:07:35 GMT", 6/24/2010 4:07:35 PM, 1.60944008827209, 88.125, , SERVICE5, ACTIVE, LOW, 0,
0, 0, FROM 00:00 TO 24:00, NO_PLAN, NO_TEXT, 0, 0, 0,
---------------------------------------------------------------------------
"Thu, 24 Jun 2010 16:08:37 GMT", 6/24/2010 4:08:37 PM, 1.43313074111938, 88.125, 5
"Thu, 24 Jun 2010 16:08:37 GMT", 6/24/2010 4:08:37 PM, 1.43313074111938, 88.125, , HPS_MANAGEABILITY, ACTIVE,
HIGH, 0, 0, 0, FROM 00:00 TO 24:00, NO_PLAN, NO_TEXT, 0, 0, 0, SET SESSION DEFAULT MASTER_PRIORITY '160';
"Thu, 24 Jun 2010 16:08:37 GMT", 6/24/2010 4:08:37 PM, 1.43313074111938, 88.125, [*], SERVICE1, ACTIVE, HIGH,
100, 100, 0, FROM 00:00 TO 24:00, NO_PLAN, NO_TEXT, 120, 720, 1440,
"Thu, 24 Jun 2010 16:08:37 GMT", 6/24/2010 4:08:37 PM, 1.43313074111938, 88.125, , HPS_TRANSPORTER, ACTIVE,
MEDIUM, 0, 0, 0, FROM 00:00 TO 24:00, NO_PLAN, NO_TEXT, 0, 0, 0, SET SESSION DEFAULT MASTER_PRIORITY '110';
"Thu, 24 Jun 2010 16:08:37 GMT", 6/24/2010 4:08:37 PM, 1.43313074111938, 88.125, [*], AGG_SERVICE, ACTIVE,
MEDIUM, 100, 85, 0, FROM 00:00 TO 24:00, NO_PLAN, NO_TEXT, 0, 0, 0,
"Thu, 24 Jun 2010 16:08:37 GMT", 6/24/2010 4:08:37 PM, 1.43313074111938, 88.125, [*], SERVICE2, ACTIVE, MEDIUM,
100, 85, 0, FROM 08:00 TO 24:00, NO_PLAN, NO_TEXT, 240, 1440, 0,
"Thu, 24 Jun 2010 16:08:37 GMT", 6/24/2010 4:08:37 PM, 1.43313074111938, 88.125, [*], HP_DEFAULT_SERVICE, ACTIVE,
LOW, 100, 85, 0, FROM 00:00 TO 24:00, NO_PLAN, NO_TEXT, 0, 0, 0,
"Thu, 24 Jun 2010 16:08:37 GMT", 6/24/2010 4:08:37 PM, 1.43313074111938, 88.125, [*], SERVICE3, ACTIVE, LOW,
85, 60, 2000, FROM 12:00 TO 24:00, NO_PLAN, NO_TEXT, 0, 0, 0,
"Thu, 24 Jun 2010 16:08:37 GMT", 6/24/2010 4:08:37 PM, 1.43313074111938, 88.125, , SERVICE5, ACTIVE, LOW, 0,
0, 0, FROM 00:00 TO 24:00, NO_PLAN, NO_TEXT, 0, 0, 0,
Reconfigure or Take Action on a WMS Service
To reconfigure or change the state of one or more services:
1. Click the [Configure] button in the Statement and Services Counter Details window.
The Configure Workload Management Services dialog box appears.
150 Monitoring and Managing Workloads