Very Large Database Split it or what?

  • SQL 2000 on W2K3

    I've got a 200GB database 1 file 1 log. When the DB has to grow it causes the application to wait which causes the 250 robots that are making jeeps to stop. I've tried spliting out the largest table 100GB to it's own file group but the process takes to long to run need to complete the maintenance over a weekend. So I'm wondering if I've got any other options.

    I'm already archiving 2 times a year.

  • Are you letting it grow by itself with autogrow? If it is causing performance issues you are probably better off growing the database yourself during authorized down-time when there is little-to-no usage.

    Joie Andrew
    "Since 1982"

  • Are you letting it grow by itself with autogrow? If it is causing performance issues you are probably better off growing the database yourself during authorized down-time when there is little-to-no usage.

    Joie Andrew
    "Since 1982"

  • Database is growing automaticly. Your right however through archiving and not shrinking I've almost got the growth eliminated. Had 1 growth in last 6 months.

  • You ought to grow it every 3-4 months, calculating what you'll need beyond that.

    In terms of maintenance, you likely need to do it during off hours. You could archive off some of the data if the application allows it during regular hours.

  • HI Steve,

    There are many links which does not open. Even this too.

    Is this something like blocked by Admin team in SSC or some issue with webpage?

    http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/62497/

    Thanks and have a good day

    Thanks.

  • mark.hall (2/23/2010)


    SQL 2000 on W2K3

    I've got a 200GB database 1 file 1 log. When the DB has to grow it causes the application to wait which causes the 250 robots that are making jeeps to stop. I've tried spliting out the largest table 100GB to it's own file group but the process takes to long to run need to complete the maintenance over a weekend. So I'm wondering if I've got any other options.

    I'm already archiving 2 times a year.

    You have a ton of data. Is there no way for you to determine how much growth you would need each week or month and pre-grow the database during the maintenance period so it wouldn't have to grow during production time?

    Also, you might want to convince Chrysler that it's bloody 'bout time to upgrade both the hardware and the software for their robots so you can take advantage of things like "instant file initialization" and some other features. I guarantee that the whole shebang will cost less the occasional outage on the production line especially when the normal rate is 60+ Jeeps per hour.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 7 posts - 1 through 6 (of 6 total)

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