MemToLeave Value | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

MemToLeave Value

Hi everybody…
i am new to the foram … i am having i problem i want to know the configured and the used size of the MemToLeave buffer.
is there any counters or dbcc command toknow these values. thanks
Look for sys.dm_os_memory_clerks in this case. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
Check the following two topic which explains very well and one of them has the script… http://www.sql-server-performance.c…ote&REPLY_ID=89629&TOPIC_ID=19498&FORUM_ID=24,chang,vas
Moderator All postings are provided “AS IS” with no warranties for accuracy.