Sunday, December 04, 2005

SQL Server Locking detail from Sysperfinfo

--select getdate()
go
select getdate(),counter_name,instance_name,cntr_value from sysperfinfo
where object_name ='SQLServer:Locks'
and counter_name in ('Average Wait Time (ms)','Lock Wait Time (ms)','Lock Waits/sec' )
and instance_name = '_Total'
WAITFOR DELAY '0:01:00'
---select getdate()
select getdate(), counter_name,instance_name,cntr_value from sysperfinfo
where object_name ='SQLServer:Locks'
and counter_name in ('Average Wait Time (ms)','Lock Wait Time (ms)','Lock Waits/sec' )
and instance_name ='_Total'