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...
>> Hi,
>> Can anyone please tell me what's the real purpose of
>> lastwaittype column in sysprocesses if any?
>> --
>> Thanks,
>> Oskar
>
>.
>|||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...
> 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...
> >> Hi,
> >>
> >> Can anyone please tell me what's the real purpose of
> >> lastwaittype column in sysprocesses if any?
> >>
> >> --
> >> Thanks,
> >> Oskar
> >>
> >
> >
> >.
> >

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

lastwaittype

Hi,
Can anyone please tell me what's the real purpose of
lastwaittype column in sysprocesses if any?
Thanks,
Oskar
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...
> 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