Day 7–Trace flag 2528 disable parallelism in maintenance DBCC

Happy Weekend folks. Today let me discuss about trace flag 2528 which will disable parallelism on maintenance DBCC. By using this trace flag it disables parallel checking of objects by DBCC CHECKDB, DBCC CHECKFILEGROUP, and DBCC CHECKTABLE commands. By default parallelism is enabled and it will look for max degree of parallelism to utilize parallel processors for all queries however in some scenarios if you want to turn off parallelism for maintenance DBCC commands then you can utilize this trace flag so that you can utilize other processors for your adhoc queries and other operations