lock blocks under SQLServer.Memory Manager

I'm trying to use the performance monitor on Win2K Adv Server to
troubleshoot performance issues I have on a MSSQL box.
I was trying to find out if there was a lot of blocking on my databases
creating the performance problems.
I starting tracing the counter called "lock Blocks" under "SQLServer.Memory
Manager" and found out that the average value was 4000 with picks at 8000.
I'm not too sure if I understand the exact meaning of this counter. Can
someone explain it to me and tell me if the values I'm getting are bad or
normal?
Thank youHow many rows do you get when you execute this:
select * from master..sysprocesses
where blocked > 0
I am a bit puzzled as to what the figure in lock blocks
actually means. I created a lock block and in perfmon I
got a figure of 1013. I will investigate further what this
figure means.
If you are concerned about blocking locks, then use the
above query and sp_lock to find out what is blocking. You
can also use DBCC INPUTBUFFER (SPID) to find out what was
submitted that caused the block.
Mark Allison
SQL Server MVP
>--Original Message--
>I'm trying to use the performance monitor on Win2K Adv
Server to
>troubleshoot performance issues I have on a MSSQL box.
>I was trying to find out if there was a lot of blocking
on my databases
>creating the performance problems.
>I starting tracing the counter called "lock Blocks"
under "SQLServer.Memory
>Manager" and found out that the average value was 4000
with picks at 8000.
>I'm not too sure if I understand the exact meaning of
this counter. Can
>someone explain it to me and tell me if the values I'm
getting are bad or
>normal?
>Thank you
>
>.
>|||i ran your query and I didn't get any rows back.. I guess blocking is not my
problem then...
thank you Mark
"Mark Allison" <mark@.allisonmitchell.c0m> wrote in message
news:080c01c3b427$576ab100$a001280a@.phx.gbl...
> How many rows do you get when you execute this:
> select * from master..sysprocesses
> where blocked > 0
> I am a bit puzzled as to what the figure in lock blocks
> actually means. I created a lock block and in perfmon I
> got a figure of 1013. I will investigate further what this
> figure means.
> If you are concerned about blocking locks, then use the
> above query and sp_lock to find out what is blocking. You
> can also use DBCC INPUTBUFFER (SPID) to find out what was
> submitted that caused the block.
> Mark Allison
> SQL Server MVP
> >--Original Message--
> >I'm trying to use the performance monitor on Win2K Adv
> Server to
> >troubleshoot performance issues I have on a MSSQL box.
> >I was trying to find out if there was a lot of blocking
> on my databases
> >creating the performance problems.
> >I starting tracing the counter called "lock Blocks"
> under "SQLServer.Memory
> >Manager" and found out that the average value was 4000
> with picks at 8000.
> >I'm not too sure if I understand the exact meaning of
> this counter. Can
> >someone explain it to me and tell me if the values I'm
> getting are bad or
> >normal?
> >
> >Thank you
> >
> >
> >.
> >