|
|
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.adventnet.com/viewforum.php?f=25
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:
Created_tmp_disk_tables
- temp table in disk.
Created_tmp_tables
- temp tables in memory.
Throughput:
Bytes_received - Bytes_received
from all clients
Bytes_sent - The
number of bytes sent to all clients.
Query Details:
Qcache_lowmem_prunes - The
number of queries that were deleted from the cache because of low
memory.
Total Number of reads
Total Number of writes
Total Number of deletes
Slow_queries - The
number of queries that have taken more than long_query_time seconds.
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.
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 next topic.
|
|