ManageEngine® SQLDBManager Plus


Memory

<< Prev

Home

Next >>

 

SQL Server - Memory Metrics

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.


<< Prev

Home

Next >>

Host

Sessions