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 |
|
cwhite
Starting Member
1 Post |
 Posted - 2013-12-12 : 00:26:14
|
| I work with a 260GB vendor supplied database with all of the indexes created. A couple of weeks ago a particular process started taking 5-7 minutes to run that used to run in seconds. It did this for a couple of days and then went back to normal. It's happened a few times since.The stored procedure is 500+ lines and accesses over 25 tables with probably 100-200 indexes.The problem occurred yesterday and I ran a trace on it while it was misbehaving. Things were ok today and I ran another trace.What would cause the same process to act so differently?From Profiler:YesterdayCPU: 386976Reads: 200066610Duration: 427182TodayCPU: 4087Reads: 109362Duration: 4439 |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2013-12-12 : 01:57:45
|
| Different execution plans for same query can act like this. Check if base indexes are being rebuild/reorganized regularly and stored procedure is not a victim of parameter sniffing.--------------------------http://connectsql.blogspot.com/ |
 |
|
|
|
|
|
Wacky Performance General Question