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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-07-22 : 05:14:16
|
| Dear All,please let mek know how to check autogrow is enabled or not....ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-07-22 : 05:23:20
|
Check out Books Online, please.select * from sys.database_files
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-07-22 : 05:25:39
|
Auto grow, auto shrink... Who keeps track of them?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-07-22 : 05:31:02
|
| KH, it is not there in the link.peso, i'm checking for all the options which ever makes the database good. i'm asking your advices to set the settings of my production databasesArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-07-22 : 05:38:36
|
oh . . i read it as auto shrink.  Yeah . . auto grow, auto shrink . . who keep track of them 
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-22 : 09:46:03
|
| One thing:If your database is big, make sure you put your data files to grow in MB not in percentage . We put 512 MB. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-07-22 : 11:36:24
|
| And monitor the free space so tha you can grow the files manually during a quiet time. If autogrow kicks in during peak usage, you're going to have a nice slowdown on your hands.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
|
|
auto grow option check