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 |
|
tanvirasad
Starting Member
10 Posts |
 Posted - 2006-11-03 : 04:49:31
|
| My database is size of 7GB and it is fine tuned when my DB reaches to the Max Free space It is not increasing the size of MDF while I have set the option of auto Increament. Let me tell u I have tested both By Percent and By Size still it fails to increase the size automatically. I am am doing it manually to increase the Size and sometime I gives me an Time Out Error While increasing the Size.Tanvir Asad |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-11-03 : 06:48:16
|
| "sometime I gives me an Time Out Error While increasing the Size"Increasing the size of a database is a very heavy duty operation in my experience. When we used to use a 10% size increase setting we frequently got timeouts. We've changed our standard procedure to now use a fixed size for increments.Better still is to avoid them by increasing the database size during quiet hours as it nears capacity.I don't know why it is not increasing automatically - are you getting some sort of error when that happens?Kristen |
 |
|
|
tanvirasad
Starting Member
10 Posts |
Posted - 2006-11-06 : 04:05:01
|
Hi,No It does't give any error while running but it increases the log tremendously. But When I Increase the Size it flashes an Error of Time Out once or twice while increasing ultimately it increases the size.Thanks, quote:
Originally posted by Kristen
"sometime I gives me an Time Out Error While increasing the Size"Increasing the size of a database is a very heavy duty operation in my experience. When we used to use a 10% size increase setting we frequently got timeouts. We've changed our standard procedure to now use a fixed size for increments.Better still is to avoid them by increasing the database size during quiet hours as it nears capacity.I don't know why it is not increasing automatically - are you getting some sort of error when that happens?Kristen
Tanvir Asad |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-11-06 : 07:22:44
|
"tremendously"So in your parlance how much is "tremendously"?  How big are the MDF and LDF files before / after increase?What is the Auto Increment set to? 10% ? or something else?Kristen |
|
|
|
|
|
|
Increase in Transaction Log Size