Date parsed: 18/10/2007 23:01:37
Date: Fri, 19 Oct 2007 06:01:37 -0700

Hi,

{SQL Server 2000}

I'm just beginning to look at counters, so sorry if these are obvious.
I've just taken a look at sysperfinfo and found these values:

SQLServer:Locks Lock Requests/sec _Total -249742468
SQLServer:Locks Lock Timeouts/sec _Total 315800
SQLServer:Locks Number of Deadlocks/sec _Total 0
SQLServer:Locks Lock Waits/sec _Total 93
SQLServer:Locks Lock Wait Time (ms) _Total 6787689
SQLServer:Locks Average Wait Time (ms) _Total 6787689
SQLServer:Locks Average Wait Time Base _Total 93

Is it okay to look at _total or is it misleading?
Why is Lock Requests/sec negative?
The wait time looks very large: is this usual?

Over what time period are the averages based? How do you reset the
averages?

Cheers,

James

Date parsed: 21/10/2007 20:25:15
Date: Mon, 22 Oct 2007 03:25:15 -0700

On Oct 19, 4:56 pm, JimLad <jamesdbi...@yahoo.co.uk> wrote:
> On Oct 19, 3:28 pm, Linchi Shea <LinchiS...@discussions.microsoft.com>
> wrote:
>
>
>
>
>
> > I don't know the specifics of this particular counter. But not all perfmon
> > counters are properly instrumented. For instance, at least one of the SQL
> > waits counters I often monitor would display a very huge ridiculous number
> > from time to time, and %Disk Time is often well over 100%.
>
> > When I run into a situation like this, I know I can't rely on the counter
> > and I'll just skip the counter and focus on other counters instead. The good
> > news is that not getting proper values from one or two counters doesn't mean
> > you can't get a good assessment of your system.
>
> > Linchi
>
> > "JimLad" wrote:
> > > Hi,
>
> > > {SQL Server 2000}
>
> > > I'm just beginning to look at counters, so sorry if these are obvious.
> > > I've just taken a look at sysperfinfo and found these values:
>
> > > SQLServer:Locks Lock Requests/sec _Total -249742468
> > > SQLServer:Locks Lock Timeouts/sec _Total 315800
> > > SQLServer:Locks Number of Deadlocks/sec _Total 0
> > > SQLServer:Locks Lock Waits/sec _Total 93
> > > SQLServer:Locks Lock Wait Time (ms) _Total 6787689
> > > SQLServer:Locks Average Wait Time (ms) _Total 6787689
> > > SQLServer:Locks Average Wait Time Base _Total 93
>
> > > Is it okay to look at _total or is it misleading?
> > > Why is Lock Requests/sec negative?
> > > The wait time looks very large: is this usual?
>
> > > Over what time period are the averages based? How do you reset the
> > > averages?
>
> > > Cheers,
>
> > > James- Hide quoted text -
>
> > - Show quoted text -
>
> Thanks. Can anyone comment more specifically on this case?
>
> Cheers,
>
> James- Hide quoted text -
>
> - Show quoted text -

Hi,

To answer my own question:

BUG: sysperfinfo counters are not time-adjusted
http://support.microsoft.com/kb/555064%20

This basically says that you can't use any /sec counters from
sysperfinfo.

As for the Average Wait Time (ms), you have to divide this by the base
figure of 93, which still gives me an avergae wait of 73 seconds!

I think I'm going to abandon sysperfinfo and just use the figures from
Perf Mon. Hopefully any calculations have already been performed on
them.

James