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 |
|
icw
Constraint Violating Yak Guru
378 Posts |
 Posted - 2007-08-03 : 05:46:28
|
| HiI've got a largeish database.Auto create and auto update statistics were both turned off until today.I have just turned them on because of people experiencing locks, freezes on the database. How long till it starts doing it's thing?thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-03 : 11:35:58
|
| Turned them on caused db frozen or vies versa? Sql should do those at idle time. |
 |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-08-03 : 11:42:03
|
| Depending on when was the last time the tables were reindexed it will take its time. Also just turning them on will not make SQL server start updating all the indexes. There is an algorithm that decides when to update the stats and its based on number of changes to the table.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
marbos
Starting Member
7 Posts |
Posted - 2007-08-16 : 16:34:29
|
| Please also understand that Update Statistics on your database will not resolve contention issues such as blocking. |
|
|
|
ashley.sql
Constraint Violating Yak Guru
299 Posts |
Posted - 2007-08-16 : 16:44:04
|
| yes thats so trueAshley Rhodes |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-08-20 : 12:38:46
|
quote:
Originally posted by marbos
Please also understand that Update Statistics on your database will not resolve contention issues such as blocking.
But it should help though in theory, at least to some degree in expediting performance which should lower the chance of contention right? |
|
|
|
|
|
|
How long till Auto Create Statistics has effect