Following query in Litespeed 8.5 causing slower backup performance.
SELECT db.name as [ReplicaDBName], ag.name as [ReplicaGroup], cast(ars.[role] as int) as [ReplicaRole] FROM master.sys.availability_groups ag inner join master.sys.availability_replicas ar on ar.group_id = ag.group_id inner join master.sys.dm_hadr_availability_replica_states ars on ars.replica_id = ar.replica_id inner join sys.databases db on db.replica_id = ars.replica_id WHERE db.name = 'test'
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center