Why MAXDOP shouldn’t be left to default(0) and Must Be Changed
As you are aware, MAXDOP value is set to 0 when you do fresh installation of SQL Server on your server. Let’s understand why we should not leave it at its default value which is 0. Maxdop(Maximum Degree of Parallelism) 0 is as good as using all your processors on that server(unless you have more …
Why MAXDOP shouldn’t be left to default(0) and Must Be Changed Read More »