Diagnosing and Resolving Spinlock Contention on SQL Server sqlcat.com/.../2011
Guys,
First a BIG THANKS for the document. I'm sure is gonna help a lot of SQL users understand the functionality/behavior of latches.
The document, on page 8 refers to sys.dm_os_latch_stats twice whereas it should have been refering to sys.dm_db_index_operational_stats.
Cheers,
Shankar
Pingback from SQL Server: Diagnosing and Resolving Latch & Spinlock Contention … « notes from a software alchemist
Thanks Shankar, I've flagged this with our documentation team, they'll edit the typo and republish. Glad you liked the paper.
Ewan
Pingback from New whitepapers on latches and spinlocks published | devblogging.com