February 23, 2010 at 4:35 pm
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.
February 23, 2010 at 5:18 pm
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"
February 23, 2010 at 5:19 pm
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"
February 23, 2010 at 5:46 pm
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.
February 23, 2010 at 6:01 pm
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.
April 30, 2015 at 11:28 am
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.
April 30, 2015 at 3:17 pm
mark.hall (2/23/2010)
SQL 2000 on W2K3I'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
Change is inevitable... Change for the better is not.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply