ManageEngine® SQLDBManager Plus Memory | ||
Memory Usage
Parameters |
Description |
Total Memory |
Total amount of dynamic memory the server is currently consuming. |
SQL Cache Memory |
Total amount of dynamic memory the server is using for the dynamic SQL cache. |
Lock Memory |
Total amount of dynamic memory the server is using for locks. |
Optimizer Memory |
Total amount of dynamic memory the server is using for query optimization. |
Connection Memory |
Total amount of dynamic memory the server is using for maintaining connections. |
Granted WorkSpace Memory |
Total amount of memory granted to executing processes. This memory is used for hash, sort and create index operations. |
Memory Grants Pending |
Current number of processes waiting for a workspace memory grant. |
Memory Grants Success |
Current number of processes that have successfully acquired a workspace memory grant. |
Buffer Manager Statistics
Parameters |
Description |
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. |
Access Method Details
Parameters |
Description |
Full Scans/Min |
Displays the number of unrestricted full scans. These can either be base table or full index scans. |
Range Scans/Min |
Displays the number of qualified range scans through indexes. |
Probe Scans/Min |
Displays the number of probe scans. A probe scan is used to directly look up rows in an index or base table. |
Work Files Created/Min | Displays the number of work files created per minute. These work files could be used to store temporary results for hash joins and hash aggregates. |
Work Tables Created/Min | Displays the number of work tables created per minute. These work tables could be used to store temporary results for query spool, LOB variables, XML variables, and cursors. |
Free Space Scans/Min | Displays the number of scans per minute that were initiated to search for free space within pages already allocated to an allocation unit to insert or modify record fragments. |
Lazy Writes/Min | Displays the number of buffers written by buffer manager's lazy writer per minute. |
Scan point revalidation/Min | Displays the number of times the scan point had to be revalidated to continue the scan. |
Index Searches/Min | Displays the number of index searches per minute. These index searches are used to start range scans, single index record fetches, and to reposition within an index. |
Cache Details
Parameters |
Description |
Cache Hit Ratio |
Displays the ratio between cache hits and lookups. |
Cache Used/Min |
Displays the number of times each type of cache object has been used. |
Cache Count |
Displays the number of cache objects in the cache. |
Cache Pages |
Displays the number of 8k pages used by cache objects. |
Total Log Cache Hit Ratio | Displays the overall total percentage of log cache reads that were satisfied from the log cache. |
Table Lock Escalations/Min | This denotes the number of times locks on a table were escalated per minute. |
Lock Details
Parameters |
Description |
Lock Requests/Min |
Number of new locks and lock conversions requested from the lock manager. |
Lock Waits/Min |
Total wait time for locks in the last minute. |
Lock Timeouts/Min |
Number of lock requests that timed out. This includes internal requests for NOWAIT locks. |
Deadlocks/Min |
Number of lock requests that resulted in a deadlock. |
Average Lock Wait Time |
The average amount of wait time for each lock request that resulted in a wait. |
Latch Details
Parameters |
Description |
Latch Waits/Min |
Number of latch requests that could not be granted immediately and had to wait before being granted. |
Average Latch Wait Time |
Average latch wait time for latch requests that had to wait. |
Host |
Sessions |