SQLServer:Locks(_Total)\Lock Requests/sec

12 May 2005 9:54 AM

SQLCatz

For a certain performance related problem that we are examining, I captured
the "SQLServer:Locks(_Total)\Lock Requests/sec" in PerfMon.
Got very high values.
Is it true that a large number of the requests will be for System related
objects and not the actual user defined objects?
I know that it is possible to cut out the system related numbers from being
captured while using the Profiler, but how do I achieve the same when using
PerfMon?

Cheers!
SQLCatZ

19 May 2005 6:44 PM

Santeri Voutilainen [MSFT]

You can not exclude system related lock request from the PerfMon counters.
The counters are instance wide and do not distinguish between different
types of objects.

--
Santeri (Santtu) Voutilainen

This posting is provided "AS IS" with no warranties, and confers no rights.

Show quote

"SQLCatz" <SQLC***@discussions.microsoft.com> wrote in message
news:9C5D9D73-A31E-482A-8592-FAA2E584F780@microsoft.com...
> For a certain performance related problem that we are examining, I
> captured
> the "SQLServer:Locks(_Total)\Lock Requests/sec" in PerfMon.
> Got very high values.
> Is it true that a large number of the requests will be for System related
> objects and not the actual user defined objects?
> I know that it is possible to cut out the system related numbers from
> being
> captured while using the Profiler, but how do I achieve the same when
> using
> PerfMon?
>
> Cheers!
> SQLCatZ