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-09-23 : 07:27:13
|
| Kirsty writes "We are using SQL Server 2000. It is a live server which has to have certain Job running batch updates during the morning. The batch update job runs for about 1 hour. The next day 2. The next 3 etc., and peaks at about 5 1/2 hours at which point it runs daily for about 5 1/2 hours. To reduce the time our DBA's have tried to test it on other servers, ran in through the night, stopped other jobs etc., The main question is - could it be a memory leak to cause something to continously get longer in the time it runs?Any ideas?To get the time back to an hour the DBAs now reboot the server which is not acceptable. At which point it goes back to an hour! Strange." |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2005-09-23 : 11:57:17
|
| What does the job do? Can we have the content of job.------------------------I think, therefore I am - Rene Descartes |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-09-23 : 14:10:56
|
| Yup, could be anything really, I'd/we'd need to see the SQL for the JOB to make some suggestionsKristen |
|
|
|
rheitzman
Starting Member
16 Posts |
Posted - 2005-09-23 : 15:28:09
|
| If the batch job is updating/appending to tables consider dropping the target table's keys then re-add them after the batch completes. |
|
|
|
Kirsty Marcuzzo
Starting Member
1 Post |
Posted - 2005-09-26 : 06:00:43
|
| The SQl Job basically runs a table update from one server to another. It runs a view which is based on many other views which rolls up our data. This will probably take some time to run. It then inserts this information into new table. It runs some checks then replaces this table on any server ready for online systems. The job is large and deals with revamping the data. The views that are called run a lot of rollup functions and other views. |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-09-26 : 08:55:16
|
Post the Execution plan....any SCANS/CURSORS will be the suspects to hunt down and eliminate....(DOOM style ) |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-09-26 : 14:16:21
|
| Do you have processes in place that regularly Update Statistics, Rebuild Indexes and Recompile SProcs that would be effected by such changes to the skew of the data?Kristen |
|
|
|
|
|
|
SQL Job is now taking 5 hours!