| Author |
waitresource intepretation
|
|
| Hassan 2006-02-16, 3:23 am |
| I see values of 2:3:22 for waitresource
Can someone tell me what those values represent ?
| |
| Kalen Delaney 2006-02-16, 3:23 am |
|
It could be a db:file:page or a file:page:row. Where are you seeing it? What
other info is associated with it?
--
HTH
Kalen Delaney, SQL Server MVP
www. solidqualitylearning
.com
"Hassan" <Hassan@hotmail.com> wrote in message
news:uELJ$5qMGHA.1616@TK2MSFTNGP10.phx.gbl...
>
> I see values of 2:3:22 for waitresource
>
> Can someone tell me what those values represent ?
>
>
>
>
| |
| Hassan 2006-02-16, 3:23 am |
| I queried sysprocesses. The lastwaittype is PAGELATCH_UP
The waittype and waittime is 0
"Kalen Delaney" < replies@public_newsg
roups.com> wrote in message
news:u13aORrMGHA.2176@TK2MSFTNGP10.phx.gbl...
>
> It could be a db:file:page or a file:page:row. Where are you seeing it?
> What other info is associated with it?
>
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www. solidqualitylearning
.com
>
>
> "Hassan" <Hassan@hotmail.com> wrote in message
> news:uELJ$5qMGHA.1616@TK2MSFTNGP10.phx.gbl...
>
>
>
| |
| Kalen Delaney 2006-02-16, 3:23 am |
|
Then it's probably the db:file:page. DB 2 is the tempdb database. Since
current waittype and waittime is 0, it looks like it's not causing any
problems. Why are you asking about it?
--
HTH
Kalen Delaney, SQL Server MVP
www. solidqualitylearning
.com
"Hassan" <Hassan@hotmail.com> wrote in message
news:OamGH6rMGHA.3960@TK2MSFTNGP09.phx.gbl...
>
> I queried sysprocesses. The lastwaittype is PAGELATCH_UP
>
>
> The waittype and waittime is 0
>
> "Kalen Delaney" < replies@public_newsg
roups.com> wrote in message
> news:u13aORrMGHA.2176@TK2MSFTNGP10.phx.gbl...
>
>
>
| |
| Hassan 2006-02-16, 3:23 am |
| I have a lot of those similar values in the waitresource column
"Kalen Delaney" < replies@public_newsg
roups.com> wrote in message
news:OfvlpLsMGHA.2176@TK2MSFTNGP10.phx.gbl...
>
> Then it's probably the db:file:page. DB 2 is the tempdb database. Since
> current waittype and waittime is 0, it looks like it's not causing any
> problems. Why are you asking about it?
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www. solidqualitylearning
.com
>
>
> "Hassan" <Hassan@hotmail.com> wrote in message
> news:OamGH6rMGHA.3960@TK2MSFTNGP09.phx.gbl...
>
>
>
|
|
|
|