Detected DB Entities Report
Detected DB Entities report shows information about each and every detected Entity in DB Collectors (Collectors, Queries, Users, Sessions, Blocking Sessions, Clients, Databases, Modules, Programs, Wait States and Related Business Transactions).
Detected DB Entities report is produced when:
- Job file included at least one DB Collector Target.Type=
DB - Metadata is extracted via Input.DetectedEntities=
true - Report is requested via Output.DetectedEntities=
true
Detected DB Entities report has the following file name:
Report\Entities.DB.<Job File Name>.<Start Date and Time in yyyyMMddHHmm>.<Number Of Hours Spanned By Report>.xlsx
For example:
Entities.DB.demo2Ecommerce.2017091914.2.xlsx
The data for the report is in the following files:
- Report\ENT\applications.csv
- Report\ENT\controllers.csv
- Report\ENTDB\applications.db.csv
- Report\ENTDB\blockingsessions.csv
- Report\ENTDB\businesstransactions.csv
- Report\ENTDB\clients.csv
- Report\ENTDB\collectors.csv
- Report\ENTDB\databases.csv
- Report\ENTDB\modules.csv
- Report\ENTDB\programs.csv
- Report\ENTDB\queries.csv
- Report\ENTDB\sessions.csv
- Report\ENTDB\users.csv
- Report\ENTDB\waitstates.csv
This sheet describes the parameters of the extraction and reporting job that produced this report.
| Column | Data Type | Purpose |
|---|---|---|
| Controller | URL | Controller that was queried |
| UserName | String | User that was used to retrieve data from the Controller |
| Application | String | Name of Application that was queried |
| ApplicationID | Integer | ID of Application in Controller |
| ApplicationType | String | Type of the Application |
This sheet provides quick access to the contents of this report and provides at-a-glance number of rows in each of the sheet's tables.
| Column | Data Type | Purpose |
|---|---|---|
| Sheet Name | String | Name of the sheet in the report |
| Num Entities | Integer | Number of Entities in that sheet |
| Link | Hyperlink | Link to the sheet in the report |
This sheet provides information about Controllers covered by this report.
| Column | Data Type | Purpose |
|---|---|---|
| Controller | URL | Controller that was queried |
| Version | String | Version of the Controller |
| VersionDetail | String | Full version string of the Controller |
| NumApps | Integer | Number of All Applications registered in the Controller |
| NumAPMApps | Integer | Number of APM Applications registered in the Controller |
| NumWEBApps | Integer | Number of WEB Applications registered in the Controller |
| NumMOBILEApps | Integer | Number of MOBILE Applications registered in the Controller |
| NumIOTApps | Integer | Number of IoT Applications registered in the Controller |
| NumSIMApps | Integer | Number of SIM Applications registered in the Controller |
| NumBIQApps | Integer | Number of BIQ Applications registered in the Controller |
| NumDBApps | Integer | Number of DB Applications registered in the Controller |
| ControllerLink | URL | Link to Controller |
This sheet lists all Applications of any Type in all Controllers covered by this report.
| Column | Data Type | Purpose |
|---|---|---|
| Controller | URL | Controller that was queried |
| ApplicationName | String | Name of Application |
| Description | String | Description of Application, if set |
| Type | String | Type of the Application |
| Types | Array | Types of Application in this application. Most commonly seen are APM and WEB grouped together |
| CreatedBy | String | Who created this Application |
| CreatedOn | DateTime | When the Application was created, local time |
| CreatedOnUtc | DateTime | When the Application was created, UTC time |
| UpdatedBy | String | Who updated this Application last |
| UpdatedOn | DateTime | When the Application was updated, local time |
| UpdatedOnUtc | DateTime | When the Application was updated, UTC time |
| ApplicationID | Integer | ID of Application in Controller |
| ParentApplicationID | Integer | ID of Parent Application. Used by MOBILE Applications |
This sheet provides information about all DB Collectors in all Controllers covered by this report.
| Column | Data Type | Purpose |
|---|---|---|
| Controller | URL | Controller that was queried |
| ApplicationName | String | Name of Application |
| Description | String | Description of Application, if set |
| NumCollectors | Integer | Number of Collectors that are detected |
| NumOracle | Integer | Number of Oracle Collectors |
| NumMySQL | Integer | Number of MySQL Collectors |
| NumSQLServer | Integer | Number of SQL Server Collectors |
| NumMongo | Integer | Number of Mongo Collectors |
| NumPostgres | Integer | Number of Postres Collectors |
| NumDB2 | Integer | Number of DB2 Collectors |
| NumSybase | Integer | Number of Sybase Collectors |
| NumOther | Integer | Number of Other Collectors |
| ApplicationID | Integer | ID of Application in Controller |
| ControllerLink | URL | Link to Controller |
| ApplicationLink | URL | Link to Application in Controller |
This sheet provides information about all Collectors in all DB Collectors in all Controllers covered by this report.
| Column | Data Type | Purpose |
|---|---|---|
| Controller | URL | Controller that was queried |
| CollectorName | String | Name of Collector |
| CollectorType | String | Type of Collector |
| CollectorStatus | String | Status of Collector |
| AgentName | String | Name of Database Agent that is assigned to serve this Collector |
| Host | String | Hostname of the database server |
| Port | Integer | Port of the database server |
| UserName | String | User name of the user used to access the database server |
| Role | String | Database role as reported by Database Monitoring agent |
| Calls | Number | Number of calls to this entity |
| ExecTime | Number | Duration of execution of all calls to this entity |
| ExecTimeSpan | TimeSpan | Duration of execution of all calls to this entity |
| From | DateTime | Beginning of time range queried, local time |
| To | DateTime | End of time range queried, local time |
| FromUtc | DateTime | Beginning of time range queried, UTC time |
| ToUtc | DateTime | End of time range queried, UTC time |
| Duration | Integer | Duration of time range queried, in minutes |
| ConfigID | Integer | ID of Collector Definition |
| CollectorID | Integer | ID of Collector |
| ControllerLink | URL | Link to Controller |
| ApplicationLink | URL | Link to Application in Controller |
| CollectorLink | URL | Link to Collector in Controller |
This sheet uses data in 6.Collectors sheet as source for pivot table to enable summary reporting and ad-hoc drill-down.
Default configuration provides breakdown of Database Collectors by type in all Controllers, summarized by their reporting status.
| Columns | Rows | Values | Filters |
|---|---|---|---|
| CollectorStatus | |||
| CollectorType | |||
| Controller | |||
| CollectorName | |||
| Host | |||
| NumCollections (Count) | |||
| Calls (Sum) | |||
| ExecTime (Average) | |||
| AgentName |
Example report showing various types of database collectors across 2 controllers
Here is the report that is filtered to specific Database Agent instance, and only showing collectors that are actually collecting data from Mongo and Oracle databases
This sheet provides information about all Queries in all Collectors in all DB Collectors in all Controllers covered by this report.
| Column | Data Type | Purpose |
|---|---|---|
| Controller | URL | Controller that was queried |
| CollectorName | String | Name of Collector |
| CollectorType | String | Type of Collector |
| CollectorStatus | String | Status of Collector |
| AgentName | String | Name of Database Agent that is assigned to serve this Collector |
| Host | String | Hostname of the database server |
| Port | Integer | Port of the database server |
| UserName | String | User name of the user used to access the database server |
| QueryHash | String | Hash of query |
| Query | String | Query that was executed |
| SQLClauseType | String | Type of SQL clause DML: SELECT, INSERT, UPDATE, DELETE, TRUNCATE; DDL: CREATE, ALTER, DROP; Security: GRANT, REVOKE; Stored Procedures: PROCCALL |
| SQLJoinType | String | Join types: INNER, LEFT, RIGHT, FULL, SELF, CROSS |
| SQLGroupBy | Boolean | Whether GROUP BY clause is present |
| SQLHaving | Boolean | Whether HAVING clause is present |
| SQLOrderBy | Boolean | Whether ORDER BY clause is present |
| SQLUnion | Boolean | Whether UNION clause is present |
| SQLWhere | Boolean | Whether WHERE clause is present |
| SQLTable | String | Name of the SQL Table affected by this query |
| SQLTables | String | List of the SQL Tables affected by this query if there were more than one |
| NumSQLTables | Integer | Number of the SQL Tables affected by this query if there were more than one |
| Name | String | Name of the query. Mostly appears to be blank |
| Namespace | String | Namespace of the query. Mostly appears to be blank |
| Client | String | Not sure what that is |
| Calls | Number | Number of calls to this entity |
| ExecTime | Number | Duration of execution of all calls to this entity |
| ExecTimeSpan | TimeSpan | Duration of execution of all calls to this entity |
| AvgExecTime | Number | Average duration of execution for single call to this entity |
| AvgExecRange | String | String representing bucket into which Duration fits |
| Weight | Number | Percentage of these executions against all others |
| IsSnapCorrData | Boolean | Not sure what this is |
| IsSnapWindowData | Boolean | Not sure what this is |
| From | DateTime | Beginning of time range queried, local time |
| To | DateTime | End of time range queried, local time |
| FromUtc | DateTime | Beginning of time range queried, UTC time |
| ToUtc | DateTime | End of time range queried, UTC time |
| Duration | Integer | Duration of time range queried, in minutes |
| ConfigID | Integer | ID of Collector Definition |
| CollectorID | Integer | ID of Collector |
| QueryID | Integer | ID of Query |
| QueryLink | URL | Link to Query in Controller |
This sheet uses data in 7.Queries sheet as source for pivot table to enable summary reporting and ad-hoc drill-down.
Default configuration provides breakdown of various query types by Number of Calls, Execution time and Weight across all Controllers and Collectors.
| Columns | Rows | Values | Filters |
|---|---|---|---|
| SQLClauseType | |||
| Query | |||
| CollectorType | |||
| Controller | |||
| CollectorName | |||
| Host | |||
| NumQueries (Count) | |||
| Calls (Sum) | |||
| AvgExecTime (Average) | |||
| Weight (Average) | |||
| AgentName | |||
| AvgExecRange | |||
| SQLJoinType | |||
| SQLGroupBy | |||
| SQLHaving | |||
| SQLOrderBy | |||
| SQLUnion | |||
| SQLWhere |
Example report showing all types of queries from couple of dozen of various databases, grouped by their SQL clause type
Here is the report that is filtered to to only SELECT queries that contain WHERE statement and sorted by number of Calls
This sheet provides information about all database Users in all DB Collectors in all Controllers covered by this report.
| Column | Data Type | Purpose |
|---|---|---|
| Controller | URL | Controller that was queried |
| CollectorName | String | Name of Collector |
| CollectorType | String | Type of Collector |
| CollectorStatus | String | Status of Collector |
| AgentName | String | Name of Database Agent that is assigned to serve this Collector |
| Host | String | Hostname of the database server |
| Port | Integer | Port of the database server |
| UserName | String | User name of the user used to access the database server |
| DBUserName | String | Database user name that is executing queries |
| ExecTime | Number | Duration of execution of all calls to this entity |
| ExecTimeSpan | TimeSpan | Duration of execution of all calls to this entity |
| Weight | Number | Percentage of these executions against all others |
| From | DateTime | Beginning of time range queried, local time |
| To | DateTime | End of time range queried, local time |
| FromUtc | DateTime | Beginning of time range queried, UTC time |
| ToUtc | DateTime | End of time range queried, UTC time |
| Duration | Integer | Duration of time range queried, in minutes |
| ConfigID | Integer | ID of Collector Definition |
| CollectorID | Integer | ID of Collector |
| UserID | Integer | ID of User |
This sheet uses data in 8.Users sheet as source for pivot table to enable summary reporting and ad-hoc drill-down.
Default configuration provides breakdown of Users querying databases by Number of Calls, Execution time and Weight across all Controllers and Collectors.
| Columns | Rows | Values | Filters |
|---|---|---|---|
| CollectorType | |||
| DBUserName | |||
| Controller | |||
| CollectorName | |||
| Host | |||
| NumUsers (Count) | |||
| ExecTime (Average) | |||
| Weight (Average) | |||
| AgentName |
Example report showing all users by type of database in all database collectors
This sheet provides information about all Sessions in all DB Collectors in all Controllers covered by this report.
| Column | Data Type | Purpose |
|---|---|---|
| Controller | URL | Controller that was queried |
| CollectorName | String | Name of Collector |
| CollectorType | String | Type of Collector |
| CollectorStatus | String | Status of Collector |
| AgentName | String | Name of Database Agent that is assigned to serve this Collector |
| Host | String | Hostname of the database server |
| Port | Integer | Port of the database server |
| UserName | String | User name of the user used to access the database server |
| SessionName | String | Session name of the session executing queries |
| ClientName | String | Client within the the session executing queries |
| ExecTime | Number | Duration of execution of all calls to this entity |
| ExecTimeSpan | TimeSpan | Duration of execution of all calls to this entity |
| Weight | Number | Percentage of these executions against all others |
| From | DateTime | Beginning of time range queried, local time |
| To | DateTime | End of time range queried, local time |
| FromUtc | DateTime | Beginning of time range queried, UTC time |
| ToUtc | DateTime | End of time range queried, UTC time |
| Duration | Integer | Duration of time range queried, in minutes |
| ConfigID | Integer | ID of Collector Definition |
| CollectorID | Integer | ID of Collector |
| SessionID | Integer | ID of Session |
This sheet uses data in 9.Sessions sheet as source for pivot table to enable summary reporting and ad-hoc drill-down.
Default configuration provides breakdown of Sessions with clients accessing databases by Number of Calls, Execution time and Weight across all Controllers and Collectors.
| Columns | Rows | Values | Filters |
|---|---|---|---|
| CollectorType | |||
| ClientName | |||
| SessionName | |||
| Controller | |||
| CollectorName | |||
| Host | |||
| NumSessions (Count) | |||
| ExecTime (Average) | |||
| Weight (Average) | |||
| AgentName |
Example report showing all clients and sessions by type of database in all database collectors
This sheet provides information about all Blocking Sessions in all DB Collectors in all Controllers covered by this report.
| Column | Data Type | Purpose |
|---|---|---|
| Controller | URL | Controller that was queried |
| CollectorName | String | Name of Collector |
| CollectorType | String | Type of Collector |
| CollectorStatus | String | Status of Collector |
| AgentName | String | Name of Database Agent that is assigned to serve this Collector |
| Host | String | Hostname of the database server |
| Port | Integer | Port of the database server |
| UserName | String | User name of the user used to access the database server |
| BlockingSessionName | String | Session name of the session that is blocking |
| BlockingClientName | String | Client within the the session executing queries that is blocking |
| BlockingDBUserName | String | Database user name of the Session that is blocking |
| OtherSessionName | String | Session name of the session that is blocked |
| OtherClientName | String | Client within the the session executing queries that is blocked |
| OtherDBUserName | String | Database user name of the Session that is blocked |
| QueryHash | String | Hash of query |
| Query | String | Query that was executed |
| BlockTime | Number | Duration of blocked time |
| ExecTimeSpan | TimeSpan | Duration of blocked time |
| FirstOccurrence | DateTime | Beginning of first occurrence, local time |
| FirstOccurrenceUtc | DateTime | Beginning of first occurrence, UTC time |
| From | DateTime | Beginning of time range queried, local time |
| To | DateTime | End of time range queried, local time |
| FromUtc | DateTime | Beginning of time range queried, UTC time |
| ToUtc | DateTime | End of time range queried, UTC time |
| Duration | Integer | Duration of time range queried, in minutes |
| ConfigID | Integer | ID of Collector Definition |
| CollectorID | Integer | ID of Collector |
| BlockingSessionID | Integer | ID of Blocking Session |
This sheet provides information about all Clients in all DB Collectors in all Controllers covered by this report.
| Column | Data Type | Purpose |
|---|---|---|
| Controller | URL | Controller that was queried |
| CollectorName | String | Name of Collector |
| CollectorType | String | Type of Collector |
| CollectorStatus | String | Status of Collector |
| AgentName | String | Name of Database Agent that is assigned to serve this Collector |
| Host | String | Hostname of the database server |
| Port | Integer | Port of the database server |
| UserName | String | User name of the user used to access the database server |
| ClientName | String | Client executing queries |
| ExecTime | Number | Duration of execution of all calls to this entity |
| ExecTimeSpan | TimeSpan | Duration of execution of all calls to this entity |
| Weight | Number | Percentage of these executions against all others |
| From | DateTime | Beginning of time range queried, local time |
| To | DateTime | End of time range queried, local time |
| FromUtc | DateTime | Beginning of time range queried, UTC time |
| ToUtc | DateTime | End of time range queried, UTC time |
| Duration | Integer | Duration of time range queried, in minutes |
| ConfigID | Integer | ID of Collector Definition |
| CollectorID | Integer | ID of Collector |
| ClientID | Integer | ID of Client |
This sheet uses data in 11.Clients sheet as source for pivot table to enable summary reporting and ad-hoc drill-down.
Default configuration provides breakdown of Clients accessing databases by Number of Calls, Execution time and Weight across all Controllers and Collectors.
| Columns | Rows | Values | Filters |
|---|---|---|---|
| CollectorType | |||
| ClientName | |||
| Controller | |||
| CollectorName | |||
| Host | |||
| NumClients (Count) | |||
| ExecTime (Average) | |||
| Weight (Average) | |||
| AgentName |
Example report showing all clients by type of database in all database collectors
This sheet provides information about all Databases in all DB Collectors in all Controllers covered by this report.
| Column | Data Type | Purpose |
|---|---|---|
| Controller | URL | Controller that was queried |
| CollectorName | String | Name of Collector |
| CollectorType | String | Type of Collector |
| CollectorStatus | String | Status of Collector |
| AgentName | String | Name of Database Agent that is assigned to serve this Collector |
| Host | String | Hostname of the database server |
| Port | Integer | Port of the database server |
| UserName | String | User name of the user used to access the database server |
| DatabaseName | String | Database being queried |
| ExecTime | Number | Duration of execution of all calls to this entity |
| ExecTimeSpan | TimeSpan | Duration of execution of all calls to this entity |
| Weight | Number | Percentage of these executions against all others |
| From | DateTime | Beginning of time range queried, local time |
| To | DateTime | End of time range queried, local time |
| FromUtc | DateTime | Beginning of time range queried, UTC time |
| ToUtc | DateTime | End of time range queried, UTC time |
| Duration | Integer | Duration of time range queried, in minutes |
| ConfigID | Integer | ID of Collector Definition |
| CollectorID | Integer | ID of Collector |
| DatabaseID | Integer | ID of Database |
This sheet uses data in 12.Databases sheet as source for pivot table to enable summary reporting and ad-hoc drill-down.
Default configuration provides breakdown of Databases by Number of Calls, Execution time and Weight across all Controllers and Collectors.
| Columns | Rows | Values | Filters |
|---|---|---|---|
| CollectorType | |||
| DatabaseName | |||
| Controller | |||
| CollectorName | |||
| Host | |||
| NumDBs (Count) | |||
| ExecTime (Average) | |||
| Weight (Average) | |||
| AgentName |
Example report showing all database by type of database in all database collectors
This sheet provides information about all Modules in all DB Collectors in all Controllers covered by this report.
| Column | Data Type | Purpose |
|---|---|---|
| Controller | URL | Controller that was queried |
| CollectorName | String | Name of Collector |
| CollectorType | String | Type of Collector |
| CollectorStatus | String | Status of Collector |
| AgentName | String | Name of Database Agent that is assigned to serve this Collector |
| Host | String | Hostname of the database server |
| Port | Integer | Port of the database server |
| UserName | String | User name of the user used to access the database server |
| ModuleName | String | Module being invoked |
| ExecTime | Number | Duration of execution of all calls to this entity |
| ExecTimeSpan | TimeSpan | Duration of execution of all calls to this entity |
| Weight | Number | Percentage of these executions against all others |
| From | DateTime | Beginning of time range queried, local time |
| To | DateTime | End of time range queried, local time |
| FromUtc | DateTime | Beginning of time range queried, UTC time |
| ToUtc | DateTime | End of time range queried, UTC time |
| Duration | Integer | Duration of time range queried, in minutes |
| ConfigID | Integer | ID of Collector Definition |
| CollectorID | Integer | ID of Collector |
| ModuleID | Integer | ID of Module |
This sheet uses data in 13.Modules sheet as source for pivot table to enable summary reporting and ad-hoc drill-down.
Default configuration provides breakdown of Modules by Number of Calls, Execution time and Weight across all Controllers and Collectors.
| Columns | Rows | Values | Filters |
|---|---|---|---|
| CollectorType | |||
| ModuleName | |||
| Controller | |||
| CollectorName | |||
| Host | |||
| NumModules (Count) | |||
| ExecTime (Average) | |||
| Weight (Average) | |||
| AgentName |
Example report showing all modules by type of database in all database collectors
This sheet provides information about all Programs in all DB Collectors in all Controllers covered by this report.
| Column | Data Type | Purpose |
|---|---|---|
| Controller | URL | Controller that was queried |
| CollectorName | String | Name of Collector |
| CollectorType | String | Type of Collector |
| CollectorStatus | String | Status of Collector |
| AgentName | String | Name of Database Agent that is assigned to serve this Collector |
| Host | String | Hostname of the database server |
| Port | Integer | Port of the database server |
| UserName | String | User name of the user used to access the database server |
| ProgramName | String | Program being invoked |
| ExecTime | Number | Duration of execution of all calls to this entity |
| ExecTimeSpan | TimeSpan | Duration of execution of all calls to this entity |
| Weight | Number | Percentage of these executions against all others |
| From | DateTime | Beginning of time range queried, local time |
| To | DateTime | End of time range queried, local time |
| FromUtc | DateTime | Beginning of time range queried, UTC time |
| ToUtc | DateTime | End of time range queried, UTC time |
| Duration | Integer | Duration of time range queried, in minutes |
| ConfigID | Integer | ID of Collector Definition |
| CollectorID | Integer | ID of Collector |
| ProgramID | Integer | ID of Program |
This sheet uses data in 14.Programs sheet as source for pivot table to enable summary reporting and ad-hoc drill-down.
Default configuration provides breakdown of Programs by Number of Calls, Execution time and Weight across all Controllers and Collectors.
| Columns | Rows | Values | Filters |
|---|---|---|---|
| CollectorType | |||
| ProgramName | |||
| Controller | |||
| CollectorName | |||
| Host | |||
| NumPrograms (Count) | |||
| ExecTime (Average) | |||
| Weight (Average) | |||
| AgentName |
Example report showing all programs by type of database in all database collectors
This sheet provides information about all Wait States in all DB Collectors in all Controllers covered by this report.
| Column | Data Type | Purpose |
|---|---|---|
| Controller | URL | Controller that was queried |
| CollectorName | String | Name of Collector |
| CollectorType | String | Type of Collector |
| CollectorStatus | String | Status of Collector |
| AgentName | String | Name of Database Agent that is assigned to serve this Collector |
| Host | String | Hostname of the database server |
| Port | Integer | Port of the database server |
| UserName | String | User name of the user used to access the database server |
| ApplicationName | String | APM Application that contains Business Transactions that call this Database |
| BTName | String | APM Business Transaction that call this Database |
| Calls | Integer | Number of calls to this entity |
| ExecTime | Number | Duration of execution of all calls to this entity |
| ExecTimeSpan | TimeSpan | Duration of execution of all calls to this entity |
| AvgExecTime | Number | Average duration of execution for single call to this entity |
| AvgExecRange | String | String representing bucket into which Duration fits |
| Weight | Number | Percentage of these executions against all others |
| From | DateTime | Beginning of time range queried, local time |
| To | DateTime | End of time range queried, local time |
| FromUtc | DateTime | Beginning of time range queried, UTC time |
| ToUtc | DateTime | End of time range queried, UTC time |
| Duration | Integer | Duration of time range queried, in minutes |
| ConfigID | Integer | ID of Collector Definition |
| CollectorID | Integer | ID of Collector |
| ApplicationID | Integer | ID of Application in Controller |
| BTID | Integer | ID of Business Transaction in Application |
This sheet provides information about all Wait States in all DB Collectors in all Controllers covered by this report.
| Column | Data Type | Purpose |
|---|---|---|
| Controller | URL | Controller that was queried |
| CollectorName | String | Name of Collector |
| CollectorType | String | Type of Collector |
| CollectorStatus | String | Status of Collector |
| AgentName | String | Name of Database Agent that is assigned to serve this Collector |
| Host | String | Hostname of the database server |
| Port | Integer | Port of the database server |
| UserName | String | User name of the user used to access the database server |
| State | String | Wait State name |
| ExecTime | Number | Duration of execution of all calls to this entity |
| ExecTimeSpan | TimeSpan | Duration of execution of all calls to this entity |
| From | DateTime | Beginning of time range queried, local time |
| To | DateTime | End of time range queried, local time |
| FromUtc | DateTime | Beginning of time range queried, UTC time |
| ToUtc | DateTime | End of time range queried, UTC time |
| Duration | Integer | Duration of time range queried, in minutes |
| ConfigID | Integer | ID of Collector Definition |
| CollectorID | Integer | ID of Collector |
| WaitStateID | Integer | ID of Wait State |
This sheet uses data in 16.Wait States sheet as source for pivot table to enable summary reporting and ad-hoc drill-down.
Default configuration provides breakdown of Wait States by Number of Calls, Execution time and Weight across all Controllers and Collectors.
| Columns | Rows | Values | Filters |
|---|---|---|---|
| CollectorType | |||
| State | |||
| Controller | |||
| CollectorName | |||
| Host | |||
| NumWaitStates (Count) | |||
| ExecTime (Average) | |||
| AgentName |
Example report showing all wait states by type of database in all database collectors
