• CDA (8/18/2014)


    What are the current limitations / gotchas around CMS?

    Back in 2008, there was some guidance from Microsoft that CMS shouldn't group > 200 servers together. Does anyone know if this has increased in 2k12 or 2k14?

    Having said this, I'm suddenly unable to find any supporting documentation of this limitation - looking deeper.

    I'm not personally aware of any limitations. We currently have 800+ instances across the various groups that I have defined. I regularly open up new queries against 350-400 at a time. Aside from a few that don't successfully connect, it has been pretty stable for me.

    I'm also using SQL 2012 Enterprise for my CMS server, if that matters.