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,
Oskar
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,
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[vbcol=seagreen]
>news:462d01c47333$c581f010$a501280a@.phx.gbl...
MISCELLANEOUS[vbcol=seagreen]
is
>
>.
>
|||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...[vbcol=seagreen]
> 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
>
> --
> --
> message
> MISCELLANEOUS
> is
|||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[vbcol=seagreen]
>news:4a0601c47396$585c0210$a301280a@.phx.gbl...
types"[vbcol=seagreen]
--[vbcol=seagreen]
--[vbcol=seagreen]
waittime
>
>.
>