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 |
|
sqldba20
Posting Yak Master
183 Posts |
 Posted - 2008-02-28 : 17:00:43
|
| I have the Auto Update Statistics 'ON' on my database. How would I find on which table the statistics were updated? Is there any kind of table or flag to track it? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-28 : 17:32:54
|
| Don't turn it 'ON' on production.It will run in production hours and degrade performance.You can use profiler to capture and enable trace flags to log the activity. |
 |
|
|
sqldba20
Posting Yak Master
183 Posts |
Posted - 2008-02-28 : 17:48:32
|
| Well we have it on and we didn't had any performance issues so far but what I want to know is whether it is tracked in some table or errorlog which table it did statistics Thanks ! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-02-28 : 18:20:01
|
quote:
Originally posted by sodeep
Don't turn it 'ON' on production.It will run in production hours and degrade performance.You can use profiler to capture and enable trace flags to log the activity.
Actually it is recommended to have it on unless you have found performance issues. You should also have a manual job to update the stats on a scheduled basis. We manually update stats nightly.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
UPdate Stats