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 - 2012-10-08 : 06:39:45
|
| Dear Experts,Setting the Auto update Statistics option to 'True' is it profitable.Or running it manually based on the requirement is good?Thanks. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-10-08 : 07:18:31
|
| The only cases I know of where it's better to turn it off are very large tables that are frequently changed and need to sustain maximum performance. In those instances the performance hit of an auto stats update is enough to be detrimental.It rarely hurts to have a scheduled manual statistics update. I recommend Ola Hallengren's maintenance script: http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html . It has numerous settings to control which stats are updated or not, as well as index maintenance. |
 |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2012-10-08 : 07:43:02
|
| Thanks Rob,mine is a data warehouse system,so setting it TRUE will be good? |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-10-08 : 09:46:34
|
| I'd leave it on. You can trace auto stats events and log them for future reference, if you see performance issues that occur during those times you can look at disabling it. |
|
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2012-10-12 : 03:52:42
|
| Definitely leave it on |
|
|
|
|
|
|
Auto Update Statistics Option