Introduction
Database is the core of business-critical web applications.
Identifying and tuning database-related performance problems can be an
extremely labor intensive and error prone process. To ease this
process, QEngine Web Performance test tool offers the database
monitoring feature. Database Monitoring feature allows you to monitor
the database parameters for databases such as MySQL, Oracle and MSSQL.
Note: To
monitor databases other than MySQL, Oracle or MSSQL, contact us at http://forums.manageengine.com/test-automation/qengine
Parameters
Monitored for MySQL
Thread Details:
-
Threads_connected - The
number of currently open connections.
-
Threads_created -
The number of threads created to handle connections.
-
Threads_running - The
number of threads that are not sleeping.
Threads_cached - The
number of threads in the thread cache.
Connection Details:
-
Max_used_connections -
The maximum number of connections that have been in use simultaneously
since the server started.
-
Aborted_clients - The number of
connections that were aborted because the client died without closing
the connection properly.
-
Aborted_connects - The
number of tries to connect to the MySQL server that failed.
Connections - The
number of connection attempts (successful or not) to the MySQL server.
Temporary Tables:
Throughput:
Query Details:
The Com_xxx statement
counter variables indicate the number of times each xxx statement has been executed.
There is one status variable for each type of statement. For example, Com_delete and Com_insert
count DELETE and INSERT
statements, respectively.
Table Related Statistics
-
Table_locks_waited - The
number of times that a table lock could not be acquired immediately and
a wait was needed. If this is high and you have performance problems,
you should first optimize your queries, and then either split your
table or tables or use replication.
-
Open_tables - The
number of tables that are currently open.
-
Table_locks_immediate -The number of times that
a table lock was acquired immediately.
Parameters
Monitored for MS SQL Server
Connection Statistics
- Connection
Time - Time taken to get connected to the MS SQL database server.
- Active
Connections - Number of users connected to the system.
- Logins/Min
- Total number of logins started per minute.
- Logouts/Min - Total number of logouts
started per minute.
SQL
Statistics
- Batch
Requests/Min - Number of SQL batch requests received by server.
- SQL
Compilations/Min - Number of SQL compilations.
- SQL Recompilations/Min - Number of SQL
re-compiles.
Buffer
Manager Statistics
- Buffer
Hit Ratio - Percentage of pages that were found in the buffer pool
without having to incur a read from disk.
- Page
LookUps/Min - Number of requests to find a page in the buffer pool.
- Page
Reads/Min - Number of physical database page reads issued.
- Page
Writes/Min - Number of physical database page writes issued.
- Total
Pages - Number of pages in the buffer pool (includes database, free,
and stolen).
- Database
Pages - Number of pages in the buffer pool with database content.
- Free Pages - Total number of pages on all
free lists.
Database Details
Transaction Details - Gives the number of transaction per minute,
replication transaction per minute, and the active transactions.
Configuring
DB Monitoring
Database Monitoring is supported for Windows and Linux platforms.
You can configure database monitoring details by clicking the Database Monitoring link under Load Details section of the Load
Test screen.
To know the details of configuring database monitoring, please refer
to the Database Monitoring.
