lastwaittype = MISCELLANEOUS

Hi,
What does it really mean when lastwaittype = MISCELLANEOUS
for all the processes in sysprocesses and when waittime is
0 all the time for blocked spids?
--
Many thanks,
OskarCatch all wait types. From this source:
http://sqldev.net/misc/WaitTypes.htm
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Oskar" <anonymous@.discussions.microsoft.com> wrote in message
news:462d01c47333$c581f010$a501280a@.phx.gbl...
> Hi,
> What does it really mean when lastwaittype = MISCELLANEOUS
> for all the processes in sysprocesses and when waittime is
> 0 all the time for blocked spids?
> --
> Many thanks,
> Oskar
>
>|||Hi,
OK, let me rephrase that: what does "catch all wait types"
actually mean? The explanation given there seems very
cryptic to me. And what about ubiquitous 0 values for
waittime?
--
Sincerely,
Oskar
>--Original Message--
>Catch all wait types. From this source:
>http://sqldev.net/misc/WaitTypes.htm
>
>--
>----
--
>----
--
>--
>Need SQL Server Examples check out my website at
>http://www.geocities.com/sqlserverexamples
>"Oskar" <anonymous@.discussions.microsoft.com> wrote in
message
>news:462d01c47333$c581f010$a501280a@.phx.gbl...
>> Hi,
>> What does it really mean when lastwaittype =MISCELLANEOUS
>> for all the processes in sysprocesses and when waittime
is
>> 0 all the time for blocked spids?
>> --
>> Many thanks,
>> Oskar
>>
>
>.
>|||Catch all generally means it did not fit into any of the other defined
categories, and did not deserve to have a special category created for it...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Oskar" <anonymous@.discussions.microsoft.com> wrote in message
news:462d01c47333$c581f010$a501280a@.phx.gbl...
> Hi,
> What does it really mean when lastwaittype = MISCELLANEOUS
> for all the processes in sysprocesses and when waittime is
> 0 all the time for blocked spids?
> --
> Many thanks,
> Oskar
>
>|||0 means waittime < 1 ms or not waiting.
"Oskar" <anonymous@.discussions.microsoft.com> wrote in message
news:4a0601c47396$585c0210$a301280a@.phx.gbl...
> Hi,
> OK, let me rephrase that: what does "catch all wait types"
> actually mean? The explanation given there seems very
> cryptic to me. And what about ubiquitous 0 values for
> waittime?
> --
> Sincerely,
> Oskar
>
> >--Original Message--
> >Catch all wait types. From this source:
> >
> >http://sqldev.net/misc/WaitTypes.htm
> >
> >
> >--
> >
> >----
> --
> >----
> --
> >--
> >
> >Need SQL Server Examples check out my website at
> >http://www.geocities.com/sqlserverexamples
> >"Oskar" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:462d01c47333$c581f010$a501280a@.phx.gbl...
> >> Hi,
> >>
> >> What does it really mean when lastwaittype => MISCELLANEOUS
> >> for all the processes in sysprocesses and when waittime
> is
> >> 0 all the time for blocked spids?
> >>
> >> --
> >> Many thanks,
> >> Oskar
> >>
> >>
> >>
> >
> >
> >.
> >|||Hi,
It is a bug, actually:
http://support.microsoft.com/?id=812915
--
Many thanks,
Oskar
>--Original Message--
>0 means waittime < 1 ms or not waiting.
>"Oskar" <anonymous@.discussions.microsoft.com> wrote in
message
>news:4a0601c47396$585c0210$a301280a@.phx.gbl...
>> Hi,
>> OK, let me rephrase that: what does "catch all wait
types"
>> actually mean? The explanation given there seems very
>> cryptic to me. And what about ubiquitous 0 values for
>> waittime?
>> --
>> Sincerely,
>> Oskar
>>
>> >--Original Message--
>> >Catch all wait types. From this source:
>> >
>> >http://sqldev.net/misc/WaitTypes.htm
>> >
>> >
>> >--
>> >
>> >----
--
>> --
>> >----
--
>> --
>> >--
>> >
>> >Need SQL Server Examples check out my website at
>> >http://www.geocities.com/sqlserverexamples
>> >"Oskar" <anonymous@.discussions.microsoft.com> wrote in
>> message
>> >news:462d01c47333$c581f010$a501280a@.phx.gbl...
>> >> Hi,
>> >>
>> >> What does it really mean when lastwaittype =>> MISCELLANEOUS
>> >> for all the processes in sysprocesses and when
waittime
>> is
>> >> 0 all the time for blocked spids?
>> >>
>> >> --
>> >> Many thanks,
>> >> Oskar
>> >>
>> >>
>> >>
>> >
>> >
>> >.
>> >
>
>.
>sql