May 27, 2009 at 2:06 pm
Hi, I have a job taht execute a package.
This package do:
1. SERVER A: Select to various tables. There are two tables have 5.100.000 rows.
Other tables have few rows. Average 20.
2. SERVER B: Insert to a table according to select in the last point.
The execution time is one hour.
Is it time normal?
Can I configure something for time is less?
Thanks...
May 28, 2009 at 8:03 am
Since the process is running between 2 different servers, I suggest that you run Activity Monitor while your process runs and see if you are getting IO or packet waits. I run into the latter from time to time in my environment, as the process is waiting on the network between servers.
Is your run timing based on execution in BIDS or dtexec? I've found that the former always adds overhead. Also make sure to check the the usual suspects: that your queries themselves are optimized, indexes on the select table are utilized, etc.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply