0

So I used sp_blitz and came across a suggestion to change verification to checksum. What I want to know is, would this step require any downtime?

1 Answer 1

3

Nope, no downtime for this change at all.

Here's the explanation of what/when things happen:

Keep in mind that just changing the setting to CHECKSUM does not instantly add CHECKSUMs to your existing data pages in the database. In order for this to happen, you have to read each page into memory, make some sort of change and then write it back out to the storage subsystem. This can happen from normal INSERT/UPDATE/DELETE activity over time, or from rebuilding your indexes.

Source: http://www.sqlskills.com/blogs/glenn/setting-your-page-verify-database-option-to-checksum/

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.