• dexdev (4/28/2014)


    We are looking into setting up a cluster, but we are getting mixes opinions on whether to convert all our individual databases (about 5000) to one big individual database, or keeping our current setup.

    very mixed and confused i would have said, even if you cluster them you'll still have lots of small databases, they don't automatically become one database!

    dexdev (4/28/2014)


    Some say that it would be easier to manage one large database, and ensure high availability, while some say that managing a huge number of small databases would not be an issue. Any thoughts on this ?

    We also want to make sure that should we scale and grow, and we get to 50000 databases, clustering etc. will still never cause issues.

    Any thoughts?

    Thanks

    It's obviously easier to manage a single instance even when clustered than it is to manage multiple instances. You need to distinguish the difference between an instance of SQL Server and a SQL Server database, don't get them confused with Oracle terminology\topology.

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

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