Arthur Kirchner (11/22/2012)
I am sorry,I trusted Pinal Dave on this one, without crosschecking MS:
http://blog.sqlauthority.com/2011/02/15/sql-server-lck_m_xxx-wait-type-day-15-of-28/
who wrote
"LCK_M_SCH_S - Occurs when a task is waiting to acquire a Schema Share lock."
an correctly it's
SCH_S <=> Schema stability
SCH_M <=> Schema modification
Hi Arthur,
The reason I wrote this script is hopefully clearify the meaning of the wait stats as it can be quite confussing. So I just looked at Microsoft for answers but they too have has some errors in their discriptions too. So you (and Dave) could be right. If you find more information on this, please let me know as I want this script to help DBAs not confuse them.
Really don't understand why this topic has to be so confusing. :hehe:
Big thanks!
Rudy
Rudy