修改最大并行度为1天蓝色的SQL Server [英] Modifying max degree of parallelism to 1 for azure sql server

问题描述

我能够查询并行（MAXDOP）的最大程度的从sys.configurations却无力更新同为一个蓝色的-SQL服务器值。我不是很确定是否有在Azure的SQL sp_configure存储过程的替代品。

I'm able to query "max degree of parallelism(maxdop)" value from sys.configurations but unable update the same for an azure-sql server. I'm not very sure if there is an alternative for sp_configure stored procedure in azure-sql.

SELECT
    name,
    value_in_use
FROM
    sys.configurations(nolock)
WHERE
    description LIKE '%parallelism%'

update  sys.configurations set value_in_use=1 where name='max degree of parallelism'    

我得到一个错误：特设更新系统目录不准我认为这是意料之中的，因为我们应该更新使用sp_configure配置值。

I get an error that: Ad hoc updates to system catalogs are not allowed. I think it's expected since we are supposed to update configuration values using sp_configure.

扔上了天蓝色-SQL服务器级别设置MAXDOP一些轻。我可以在每个SP级别明确设置它，但它会是巨大的，会将此设置为服务器级别本身。

Throw some light on setting maxdop at the server level for azure-sql. I can set this at each sp level explicitly but It would be great to set this at server level itself.

我们如何可以设置SQL-蔚蓝最大并行度不使用sp_configure？指导我在sys.configurations更新值的方法。我没有看到最大并行度任何属性，从蔚蓝的门户也。

How can we set "max degree of parallelism" on sql-azure without using sp_configure? Guide me on ways of updating values in sys.configurations. I do not see any properties for "max degree of parallelism" from the azure portal also.

推荐答案

您将无法改变最大DOP在SQL数据库和它等价于0（用于SQL数据库V12），它是SQL数据库V11不同的行为（这是1）总是。如果你看到你的查询计划影响的性能和需要将其重置为1，请打开支持票，MSFT，这将是固定的。

You will not be able to change Max DOP in SQL DB and it is equivalent to 0 (for SQL DB v12) which is a different behavior in SQL DB V11 (which is 1) always. If you see your query plans impacting the performance and need to reset it to 1, please open a support ticket to MSFT and this will be fixed.

这篇关于修改最大并行度为1天蓝色的SQL Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！