LiteSpeed 8.5 performance got slower due to always on addition. (4234061)

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'

Call replica script will need a rewrite.

LS-384 has been created to address this.

WORKAROUND

None

Status: