Post reply

Looking How to achieve SESSION ENABLE \ Disable PARALLEL in sql server

  • February 27, 2019 at 8:08 am

    #382822

    "EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';” “EXECUTE IMMEDIATE 'ALTER SESSION DISABLE PARALLEL DML" statements  is used in oracle so how can we achieve in sql server     

  • February 27, 2019 at 2:35 pm

    #2023137

    pawan.mantha - Wednesday, February 27, 2019 8:08 AM

    "EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';†“EXECUTE IMMEDIATE 'ALTER SESSION DISABLE PARALLEL DML" statements  is used in oracle so how can we achieve in sql server     

    I think this is one of the areas where the engines in Oracle and SQL Server are so different that you wouldn't look at trying to use the same thing in SQL Server.
    Parallelism is done differently in SQL Server and based on different components so it's likely better to just understand how SQL Server's work and go from there. There is a section called Parallel Query Processing in the following documentation which is a good start:
    Query Processing Architecture Guide

    Sue

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply