SQL and ML Spaces

We have specific setting in SQL Server using which we can specify the use of CPUs. Default configuration is to use all the available CPUs and queries are executed in parallel. But the requirements vary depending on OLTP or OLAP systems.

MAXDOP : Maximum degree of Parallelism.

The values of all SQL Server related configuration properties can be seen from the query

[cc lang=”SQL”]

select * from sys.configurations

— How to use MAXDOP?

SELECT * from dbo.Authors
OPTION (MAXDOP 1)

[/cc]

A good amount of testing is needed after the configuration changes.