MyTechMantra.com
Connect With MyTechMantra.com

Like Us on Facebook    Follow Us on Twitter     Subscribe to our Feeds     Subscribe to NewsLetter


















Trending SQL Server Tips






SQL Server 2016: MAXDOP for DBCC CHECKDB, DBCC CHECKTABLE and DBCC CHECKFILEGROUP T-SQL Enhancement

Read Comments   |   Related Topic: TSQL Enhancements SQL Server 2016 > Next Topic: AUTOGROW_SINGLE_FILE


Click here to read about new T-SQL enhancements in SQL Server 2016 from the beginning...

MAXDOP for DBCC CHECKDB, DBCC CHECKTABLE and DBCC CHECKFILEGROUP T-SQL Enhancement in SQL Server 2016

SQL Server 2016 brings MAXDOP settings, for DBCC CHECKDB, DBCC CHECKTABLE and DBCC CHECKFILEGROUP command. Database Administrators can leverage MAXDOP settings to above mentioned DBCC commands to achieve Max Degree of Parallelism.

SQL Server 2016 will continue to use the Max Degree of Parallelism (MAXDOP) value configured using SP_CONFIGURE system procedure if you specify MAXDOP value as ZERO for any of the DBCC CHECKDB, DBCC CHECKTABLE or DBCC CHECKFILEGROUP commands.

 Syntax MAXDOP options in SQL Server 2016

DBCC CHECKDB 
	[ ( database_name | database_id | 0
		[ , NOINDEX 
		| , { REPAIR_ALLOW_DATA_LOSS | REPAIR_FAST | REPAIR_REBUILD } ]
	) ]
	[ WITH 
		{
			[ ALL_ERRORMSGS ]
			[ , EXTENDED_LOGICAL_CHECKS ] 
			[ , NO_INFOMSGS ]
			[ , TABLOCK ]
			[ , ESTIMATEONLY ]
			[ , { PHYSICAL_ONLY | DATA_PURITY } ]
			[ , MAXDOP = number_of_processors ]
		}
	]
]

Related Tips

ALTER DATABASE SET AUTOGROW_SINGLE_FILE T-SQL Enhancement in SQL Server 2016
ALTER DATABASE SET AUTOGROW_ALL_FILES T-SQL Enhancement in SQL Server 2016
COMPRESS and DECOMPRESS T-SQL Enhancement in SQL Server 2016
STRING_SPLIT and STRING_ESCAPE T-SQL Enhancement in SQL Server 2016
SERVERPROPERTY T-SQL Enhancement in SQL Server 2016

Thank you for taking your time to read this article. Let's be Connected....

Sign-up for Our Newsletter to Get Free SQL Server Tips and News to Build your Career

Like MyTechMantra on Facebook to get updates on What's Happening in SQL Server

Example Usage of DBCC CHECKDB Using MAXDOP Settings in SQL Server 2016

DBCC CHECKDB ('MyTechMantra')
WITH ALL_ERRORMSGS, MAXDOP = 4
GO

Example Usage of DBCC CHECKTABLE Using MAXDOP Settings in SQL Server 2016

DBCC CHECKTABLE ('SchemaName.TableName') 
WITH PHYSICAL_ONLY, MAXDOP = 3 
GO 

Example Usage of DBCC CHECKFILEGROUP to Check Primary FileGroup Using MAXDOP Settings in SQL Server 2016

USE MyTechMantra
GO

DBCC CHECKFILEGROUP (1)
WITH ESTIMATEONLY, MAXDOP = 2 
GO

Click the Next Page button to continue reading about New T-SQL enhancements in SQL Server 2016 and click on the Previous Page button to revise the previouly read topic.

Previous Page.. Next Page..




Learn More...





Last Updated On: May 12, 2016



Share this Article



Receive Free SQL Server Tips and Keep Learning
Get Free SQL Server Tips




Please leave your Valuable Comment or Let us know how this article helped you: