Allways On database limitations.

  • Hi, There looking into using SQL Always On. Are there any limits to the number of databases in an availability group? Has anyone have any experiences (good or bad) of using always On for 300+ databases.

    Thanks in advance.

  • This from Microsoft themselves 😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Perry, thanks for the reply. I saw the same doc. It says MS has tested with 100 DB's which I assume are in a lab. I was after any real world experience. Is 300 dbs like to cause threading issues? Has anyone else encountered problems with high numbers of dbs with Allways On from a management viewpoint?

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

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