The dev server got bogged down during a deployment and lock timeouts were everywhere. Was the perfmon counter way off about how much memory was being used just for locks?
In this 19 minute episode…
- 00:33 What’s new @ SQL Workbooks: Down the Rabbit Hole
- 03:00 This week’s question about lock timeouts & memory in SQL Server
Note: it does say Episode #36 at the beginning of the video, but this is really episode #37. So much for memory!