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 |
|
zhangn
Starting Member
29 Posts |
 Posted - 2010-02-05 : 08:55:05
|
| Hi I have created a database with the three files below:GasForecasting.mdfBy 1mb, unrestricted growthGasForecasting_log.ldfBy 1mb, unrestricted growthGasForecasting_ndf.ndfBy 10 percent, restricted growth to 2097152mbI tried to upload 7mb files to the database. The size of log file jumped to 916MB after I finished the uploading. Can anyone explain to me why it is the case?I can not query anything out from the database, it is away to slow. Ning |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-02-06 : 06:24:20
|
| A few things you should try, based on the information provided:GasForecasting.mdf - increase the By 1MB - for example 500 MB , as every time there is a increase there is performance hitGasForecasting_log.ldf - increase the By 1MB - for example 500 MB , as every time there is a increase there is performance hitGasForecasting_ndf.ndf - don't use percentage growth , as this means that as your file gets bigger , the % amount will grow , use MBThe log file growth is normal , as that's where the transactions are logged - but if you size your files apprppriately, this will allow the log file to perform more efficiently.There are many other things you could looks at , such as splitting the data files and log files onto different drives . Jack Vamvas--------------------http://www.ITjobfeed.com |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-06 : 07:00:13
|
| "The log file growth is normal , as that's where the transactions are logged - but if you size your files apprppriately, this will allow the log file to perform more efficiently."Unless the O/P mistyped the figures inserting 7MB of data shouldn't be generating 916 MB log file, don't you think ??(I did wonder if 7GB of data has been inserted and no maintenance done ... which would be slow, no doubt) |
|
|
|
|
|
|
|
|
question for log files