SQL Server : How to Enable Intra Query Parallelism

Posted By Sagar Patil

Right click on “server name” and select “properties”

If you have BATCH processing environment , try increasing MAX degree of Parallism to enhance query performance.

SQL server will use Parallism for any SQL whose cost is more than 5

Leave a Reply

You must be logged in to post a comment.

Top of Page

Top menu