lastwaittype

Hi,
Can anyone please tell me what's the real purpose of
lastwaittype column in sysprocesses if any?
Thanks,
OskarOskar,
Lastwaittype is the same as waittype if waittime = 0. If waittime > 0,
lastwaittype is the waittype causing the wait. In other words, lastwaittype
is the resource type we are waiting on, if we are waiting.
Jon Jahren
"Oskar" <anonymous@.discussions.microsoft.com> wrote in message
news:596b01c4cb03$ec7641d0$a401280a@.phx.gbl...
> Hi,
> Can anyone please tell me what's the real purpose of
> lastwaittype column in sysprocesses if any?
> --
> Thanks,
> Oskar
>|||Thanks Jon! That was very clear.
Seems like it is very difficult with some types of
waittypes to see the waittime larger than a few
miliseconds. So apparently you have to rely on lastwaittype.

>--Original Message--
>Oskar,
>Lastwaittype is the same as waittype if waittime = 0. If
waittime > 0,
>lastwaittype is the waittype causing the wait. In other
words, lastwaittype
>is the resource type we are waiting on, if we are waiting.
>Jon Jahren
>"Oskar" <anonymous@.discussions.microsoft.com> wrote in message
>news:596b01c4cb03$ec7641d0$a401280a@.phx.gbl...
>
>.
>|||You can get better aggregations of waittime using DBCC SQLPERF(WAITSTATS).
Tom Davidson has a nice article on this in SQL Server Magazine.
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Oskar" <anonymous@.discussions.microsoft.com> wrote in message
news:0c7f01c4cb22$c40f7350$a501280a@.phx.gbl...[vbcol=seagreen]
> Thanks Jon! That was very clear.
> Seems like it is very difficult with some types of
> waittypes to see the waittime larger than a few
> miliseconds. So apparently you have to rely on lastwaittype.
>
> waittime > 0,
> words, lastwaittype