mvalipour/sql-set-max-dop.sql

Created April 2, 2016 16:23

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/mvalipour/33b62d2f53eadc6aa614748ce59b9002.js"></script>
Save mvalipour/33b62d2f53eadc6aa614748ce59b9002 to your computer and use it in GitHub Desktop.

Download ZIP

Set Maximum Degree of Parallelizm (number of CPUs) on an Azure Premium SQL Database

Raw

sql-set-max-dop.sql

ALTER DATABASE SCOPED CONFIGURATION SET MAXDOP =2

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment