Establishing Linked Server to SQL Server using MSOLEDB Driver
Linked servers enable the SQL Server Database Engine to read data from remote data sources and execute commands against remote database servers. This particular blog will discuss how to leverage the new MSOLEDB driver to establish linked server with SQL Server.AlwaysOn Availability Groups: Wait Type HADR_DATABASE_WAIT_FOR_TRANSITION_TO_VERSIONING
First published on MSDN on Jul 13, 2018 Recently a customer reported an interesting issue, while querying against recently added readable replica, SELECT statement is shown as suspended and session is shown as waiting on HADR_DATABASE_WAIT_FOR_TRANSITION_TO_VERSIONINGHere is a simple way to reproduce the scenarioNow on current primary replica, change one of the remote replica to readableHowever, running a SELECT Statement against newly available readable replica, query appeared to be "suspended" Upon more investigation, it appeared to be waiting on with a wait type HADR_DATABASE_WAIT_FOR_TRANSITION_TO_VERSIONINGThe behavior is by design as mention in the SQL Server product documentation and applicable to all version of SQL Server that supports availability group.
