March 4, 2003 at 8:08 am
What are the general rule of thumb when setting the space allocation for the new DB? I'm a bit new to the DB world, and would like to get some feedback.
thanks...
March 4, 2003 at 9:40 am
There is not a general rule for almost anything in db world, and space allocation is not an exception.
Anyone call tell that correctly. You should know what are you going to use your db for, how many connections, transactions , data modifications, etc.
If your db is not big, to avoid problems or administering time, you can let the default size and then let autogrowth. But not for a production server.
March 4, 2003 at 1:28 pm
I know Im in the minority again, but I do use autogrow on production servers. If you've only got one db you can check it once a week, go to a couple hundred - gets to be a little more tiresome. As long as the growth amount is reasonable (as a percentage of disk size, mine typically grow 50-100mb at a time) I don't see a problem.
The "danger" of course is that the db can potentially expand to fill the drive. I keep a 1g placeholder file (an old bak works well) on the data drive so if it should happen, I can delete the file while I straighten things out.
As for how big - I have to agree there aint much in the way of general rules. I rebuild indexes once a week, so I want to have enough space on Monday so that I can go the week without adding space. Not a big deal if I do, but the goal is smooth running and thats one less thing going on during production hours.
Andy
March 4, 2003 at 2:43 pm
I am new to SQLServer and am interested in this topic. Anyone have any experience or know of studies done on the performance price paid by having autogrow on in a production database?
Also, this may be not be a smart question, but I don't see a place where you turn "autogrow" on at the database level. Is "autogrow" really at the file level, based on whether or not you specify a MAXSIZE?
Thanks!
Robin
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply