May 16, 2010 at 9:32 am
I have an SQL package which has 3 tasks, task1, task2, task3. After task1 completes task2 and task3 starts simultaneously.
task2 and task3 are running simultaneously, and both these tasks execute different stored procedures. These 2 SP will work on same set of tables to extract data.
My question is if these two tasks are running simultaneously, will there be any IO contention? Does one process need to wait till the other completes the IO on certain tables? will there be any performance issue because of this?
May 16, 2010 at 10:49 am
Given the information provided there is no way to tell. There are a lot of factors. The sprocs operate on the same tables, how big are the tables? How much memory? Is your disk subsystem fast enough?
Short answer, it depends.. Sorry I can't give you any more than that at this point..
CEWII
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply