Post reply

How many maximum number of databases are recomended to add in AlwaysON Availability Group SQL Server 2012

  • July 29, 2015 at 2:48 pm

    #302955

    Hi,

    Can anybody please tell me that how many databases are recomended to add in one AG in SQL Server 2012 AlwaysON to get better performance. I heard that you can add as many as you want but I believe there will be some performance issue if you add as many as you want.

    Thanks

    Imran

  • July 30, 2015 at 10:08 am

    #1816212

    Imran-Yasir (7/29/2015)

    Hi,

    Can anybody please tell me that how many databases are recomended to add in one AG in SQL Server 2012 AlwaysON to get better performance. I heard that you can add as many as you want but I believe there will be some performance issue if you add as many as you want.

    Thanks

    Imran

    You CANNOT add as many databases as you want in Always On setups. You can starve your server of available threads that way. There was a very good recent post on that. There are MANY other caveats, provisos, limitations, GOTCHAs, etc. with AGs. Please do NOT just read a few forum posts or other things and try to slap them into production.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

Viewing 2 posts - 1 through 1 (of 1 total)

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