Home Forums SQL Server 2017 SQL Server 2017 - Administration blocking for same query on user DB RE: blocking for same query on user DB
sqlguy80
SSCrazy
Points: 2763
More actions
December 5, 2018 at 1:22 pm
#2015603
I noticed the default settings maxdop=0 and cost threshold of parallelism=5 and the production instance is a VMWare virtual machine.
I'm thinking changing cost threshold of parallelism to 50 will fix this. Any inputs?