commit time – Run SQL Server BLOG

Átlagos tranzakció végrehajtási ideje:

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'

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

Tag: commit time

AOAG Synchron Commit time