Wednesday, March 7, 2012

blocking

I have seen spids blocking it self alot, after installing sql sp4.
As anyone notiice this?
Thanks,
Peteryup
"peter" <peter@.discussions.microsoft.com> wrote in message
news:BCB6734A-0F85-46E8-B476-8F55C13A1132@.microsoft.com...
>I have seen spids blocking it self alot, after installing sql sp4.
> As anyone notiice this?
> Thanks,
> Peter|||Thanks for the response.
Is this a bug or does this cause performance issue?
"David J. Cartwright" wrote:

> yup
> "peter" <peter@.discussions.microsoft.com> wrote in message
> news:BCB6734A-0F85-46E8-B476-8F55C13A1132@.microsoft.com...
>
>|||dont know if bug and i have not seen any performance degridation...although
i do not have a big transactional db...more of a warehouse type situation
with bulk inserts, which his where i have seen this occur, but they have not
slowed or taken more time
what have you seen ?
"peter" <peter@.discussions.microsoft.com> wrote in message
news:61F37E3E-9152-47C9-A2CB-5E5C03F3CA59@.microsoft.com...[vbcol=seagreen]
> Thanks for the response.
> Is this a bug or does this cause performance issue?
>
> "David J. Cartwright" wrote:
>|||I have seen alot of blocking, which I did not see when I had sp3a.
"David J. Cartwright" wrote:

> dont know if bug and i have not seen any performance degridation...althou
gh
> i do not have a big transactional db...more of a warehouse type situation
> with bulk inserts, which his where i have seen this occur, but they have n
ot
> slowed or taken more time
> what have you seen ?
> "peter" <peter@.discussions.microsoft.com> wrote in message
> news:61F37E3E-9152-47C9-A2CB-5E5C03F3CA59@.microsoft.com...
>
>

No comments:

Post a Comment