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 |
|
cidmi.dovic
Yak Posting Veteran
53 Posts |
 Posted - 2007-12-03 : 11:32:37
|
| I'm wondering If it's good to activate the auto shrink option on a database. Does it improve performance?I also need an opinion about regenerate indexes and making it on a scheduled task.Thank you.The Padrón peppers itch and other no |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-12-03 : 11:37:12
|
| In fact, its other way round. If you set Auto Shrink option on, you are bound to get performance hit since file shrinking is CPU intensive operation and takes long time for large DB files. So unless you have very limited disk space (a very rare issue on production system), you have no good reason to turn this on.By regenerating indexes, do you mean rebuilding indexes using DBCC REINDEX?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
cidmi.dovic
Yak Posting Veteran
53 Posts |
Posted - 2007-12-03 : 11:39:13
|
quote:
Originally posted by harsh_athalye
In fact, its other way round. If you set Auto Shrink option on, you are bound to get performance hit since file shrinking is CPU intensive operation and takes long time for large DB files. So unless you have very limited disk space (a very rare issue on production system), you have no good reason to turn this on.By regenerating indexes, do you mean rebuilding indexes using DBCC REINDEX?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED"
Yes, I want to use DBCC REINDEXThe Padrón peppers itch and other no |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
|
|
|
|
|
auto shrink