search

olahallengren / sql-server-maintenance-solution

SQL Server Maintenance Solution
https://ola.hallengren.com
MIT License
2.91k stars 756 forks source link

MAXDOP for Update stastistics #576

Open abarick opened 3 years ago

abarick commented 3 years ago

MAXDOP parameter for Update statistics

Is it possible to include a new parameter or use the exiting parameter MAXDOP in IndexOptimize for Update statistics. This will be helpful for bigger instances.

Regards,

Ash.

damonripper commented 3 years ago

Actually, I see logic in the proc for this. Unfortunately it is looking at server property for version, which doesn't work for some things like Azure SQL Databases. Ola, I believe version check logic should be modified to use compatibility_level at the database level instead of server level ... see this post for details: http://davebland.com/azure-sql-db-and-version.

If I have time I may work on this and create a PR :)