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,587 reads
So, you want to get your SQL skills razor-sharp without dropping any cash? You're...
By Steve Jones
Here are the slides from my talk today at the Redgate NYC Devour Hour:...
By Steve Jones
If you have any doubt about being able to carry a load in one...
Hi everyone I have a SP that just failed. Format of SP is: Select...
Comments posted to this topic are about the item Analyzing Tempdb Spills and Usage...
Comments posted to this topic are about the item Creating a new API in...
If I run "dab init" to create a new API over a database, what parameters are required?
See possible answers