2. SQL Server Transaction Counter

2. SQL Server Transaction Counter

For SQL Server the connection parameters are the same as the schema options. The refresh rate determines the sampling interval.

Figure 6.3. SQL Server TX Counter Options

SQL Server TX Counter Options

The following SQL is used to sample the transaction rate displaying the same value as can be seen in the Activity Monitor in SSMS.

select cntr_value from sys.dm_os_performance_counters where counter_name = 'Batch Requests/sec'