April 5, 2010 at 5:02 am
Hello All,
I want to run 4 procedures in parallel in SQL Server. For this, I have created SSIS package and made to run these 4 procedures in parallel. But I am unknown that these 4 procedures will be run in single CPU or will be run in 4 different CPUs. I am working in a huge database which takes lots of time in execution. So, I want it to use maximum CPU and execute fast. For this, I want these 4 procedures to run in different CPUs. Can you give me idea, how is CPU used by the SSIS package and can we make these different procedures to run in different CPUs???
I am very much in need of your help. Please help me to find out the solution.
Thanks in advance.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy