PAGE_VERIFY Database Option

Short story…

PAGE_VERIFY Database Option should be set to “CHECKSUM” . This will reduce your chances of data corruption significantly and has (almost) no performance impact. That almost means a little CPU overhead but yes you should not jeopardize the intergrity of the data being stored for any cost obviously. Yes / No ? Read ahead if the answer is Yes or read ahead anyway since I have type some more stuff.

Background

PAGE_VERIFY Database Option was introduced in SQL server 2005 with three possible values. All the values other than CHECKSUM are basically for backward compatibility but aren’t a wise choice as data write operations do not get the benefit of highest level of verification

This is the recommendation from Microsoft to all major SQL Server MVPs and greats including yours truly (me..  no harm in dreaming).

Advertisements
About

IT professional with wider interest in technology

Posted in Uncategorized

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

%d bloggers like this: