DbManager Diagnostic Pack

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).
Total Queued	Total waiting time of messages in the queues of database tasks (since the start or since the last statistics reset).
Max Queued	Duration of the longest waiting time of messages in the queues of database tasks (since the start or since the last statistics reset).

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.
Busy Details	Busy status details - details about the activity being performed.
Connect Type	Connection type: NonTransact - non-transactional connection (shared) Transact - transactional connection (exclusively assigned to the script by the DB_TRANS_OPEN action) Browse - a non-transactional connection reserved for the Browser display (if such a connection is enabled in the configuration of the Database object by the Reserved browser connections parameter. Note: A transactional connection that has a Normal status is suspicious. If it is inactive for a longer time (Idle), it is an uncommitted transaction that do nothing (and potentially blocks other connections). If it is active for a longer time (Busy), this is a long-running database action that should be analyzed and ideally optimized (to shorten its duration).
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 - table handle can be opened from process D2000 HI through the list of database tables, in the Browser, or from script by using the actions DB_CONNECT, PG_CONNECT, SQL_CONNECT, SQL_PREPARE as well as for a short period of time (during an action) by calling DBS_* actions. Transaction - transaction handle can be opened by the action DB_TRANS_OPEN. ConnectString - connection handle is opened by the SQL_CONNECT, if the first parameter of the action is connectString. Database - database handle is opened by the action SQL_CONNECT, if the first parameter of the action (dbObjIdent) is of Database 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), work with the browser (Browser Edit, Browser Control), automatic data refresh in the browser (Browser Autorefresh), or waiting for requests in service task queues (Queued time).
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:

DbManager - Tuning and Debugging

Strom stránky

DbManager Diagnostic Pack