I was just looking in Profier wanting to capture blocking info and I dont
see it. sp_who and dbcc inputbuffer are good but, what if the the blocking
spid keeps changing? It would seem to me that there would be a way to get
all blocking info on every spid involved?
TIA, ChrisRHi Chris,
You can use the script in this article to capture blocking information.
http://support.microsoft.com/defaul...kb;en-us;271509
Another way is to use PSSDIAG to capture blocking as well, which is
essentially running the same script.
Yih-Yoon Lee
E-mail: yihyoon@.gmail.com
ChrisR wrote:
> I was just looking in Profier wanting to capture blocking info and I dont
> see it. sp_who and dbcc inputbuffer are good but, what if the the blocking
> spid keeps changing? It would seem to me that there would be a way to get
> all blocking info on every spid involved?
> TIA, ChrisR
>|||Thanks Yih.
"Yih-Yoon Lee" <yihyoon@.gmail.com> wrote in message
news:OYuJiXFbFHA.2520@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Hi Chris,
> You can use the script in this article to capture blocking information.
> http://support.microsoft.com/defaul...kb;en-us;271509
> Another way is to use PSSDIAG to capture blocking as well, which is
> essentially running the same script.
> Yih-Yoon Lee
> E-mail: yihyoon@.gmail.com
> ChrisR wrote:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment