Azure SQL Database Data Integrity Checks

If you remember last month I wrote about DBCC CHECKDB and Azure SQL Database, more specifically whose responsibility (Microsoft’s) it is and ponderings on how it is actually done. (

Recall that is consumes a lot of DTUs running CHECKDB on your Azure SQL Database so I had doubts that it is something we as users should be doing, well I am happy to say there is now official documentation on this subject.

I did a quick overview chart on techniques used and all of them make sense.


You can find the article here:

Please see the link for more details especially how they would deal with YOUR DATA if integrity is comprised i.e. corruption. It is quite thorough. I particularly like the lost write protection where it tracks page writes and their associated LSNs (Log Sequence Numbers).


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s