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.

  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)

  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.


Share This Page