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 |
|
helpme
Posting Yak Master
141 Posts |
 Posted - 2009-07-02 : 13:04:52
|
| We have a job that sometimes runs in a few minutes, and sometimes the same job (same volume of data) may run more than an hour. It doesn't appear that there is a lot of other activity during these run times in the database. The statistics are updated daily. Any pointers as to what we might check to help resolve this? |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2009-07-02 : 13:35:21
|
| At a first guess (and with this much information anything is going to be a guess), I bet you are having to retrieve a large portion of the information from disk for some of the runs, instead of having the luxury of having it cached in memory. Have you had a go at tuning the SQL to make the most of any indexes that are there? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-02 : 13:40:01
|
| whats the job doing? is it doing some incremental data processing? if yes, can you analyse amount of data it processes at times when its slow. |
|
|
|
helpme
Posting Yak Master
141 Posts |
Posted - 2009-07-02 : 15:51:05
|
| I've looked over the sql, but haven't seen anything yet. As far as the amount of data, it's the same amount during slow and fast times |
|
|
|
|
|
|
varying run times