Átlagos tranzakció végrehajtási ideje:
1 2 3 |
select wait_type, waiting_tasks_count, wait_time_ms, wait_time_ms/waiting_tasks_count as 'time_per_wait' from sys.dm_os_wait_stats where waiting_tasks_count >0 and wait_type = 'HADR_SYNC_COMMIT' |
SQL szerver válasz ideje ms-ban:
wait_type | waiting_tasks_count | wait_time_ms | time_per_wait |
HADR_SYNC_COMMIT | 10809645 | 135666120 | 12 |