Tag Archives: alwayson

T-SQL to find High availability configuration of all databases in MSSQL Server

 TSQL to find list of all databases in MSSQL Server with Always-ON and mirroring configuration. #mssql#tsql #AlwaysOn #Mirroring #FailoverMode #HighAvailability Advertisements

Posted in Productivity, SQL, SQL Query, SQL Server, Uncategorized | Tagged , , , , | Leave a comment

SQL Alwayson Preferred Node workaround, Fallback script

We have Always-On configured between Node-1, Node-2 with Auto Failover enabled. Unfortunately one minor functionality was partially impacted when AG is primary on Node-2. Business is very particular about not changing it to Manual Failover mode. End up creating a … Continue reading

Posted in Script, SQL, SQL Query, Uncategorized | Tagged , , , , | 1 Comment

Most common challenges and solution with Availability group listener and multisubnetfailover

Industry started using SQL availability groups on most of their environments, DBA is coming across multiple issues related to AGListener connectivity. This blog explains 2 major challenges and solutions in detail: https://blogs.msdn.microsoft.com/alwaysonpro/2014/06/03/connection-timeouts-in-multi-subnet-availability-group/ I recommend option-1 to enable client to use … Continue reading

Posted in Learn_Powershell, SQL, SQL Server, Uncategorized | Tagged , , , , , | Leave a comment

AlwaysOn Availability Groups notes

AlwaysOn can broadly categorized into 2 (AlwaysOn Failover Cluster Instances, and AlwaysOn Availability Groups). I will capture Availability group highlights… AlwaysOn Failover Cluster Instances: failover cluster instance (FCI) is a single instance of SQL Server that is installed across Windows … Continue reading

Posted in High Availability, SQL Server | Tagged , , | Leave a comment

Knowledge Share 2014-04

In SQL Server 2014, you can have 8 secondary replicas, it was 4 in SQL 2012 Ref: What’s New (DB Engine) SQL Server 2014 – http://msdn.microsoft.com/en-us/library/bb510411%28v=sql.120%29.aspx#DataFiles What is Cardinality Estimation? This is new feature in SQL Server 2014: The cardinality … Continue reading

Posted in knowledge, Productivity, SQL, sql2014 | Tagged , , , , , , , | Leave a comment