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 |
|
ahmeds08
Aged Yak Warrior
737 Posts |
 Posted - 2013-05-07 : 10:30:47
|
| Dear Experts,Need you advise.One of my database has auto growth by 1 MB.so my doubt is,Will frequent file growths result in CPU bottleneck.If I had to change the auto growth setting what value should I go with.Thanks,Javeed.mohammad.javeed.ahmed@gmail.com |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-05-07 : 10:36:36
|
| Take a look at Kimberly Tripp's article here: http://www.sqlskills.com/blogs/kimberly/transaction-log-vlfs-too-many-or-too-few/You don't want to have too many VLF's (which will slow down performance) and you don't want to have VLF's that are too big (because a VLF can be cleared only if none of the log records in it are needed). That article, and the links from there give you lot of useful advice. |
 |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2013-05-07 : 11:49:02
|
| Thanks James.mohammad.javeed.ahmed@gmail.com |
|
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-05-07 : 12:18:58
|
| You are very welcome - glad to help.By the way, all of that info is about log files. For data files, you should estimate the space it will need and simply allocate the space in advance, so it won't have to autogrow. |
|
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2013-05-07 : 12:27:05
|
| Yes,Iam monitoring the database growth for that.That should help me in setting a auto grow value.mohammad.javeed.ahmed@gmail.com |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2013-05-08 : 01:02:41
|
| Thanks for sharing,Tara.mohammad.javeed.ahmed@gmail.com |
|
|
|
|
|
|
Frequent file auto growth