In simple terms, SQL Server middleware—such as OLE DB or .NET providers
and ODBC and Java Database Connectivity (JDBC) database access drivers—provides
a connection between an application and a database.The SQL Server middleware
processes application requests and presents them to a back-end database in a
language, structure, or syntax that conforms to the requirements of the database
server, then returns the data to the application.
When compared to AlwaysOn Failover Cluster Instances or clustered deployments of SQL Server, one of the main problems with AlwaysOn AGs is that a single database is made to straddle multiple hosts....More