Post reply

40,000 Database Nightmare

  • February 6, 2012 at 8:08 am

    #1443172

    Note this is an 8 year old thread. :w00t:

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • February 7, 2012 at 4:24 pm

    #1444220

    yes, 8yo, but still an incredible read. Wonder what ever happened to the poor guy.

  • February 8, 2012 at 7:34 am

    #1444512

    For those who wonder what happened to me. We lived with the nightmare for years. Backing up, restoring, application updates, etc. were all major problems.

    Finally after years of complaining to the vendor they finally upgraded the system to use just a few databases. Much faster and simpler to maintain.

    I hope no one has to mess with something like this ever again.

    Thanks

    Tom

  • February 8, 2012 at 8:11 am

    #1444546

    tototom (2/8/2012)

    For those who wonder what happened to me. We lived with the nightmare for years. Backing up, restoring, application updates, etc. were all major problems.

    Finally after years of complaining to the vendor they finally upgraded the system to use just a few databases. Much faster and simpler to maintain.

    I hope no one has to mess with something like this ever again.

    Thanks

    Tom

    You came back on SQL Server Central after 8 years !!! ? Wow!

    & your points/visits ration is awesome :w00t:

    Sujeet Singh

  • February 9, 2012 at 8:09 am

    #1445098

    it was funny to read. even if it was originally 2004. not so funny if your in it your self i know.

    i thought our supplier who wanted to make a new database every month ("good for performance") was weird but now i realize there is always someone "better" then you/me 😀

    and let me guess: the list of databases was stored in a flat file so the program knew which one to access ? 😎

  • February 9, 2012 at 8:21 am

    #1445110

    Divine Flame (2/8/2012)

    tototom (2/8/2012)

    For those who wonder what happened to me. We lived with the nightmare for years. Backing up, restoring, application updates, etc. were all major problems.

    Finally after years of complaining to the vendor they finally upgraded the system to use just a few databases. Much faster and simpler to maintain.

    I hope no one has to mess with something like this ever again.

    Thanks

    Tom

    You came back on SQL Server Central after 8 years !!! ? Wow!

    & your points/visits ration is awesome :w00t:

    Ha, before his last post his last login was sometime in 2008. I figured he had moved onto green pastures around then. Sounds like he stuck through it all though.

  • February 9, 2012 at 9:06 am

    #1445137

    This is one of those cases where the vendor should have been shamed by being named.

    10,000 databases for a single product is outrageous now, and even more so in 2004.

    I feel this is an example of the app developers running the show without the benefit of an experienced DB person. I make that statement from MUCH experience seeing such things happen and having to reign them in.

    As a side point a database with absurd numbers of tables is perhaps just as bad, see PeopleSoft, last I saw ~40,000 tables and ~80,000 views..

    I feel for this poor fella, it sounds like he lived it..

    CEWII

  • March 10, 2012 at 12:19 am

    #1457448

    Great just great! 10K Databases :hehe: someone really created that amazing!

    and i was cursing our clients previous service provider for having 40 databases :w00t:

  • March 10, 2012 at 1:00 am

    #1457452

    Hmmm , nightmare is an understatement , but if you cant change the DB Design atleast change the approach. Try to convince your vendor and management to federate the databases , create smaller grouped instance running off sql express if it has to and then sync up with the master database in the back ground.

    Since the application never connnects to the master database you hagve freedom to redesign it the right way.

    It will take care of a few issues that you are facing ,dont dig your self a deeper hole. Call out whats atbstake so that everybody know you tried to warn them.

    Jayanth Kurup[/url]

Viewing 9 posts - 16 through 23 (of 23 total)

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