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 […]
Troubleshooting Performance in Azure SQL Database
At some point, whether you’re a DBA, developer, or application administrator, you’re going to find yourself troubleshooting performance […]
Free Webcast Today: How to Measure Your SQL Server
If you get into a car, how do you know if the car is fast or not? You […]