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 |
|
aelazouzi
Starting Member
7 Posts |
 Posted - 2005-09-23 : 09:31:08
|
| Hi All,I have the following situation on a SQL 2000 server.The following are some database config settings.Data files:Space allocated (148858MB)File properties:+Automatically grow file: is OnFile growthIn Megabyte: 1MB is on+Maximum file sizeunrestricted file growth is also onThe same settings are applicable for the Transaction logThe Space allocated for Transaction Log is(535MB)Do this settings have a performance effect on the server?How can I better configure them?what are the best values to set on.(in megabytes or in percentages)Thanks for your help |
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2005-09-23 : 10:26:59
|
| Set up limits on the file growth for all DBs, I've got to a situation where my server went down because of settings just like yours.Igor. |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2005-09-23 : 11:52:28
|
| > Space allocated (148858MB) Do you really need that much of space?>+Automatically grow file: is On>File growth>In Megabyte: 1MB is onThis parameter is not correct. 1 MB is very less. Find out the DB growth and give appropriate setting. 1MB will cause fragmentation.------------------------I think, therefore I am - Rene Descartes |
|
|
|
|
|
|
Database configuration Settings