MsSQL
Use the following procedure for monitoring the MsSQL database.
- Navigate to Database monitoring on the left pane.
- Select MsSQL from the Select database drop-down list.
- Select a service from the Select service drop-down list.
- Select a database from the Select database drop-down list.
A screen similar to the following appears along with the various available tabs.
The cluster information is displayed in the Cluster Info pane at the top of the screeen.
Hardware
The Hardware tab is selected by default. The following widgets are displayed.
| Widget Name | Description |
|---|---|
| CPU usage | Refers to the amount of processing power consumed by the database server while executing queries, performing transactions, and managing system operations. |
| Memory usage | Refers to the amount of system memory (RAM) utilized by the database management system (DBMS) for various operations, including caching data, managing connections, and executing queries. |
| Network I/O | Refers to the amount of data transmitted between the database server and client applications or other servers over a network. |
| Disk usage | Refers to the amount of disk space consumed by the database files, including data files, log files, and index files. |
| Total bytes read | Refers to the cumulative amount of data that has been read from disk or memory by the database management system (DBMS). |
| Total bytes write | Refers to the cumulative amount of data that has been written to disk by the database management system (DBMS). |
Processes
| Widget Name | Description |
|---|---|
| Background process count | This widget is a graph widget which displays the count of background processes of the selected node. |
| Blocked processes count | This widget is a graph widget which displays the number of blocked processes of the selected node. |
| Forced parameterizations | This widget is a graph widget which displays the forced parameterizations of the selected node. |
| Runnable processes count | This widget is a graph widget which displays the number of runnable processes of the selected node. |
| Runnable tasks count | This widget is a graph widget which displays the number of runnable tasks of the selected node. |
| Running processes count | This widget is a graph widget which displays the count of processes running of the selected node. |
| Sleeping processes count | This widget is a graph widget which displays the number of sleeping processes of the selected node. |
| Suspend processes count | This widget is a graph widget which displays the number of suspended processes of the selected node. |
| Transactions | This widget is a graph widget which displays the number of transactions of the selected node. |
| SQL compilations | This widget is a graph widget which displays the number of SQL compilations of the selected node. |
| SQL recompilations | Refers to the process where the database engine re-evaluates and regenerates the execution plan for a SQL statement. |
| System wait time | Refers to the amount of time that a process or transaction spends waiting for resources or events to proceed with its execution. |
| Average page splits | Refers to the average number of times a data page is split during insert, update, or delete operations. |
Query performance
| Widget Name | Description |
|---|---|
| Query throughput | Refers to the rate at which queries are processed over a certain period. |
| Lock wait time | Refers to the duration a transaction or query must wait for a lock to be released by another transaction. |
| Total queries | Refers to the cumulative number of SQL statements (queries) executed against the database since it started. |
| Slow select queries | Refer to SQL SELECT statements that take an unusually long time to execute, often resulting in poor performance. |
| Query threshold | Refers to a predefined limit set to identify and flag queries that exceed a certain execution time or resource usage. |
Connections
| Widget Name | Description |
|---|---|
| Total sessions and active sessions | Provide insights into how many users or processes are currently connected to the database and actively interacting with it. |
| Total connections and active connections | Help in understanding the current load on the database and managing resources efficiently, particularly in high-concurrency environments. |
| Available threads & Connected threads | Help track database capacity for handling concurrent connections, impacting performance, scalability, and resource management. |
| Active cursor | Refers to a cursor currently in use, actively fetching or manipulating data within an open transaction or query. |
| Cached cursor count | Refers to the number of cursors that are kept in memory (cached) to be reused for subsequent operations within the same session. |
| Cursor requests | The number of requests made to create or use a cursor within the database. |
| Session details | Provides information on the number of active database sessions or connections at any given time. |
Metrics
| Widget Name | Description |
|---|---|
| Buffer pool size per Db in bytes | This widget is a graph widget which displays the buffer pool size per database in bytes of the selected database. |
| Transaction log growth | This widget is a graph widget which displays the number of expansions of the selected database. |
| Deadlocks | Represents the number of deadlock incidents detected in the database. |
| User errors | This widget is a graph widget which displays the number of user errors of the selected node. |
| Buffer pool size in bytes | This widget is a graph widget which displays the number of bufferpool size (in bytes) of the selected node. |
| System buffer pool hit percentage | This widget is a graph widget which displays the number of system bufferpool hit percent of the selected node. |
| Total open files | The number of file descriptors currently in use by the database. |