Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- declare @object_name as varchar(500)
- select @object_name= object_name FROM sys.dm_os_performance_counters
- WHERE counter_name = 'Transactions/sec'
- AND instance_name = 'master'
- DECLARE @cntr_value bigint
- SELECT @cntr_value = cntr_value
- FROM sys.dm_os_performance_counters
- WHERE counter_name = 'Transactions/sec'
- AND object_name = @object_name
- AND instance_name = 'master'
- WAITFOR DELAY '00:00:01'
- SELECT cntr_value - @cntr_value
- FROM sys.dm_os_performance_counters
- WHERE counter_name = 'Transactions/sec'
- AND object_name = @object_name
- AND instance_name = 'master'
Add Comment
Please, Sign In to add comment