SQL Server -Contadores de desempenho

select distinct counter_name from sys.dm_os_performance_counters order by counter_name

Select * from sys.dm_os_performance_counters
where counter_name = 'Lock Timeouts/sec'   --and instance_name = 'Extent'

select * from sys.dm_os_performance_counters
where counter_name in ('Target Server Memory (KB)', 'Total Server Memory (KB)', 'Batch Requests/sec')

SELECT request_session_id, COUNT (*) num_locks
FROM sys.dm_tran_locks
GROUP BY request_session_id
ORDER BY count (*) DESC

SELECT * FROM sys.configurations
GO

fonte: Simple SQL Server

Licença CC BY-SA 4.0 Silvia Pinhão Lopes, 11.6.18