Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
loamguy
Starting Member
15 Posts |
 Posted - 2008-02-13 : 09:02:19
|
| I'm at a new installation where there's no DBA at all, so, as a Coldfusion programmer, I'm now the DBA, LOL.The main SQL2000 DB we use is approximately 100MB with about 7MB of free space and is allocated to expand by 10%. I am adding a new, large table, about 60 columns with lots of variable-length unicode fields, mostly nvarchar. It's being used to track non-USA user-form information. Even though the DB is set to expand, I'm concerned that due to the potential size/volume of records, that the auto-expand could cause performance issues.The SQL2000 server has plenty of room, about 49GB, so I'm wondering if I should expand the size of the current DB, or if the auto-expand feature will be ok.At this point I'm not sure what the volume of the user-form records will be in the new table. It won't be a million records certainly, but I'm guessing it could climb to maybe 10-20,000 records.If I should expand the DB, can I do this while the DB is still online?thanks... |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-02-13 : 11:04:13
|
| As you've suggested , you could just expand the database size , and that way get around the auto - grow problem, which normally is more of an issue with OLTP.When you expand the extra space becomes automatically available.Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
 |
|
|
loamguy
Starting Member
15 Posts |
Posted - 2008-02-13 : 11:08:53
|
quote:
Originally posted by jackv
As you've suggested , you could just expand the database size , and that way get around the auto - grow problem, which normally is more of an issue with OLTP.When you expand the extra space becomes automatically available.Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com
Ok, thanks a lot. Can I expand the DB size during business-hours without adversely impacting response time? |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-02-13 : 11:46:31
|
| Yes , normally it's OK. Ideal to do it during a quiet time.One thing I noticed , you've got your auto grow setting on 10% , you could look at setting the growth rate to MBJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
loamguy
Starting Member
15 Posts |
Posted - 2008-02-13 : 11:54:29
|
quote:
Originally posted by jackv
Yes , normally it's OK. Ideal to do it during a quiet time.One thing I noticed , you've got your auto grow setting on 10% , you could look at setting the growth rate to MBJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com
Ok, thanks for the info! |
|
|
|
|
|
|
|
|
Database Expansion Advice