When executed against a database in which blocking occur, below script will report lockType, Object waited for and current Wait times. The script requires access to master..systables. The script queries syslockInfo (as does sp_lock), but further joins sysprocesses with an interpretation of waitresource matching SQL Server 7.0 and SQL Server 2000.
2002-01-14
2,548 reads
Parameter Sensitive Plan (PSP) optimization is a new feature in SQL Server 2022 that...
By Arun Sirpal
Chaos engineering is fun but especially important when building solutions in the cloud. It...
By DataOnWheels
I am proud to announce the launch of a new book, centered around the...
Are you looking to buy Errli Gummi Sharks online? Explore our website www.aussiethcedibles.com to...
Our IT department contacted me recently and asked if they should change the default...
Hi there, I'm on a team developing an enterprise data warehouse for our organization....
Ask SSC