As DBAs, integrity checks are one of our most crucial responsibilities. However, as databases grow in size it can become harder to fit integrity checks into our maintenance windows. As a result, it is sadly not uncommon to find them not being run regularly.

In this session, we will discuss how CheckDB works and how we can use the options available to us to create a strategy around integrity checks to ensure that we can fit them into our maintenance windows. Specifically, we will cover the following.

1) How CheckDB and its sub-commands work
2) How we can control the impact of CheckDB on our instances
3) Strategies around breaking up CheckDB's work or offloading that work.