Comments
Sort by recent activity
Adding the ApplicationIntent=ReadOnly parameter to your connection string in SSMS ensures that the connection is directed to a read-only replica of the database. This can help offload read-heavy queries to secondary replicas, improving performance and reducing the load on the primary database instance. / comments
Adding the ApplicationIntent=ReadOnly parameter to your connection string in SSMS ensures that the connection is directed to a read-only replica of the database. This can help offload read-heavy qu...