July 13, 2009 at 4:40 am
using dbcc inputbuffer(SPID)
It doesn't provide the entire string available in the buffer.
Is there any other way, I can query and see what is the exact statement being fired through the SPID?
This will help to debug many issues in blocking, deadlocking..!
Regards
Sourav
Thanks.
July 13, 2009 at 5:40 am
Hi,
Check out this article.
http://www.mssqltips.com/tip.asp?tip=1363
It may also be a good approach to get a profiler session running, this will give you all the session information you may require, you can leave it running for as long as you need to (depending how much activity you get). It may give you an insight into any locking issues you are experiencing.
Hope this helps
Jackal
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply