How quickly check memory usage / status in SQL Server 2005 2008

Posted by Leszek Polnik | Posted in | Posted on 23:39

0

Run below query in SQL:
DBCC MEMORYSTATUS
Explanations of headers:
  • Memory Manager: shows overall memory consumption by SQL Server
  • Memory node Id: usage for each memory node: summary of memory usage
  • MEMORYCLERK_SQLGENERAL: aggregate for each memory node: aggregate memory
  • Buffer distribution: the distribution of 8-kilobyte (KB) buffers in the buffer pool
  • Buffer Counts: Buffer pool details from sys.dm_os_buffer_descriptors
  • Procedure cache: Size and type
  • Global memory objects: size of the global memory objects
  • Query memory objects: snapshot of the query memory usage: the workspace memory
  • Optimization Queue: summary of the users who are trying to optimize queries at the same time
  • MEMORYBROKER_FOR_CACHE: control cached memory, stolen memory, and reserved memory

Comments Posted (0)

Post a Comment

Subscribe to: Post Comments (Atom)