|
|
|
|
|
|
|
|
|
DBCC InputBuffer - Seeing the Last Executed Command
A really common DBA task is to figure out what a blocking spid is executing that is causing the problem. If you know the spid, DBCC Inputbuffer is a fast and simple technique for looking at that process, and it works at least back to SQL 7!
|
|
|
|
Duration:
|
1
mins
49
secs
|
|
Skill Level:
|
100
|
|
Rating:
|
4.38
out of 5
|
|
Publish Date:
|
December 29, 2010
|
|
|
|
About the Author
|
|
Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.
|
|
References
|
|
Comments
|
|
I never knew about the dbcc inputbuffer() command. Very cool and useful!
|
|
John Janzen on
12/29/2010
Very useful information, clearly and directly communicated
|
|
|
none
|
|
|
Great tip.
|
|
|
very useful. Is there a way to know the SPID of a specific logged in user?
|
|
|
Good to know. I could have used it a couple of days ago!
|
|
Maurice Ivory on
2/11/2011
better understanding
|
|
|
I learnt something new (and very useful too0. Great tip.
|
|
|
great..simple and straight forward presentation.
|
|
|
always....a great command....
|
Must Be Logged In
|
|
|
|
|