sp_Blitz says "Page Verification Not Optimal" on MDS database

5 votes

1 answer

1111 views

sql-server sp-blitz master-data-services

                          I've run sp_blitz (version 45) on our test database server.
It complains about

> Database [MDS] has TORN_PAGE_DETECTION for page verification.  SQL Server may have a harder time recognizing and recovering from storage corruption.  Consider using CHECKSUM instead.

But this is a database from Microsoft. 

Is it wise to change the Page Verification to CheckSum?

Or should we wait for Microsoft to release a new version of MDS?

Asked by Henrik Staun Poulsen (2291 rep)

Jan 8, 2016, 07:47 AM
Last activity: Jul 15, 2023, 12:39 PM

sp_Blitz says "Page Verification Not Optimal" on MDS database

Related Questions