A Look At DBCC CHECKCONSTRAINTS and I/O Erin Stellato of SQLskills takes a deep look into the I/O impact of running DBCC CHECKCONSTRAINTS, including explaining why some check methods may consume a lot more I/O than others. Erin Stellato ◆ February 28, 2013 8