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...
> >I have seen spids blocking it self alot, after installing sql sp4.
> >
> > As anyone notiice this?
> >
> > Thanks,
> > Peter
>
>|||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...
> 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...
>> >I have seen spids blocking it self alot, after installing sql sp4.
>> >
>> > As anyone notiice this?
>> >
>> > Thanks,
>> > Peter
>>|||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...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...
> > 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...
> >> >I have seen spids blocking it self alot, after installing sql sp4.
> >> >
> >> > As anyone notiice this?
> >> >
> >> > Thanks,
> >> > Peter
> >>
> >>
> >>
>
>