We have two AlwaysOn nodes in sync commit.
Occasionally select queries are waiting on
What is the underlying process that causes it?
Allow Snapshot Isolationand
Is Read Committed Snapshot Onare set to
True. But snapshot isolation is not being used because client is enforcing READ COMMITTED.
Query example from primary replica:
select * from dbo.photoFileMetaData where [email protected]