Tag: DBCC CHECKDB

SQL Server VLDB in Azure: DBA Tasks Made Simple

by Dimitri Furman // 0 Comments

Reviewed by: Rajesh Setlem, Mike Weiner, Xiaochen Wu With thanks to Joey D’Antoni (blog) for asking a great question that prompted this article. As any experienced DBA knows, supporting a very large database (VLDB) tends to be exponentially more complex than supporting smaller databases. The definition of VLDB has been shifting in recent years, but… Read more

SQLSweet16!, Episode 6: DBCC CHECKDB with MAXDOP

by Sanjay Mishra // 6 Comments

Reviewed By: Dimitri Furman DBCC CHECKDB is a common database maintenance task. It can take up significant amount of system resources, and can impact the performance of the production workload. There are some very good articles on the web on optimizing performance of DBCC CHECKDB and minimizing performance impact. SQL Server 2016 (and now backported… Read more