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 |
|
dowens
Yak Posting Veteran
82 Posts |
 Posted - 2008-07-17 : 13:08:20
|
| .. what is causing the slow down?Datawarehouse incremental updatesI have a dts package task that runs at 1:00am every morning.The package task loads data into a db and typically takes 2.5 hours total.However on three separate occasions it has taken more than 5 hours. At 6:00am I do a stop/start to clear server logs, which kills the process above that is still running. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-17 : 13:22:17
|
| Any locking/blocking at that time? Catch with profiler what exactly causes it? |
 |
|
|
dowens
Yak Posting Veteran
82 Posts |
Posted - 2008-07-17 : 13:36:13
|
| I put nolock on all my updates.Not sure what you mean by:Catch with profiler what exactly causes it? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-17 : 15:27:07
|
| Schedule profiler to run in that time and also add lock/block in the script which you can find ID in Books online. After that you can analyze tomorrow morning what was the real issue.See my posts:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=105302 |
|
|
|
dowens
Yak Posting Veteran
82 Posts |
Posted - 2008-07-17 : 15:47:56
|
| Thanks so much...I'll give it a try. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-17 : 22:56:20
|
| >> I put nolock on all my updates.Nolock does not apply to INSERT, UPDATE, and DELETE statements.Did you check amount of data loaded on those days? Should also watch cpu and disk usage on the server. Check parallelism, parallel process can slow down data loading sometime. |
|
|
|
|
|
|
How can I determine...