Why Adding Some Memory Doesn’t Fix All Caching Problems
It seems obvious: add some memory, and SQL Server should be able to cache data, thereby making queries […]
Wait Stats
What Do the LCK_M_SCH_M and LCK_M_IS Wait Types Indicate?
You’re investigating your SQL Server’s top wait stats, and you’re noticing a lot of LCK% waits. Normally, that […]