January 10, 2013 at 3:12 pm
I have noticed some production databases are using TORN_PAGE_DETECTION.
I guess these were upgraded from SQL 2000.
There is currently no data issues in these databases
I have read it is best to change to CHECKSUM.
Can I just run the command: ALTER DATABASE [DBName] SET PAGE_VERIFY CHECKSUM
on each Production databases and that is it.
Can it be run during Prod hours, will there be a performance hit etc etc.
thanks for any clarification.
January 10, 2013 at 5:16 pm
Yes, you can run this.
It will not calculate checksums on all your pages or impact your load. What will happen is as pages are written back to disk for whatever reason (DML change, index rebuild), a checksum will be calculated and stored in the page header.
If you changed this and didn't have any activity on the server, you'd see no activity from the change. Only in the normal course of operation will this start calculating checksums.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply