Friday, 17 February 2017

How to set Read routing list in Always on - SQL server 2012

ALTER AVAILABILITY GROUP [AG-NAME]
MODIFY REPLICA ON
N'SERVER1' WITH
(PRIMARY_ROLE (READ_ONLY_ROUTING_LIST=('SERVER3','SERVER2','SERVER4','SERVER5'))); 

No comments:

Post a Comment

CPU queries in SQL server

-- Database Wise CPU Utilization report -- CPU_Time(Ms): CPU Time in Milliseconds -- CPUPercent: Let’s say this instance is using 50% CP...