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 |
|
Hariarul
Posting Yak Master
160 Posts |
 Posted - 2007-12-10 : 03:46:10
|
| Hi all , We had a SQL server (2005) that was performing very bad . We thought of doing an UPDATE STATISTICS thinking that the response times would increase.BUT , UNFORTUNATELY THE SERVER PERFORMANCE BECAME WORSE FROM BAD. Ex : Stored procedures that took 2 minutes are running for 22 minutes now. Queris that ran for 17 seconds are running for 14 minutes now.Anybody faced this kind of issue earlier ? Any help would be appreciated.Thanks & Regards,Hariarul |
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2007-12-10 : 10:50:40
|
| what do the execution plans show? are all your indexes rebuilt/reorganized. This looks to be a classic index error not a statistic error.RegardsParesh MotiwalaBoston, USA |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-10 : 22:10:47
|
| Has blocking on the server? |
|
|
|
|
|
|
Strange issue with UPDATE STATISTICS.