MEMORYCLERK_SQLGENERAL and sql memory memory usage

01 April,2013 by Jack Vamvas

Question: One question. I've run a query that returns top 10 consumers... there was a record as

MEMORYCLERK_SQLGENERAL 31345424

what is the  MEMORYCLERK_SQLGENERAL ?

Answer: The MEMORYCLERK_SQLGENERAL is a general memory clerk. It’s responsible for a number of SQL activities such as XML preparation. Other busier memory clerks , such as MEMORY_CLERK_SQLBUFFERPOOL  , get their own clerk.

Memory Clerks are consumers of memory in SQL Server. There are four kinds of clerks,  1) generic 2) cache store 3)object store 4) user store. The memory clerks use the memory node allocators to allocate memory.

SQL Server  predefines Memory Clerks. Each clerk relates allocation type required.

The sys.dm_os_memory_clerks  DMV and DBCC MEMORYSTATUS  reports the clerk information . The DMV sys.dm_os_memory_clerks - Returns the set of all memory clerks that are currently active in the instance of SQL Server

 

--Use the DMV to see how much memory relates to 'MEMORYCLERK_SQLGENERAL'

select * from sys.dm_os_memory_clerks where type = 'MEMORYCLERK_SQLGENERAL'

 

For a detailed breakdown Memory objects allocated by SQL Server

Read More

SQL Server – Min Memory Per query and performance

SQL Server - How much resource is a SQL database using - memory, disk, IOPS,CPU

 


Author: Jack Vamvas (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on MEMORYCLERK_SQLGENERAL and sql memory memory usage


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer