SQL Server Performance

Parallel Processing

Discussion in 'General Developer Questions' started by amitm79, Jul 25, 2004.

  1. amitm79 New Member

    Hi All,
    I have a script which is working on multiple tables sequentially. All the DML's are mutually exclusive. My machine has multiple CPUs. Can i configure my SQL Server to run them parallely? If yes, how can i do it? What are the pros and cons of doing it in parallel? Any help/link/advice/experience on it is welcome.

    Regards,
    amitm79
  2. Twan New Member

    Hi ya,

    you'd have to break up your script into multiple scripts and run all of them at the same time. A single script or proc will only have a single execution thread (although an individual statement within a script may use multiple CPUs to acomplish that statement)

    Cheers
    Twan
  3. amitm79 New Member

    Hi Twan,
    I have twelve tables to update. Maintaining 12 separate scripts and executing them at the same time can be an overhead. I will see if i can come up with anything better else i will definitely try this out.

    Regards,
    amitm79

Share This Page