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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-07-14 : 07:00:31
|
| David writes "Thanks in advance for any help...I have a 3rd party application. It is based on .NET and SQL 2000. It is running on a clustered pair of Dell 6650 servers attached to an EMC SAN. Lots of horsepower.However, the performance goes into the tank a couple of times per week. We see queries begin to take much longer and timeout. The CPU on the server spikes to 100%.We have learned that we can temporarily recover from this issue by running sp_updatestats. This process takes several minutes to run, but immediately upon completion the CPU drops back to more normal levels and performance returns to normal.We already have jobs scheduled daily that perform reindex and update stats. Yet for some reason, the statistics get out of whack and we have to run the sp_updatestats to recover.We are running SQL 2000 SP3. Thank you,David LipscombDirector, InfrastructureRTM Restaurant Groupdlipscomb@rtminc.com" |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-07-14 : 12:46:58
|
| what is your question? |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2005-07-14 : 13:18:43
|
| I think he's asking1. Why do the stats get out of wack so often2. How do we repair stats periodically throughout the day.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-07-14 : 14:30:56
|
| Is auto update statistics enabled?-ec |
|
|
|
|
|
|
sp_update stats needed frequently