DbManager Diagnostic Pack provides an overview of the work of the DbManager process and information about objects of type Database, Table , and about currently existing connections to SQL databases. It is accessible from D2000 CNF from menu Objects -> DbManager Diagnostic Pack or from D2000 GrEditor, from menu Configuration D2000 -> DbManager Diagnostic Pack.
Additionally, it is accessible fromD2000 CNF for Database and Table objects from the Extended actions context menu. In this case, it opens with a filter - it only contains information about the selected database (in the case of an object of the Table type about the parent Database).
After pressing the right mouse button, all tabs offer a menu with the option Copy, which copies the displayed list to the clipboard, and the option Copy '<column name>', which copies a specific item to the clipboard. Some of the tabs also offer additional actions.
In individual tabs, columns can be filtered, sorted (by clicking on the header), and both the order of columns and their widths can be changed (by Drag & Drop in case of columns order). The settings are stored in the Windows Registry database. The DbManager Diagnostic Pack window can be opened multiple times (e.g. for different databases from the context menu).
A view of DbManager processes (*.DBM) is provided by the Processes tab.
Meaning of the columns:
ID (HOBJ) | Unique identifier of the Process type object within the DODM model. |
Name | Unique name of the Process type object within the DODM model. |
Active | In the case of instance DBM processes (e.g. [1]_SELF. DBM) information on whether the instance is active). |
IP | The identifier of the computer on which the process is running. |
AllocatedMermory | The amount of memory used by the given process. |
The context menu offers other extended actions:
- Read statistics - all databases: statistics about Database objects from the selected DBM process are displayed on the Database Statistics tab.
- Read statistics - all tables: statistics about Table objects from the selected DBM process are loaded on the Table Statistics tab.
- Reset statistics - all databases: statistics on objects of type Database from the selected DBM process will be cleared (irreversibly).
- Reset statistics - all tables: statistics on Table objects from the selected DBM process will be cleared (irreversibly).
A view of Database type objects is provided by the Databases tab:
For each Database, its parameters and summary statistics are available:
ID (HOBJ) | A unique identifier of the object of type Database within the DODM model. |
Name | A unique name of the object of type Database. |
ID process | A unique identifier of the process within which the Database is located. In the case of DbManager instance processes, the same Database can be on several lines. |
Process | The name of the process from which the information about the Database comes. In the case of DbManager instance processes, the same Database can be on several lines. |
* Connects | The number of connections to the SQL database in individual states. |
Operations | The total number of operations (database actions) performed on the Database object by the DbManager process (since the start or since the last statistics reset). |
Total Duration | The total duration of operations ( database actions) performed on the Database object by the DbManager process (since the start or since the last statistics reset). |
Max Duration | Duration of the longest operation performed on the Database object by the DbManager process (since the start or since the last statistics reset). |
Max Operation | The name of the longest operation performed on the Database object by the DbManager process (since the start or since the last statistics reset). |
Max Comment | Comment on the longest operation (information about the sequence of calls within the ESL script). |
The context menu offers other extended actions:
- Read <Database name> databases statistics: statistics about the selected object of Database type are read on the Database Statistics tab.
- Read <Database name> tables statistics: statistics about the selected object of Table type are read on the Table Statistics tab.
- Reset <Database name> databases statistics: statistics about the selected object of Database type will be cleared (irreversibly).
- Reset <Database name> tables statistics: statistics about the selected object of Table type will be cleared (irreversibly).
A view of database connections is provided by the Connects tab.
For each database connection, its parameters and statistics are available:
ID | Identifier of connection within the Database object. |
Name | Unique name of the connection within the DbManager process. |
ID Database | A unique identifier of the object of Database type within the DODM model. |
Database | A unique name of the object of Database type. |
ID Process | A unique identifier of the process within which the Database is located. In the case of DbManager instance processes, the same Database can be on several lines. |
Process | The name of the process from which the information about the Database comes. In the case of DbManager instance processes, the same Database can be on several lines. |
State | State of the connection. |
Busy/Idle | Information on whether the connection is currently performing some activity (Busy) or is idle (Idle) |
Busy/Idle Time | Duration of Busy/Idle state. |
Connect Type | Connection type:
Note: A transactional connection that has a Normal status is suspicious. |
Handles | The number of handles within the connection. Handles are created by the actions DB_CONNECT, PG_CONNECT, SQL_CONNECT, the action DB_TRANS_OPEN, and in transactional mode by every database action until the DB_TRANS_COMMIT or DB_TRANS_ROLLBACK is called. |
WD Expired | If the connection is in a Busy state, then the number of times the watchdog interval has elapsed. This is 60 seconds by default, it can be set with the start parameter /KD. |
A view of the handles is provided by the Handles tab.
Handles are internal structures of the DbManager process. They are created by DB_CONNECT, PG_CONNECT, SQL_CONNECT, DB_TRANS_OPEN, and in transactional mode by every other action until the call DB_TRANS_COMMIT or DB_TRANS_ROLLBACK is called. Descriptors are bound to a specific database connection.
For each handle, its parameters are available:
ID | Identifier of the handle. |
ID Connect | Identifier of the connection within which the descriptor was created. |
Connect | Unique name of the connection within the DbManager process. |
ID Database | A unique identifier of the object of Database type within the DODM model. |
Database | A unique name of the object of Database type. |
ID Process | A unique identifier of the process within which the Database is located. In the case of DbManager instance processes, the same Database can be on several lines. |
Process | The name of the process from which the information about the Database comes. In the case of DbManager instance processes, the same Database can be on several lines. |
Handle Type | Descriptor type:
|
Table | The name of the Table or Database object (if Descriptor Type=Transaction) to which the descriptor is bound |
Comment | Comment on the descriptor creation (information about the sequence of calls within the ESL script). |
A view of group statistics of operations in databases is provided by the Database Statistics tab.
For each object of the Database type, its group statistics are available (grouped according to the types of database actions):
ID Database | A unique identifier of the object of Database type within the DODM model. |
Database | A unique name of the object of Database type. |
ID Process | A unique identifier of the process within which the Database is located. In the case of DbManager instance processes, the same Database can be on several lines. |
Process | The name of the process from which the information about the Database comes. In the case of DbManager instance processes, the same Database can be on several lines. |
Operation | The operation for which statistics are displayed. The operation is e.g. action in the script (e.g. DB(S)_READ) or work with the browser (Browser Edit, Browser Control). |
Count | The total number of operations of a specific type performed on the Database object by the DbManager process (since the start or since the last statistics reset). |
Total Duration | The total duration of operations of a specific type performed on the Database object by the DbManager process (since the start or since the last statistics reset). |
Max Duration | Duration of the longest operation of a specific type performed on the Database object by the DbManager process (since the start or since the last statistics reset). |
Max Operation | The name of the longest operation of a specific type performed on the Database object by the DbManager process (since the start or since the last statistics reset). |
Max Comment | Comment on the longest operation (information about the sequence of calls within the ESL script). |
A view of table statistics is provided by the Table Statistics tab.
For each object of the Table type, its group statistics are available (grouped according to the types of database actions):
ID Table | A unique identifier of the object of Table type within the DODM model. |
Table | A unique name of the object of Table type. |
ID Database | A unique identifier of the object of Database type within the DODM model. |
Database | A unique name of the object of Database type. |
ID Process | A unique identifier of the process within which the Database is located. In the case of DbManager instance processes, the same Database can be on several lines. |
Process | The name of the process from which the information about the Database comes. In the case of DbManager instance processes, the same Database can be on several lines. |
Operation | The operation for which statistics are displayed. The operation is e.g. action in the script (e.g. DB(S)_READ) or work with the browser (Browser Edit, Browser Control). |
Count | The total number of operations of a specific type performed on the Table object by the DbManager process (since the start or since the last statistics reset). |
Total Duration | The total duration of operations of a specific type performed on the Table object by the DbManager process (since the start or since the last statistics reset). |
Max Duration | Duration of the longest operation of a specific type performed on the Table object by the DbManager process (since the start or since the last statistics reset). |
Max Comment | Comment on the longest operation (information about the sequence of calls within the ESL script). |
Related pages: