SQL Server Performance Forum – Threads Archive
MemToLeave ValueHi 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 http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=19594&SearchTerms=joe,chang,vas
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.