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. (https://blobeater.blog/2017/09/04/dbcc-checkdb-azure-sql-database/)

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.

chart

You can find the article here: https://azure.microsoft.com/en-us/blog/data-integrity-in-azure-sql-database/

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).

Enjoy.

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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