• Andrew Kernodle (2/21/2014)


    Personally, I'm working with 2,659 databases, which add up to about 700GB of data altogether.

    And yes, this is a horrible, horrible design by a vendor :-D. Really, all of these databases could just be tables in a single database (they're even set up to be as such!), but it works. Mostly. Sometimes. If you shake the server once a week or so.

    I'm sitting in a somewhat smaller but wider boat on that case,not that many databases,but a lot of databases that are literal datacopy of a 'master' database (not to be confused with the master sys database) just to allow different departments to do the different things on the same data. Also about 10 different production instances divided over 3 different physical machines.

    The EvE Online database is quit complex in structure and was reported to use some 34 GB of ram to run (2011)