Post reply

Best way to configure jobs on AlwaysON

  • September 25, 2013 at 11:34 am

    #298287

    Hi,

    We are planning to configure AlwaysON with 3 servers. Two in the same datacenter with synchronous commit and automatic failover and the third one in a different datacenter as a DR with asynchronous commit. Now what is the best way to configure the SQL jobs like Reindexing, DBCC Checkdb, Update Statistics and other application related jobs. The reindexing, update statistics and Checkdb should only be run on the Primary and should we keep them enabled on the secondary also.

  • October 11, 2013 at 3:22 am

    #1657834

    Please share what is the best approach for this.

  • October 11, 2013 at 3:35 am

    #1657836

    Index and statistics maintenance should only run on the primary. We have our maintenance jobs running on primary and secondaries but we exclude read only databases.

    SELECT

    *

    FROM

    sys.databases

    WHERE

    DATABASEPROPERTYEX(name, 'Updateability') = 'READ_WRITE'

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]

  • October 11, 2013 at 7:11 am

    #1657896

    I am not yet using SQL 2012 but have been looking at this. From what I have discovered so far I understand that you can only write to the Primary node so re-index etc need to be run on the primary node. Secondary replicas are read only so can be used for backups and the bulk of DBCC jobs but re-index jobs would not work here.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply