Home All Groups Group Topic Archive Search About
Author
27 May 2005 4:14 AM
DavidMA
Hello,

Does SQL have any sort of checksum value attached to each 8K page or is
there a feature we can turn on to enable such a checksum?  I'm trying to
optimize our block data synchronization product specifically for SQL
databases.  Our product is similar in technology to rsync.  We currently use
MD5 checksums which can be resource intensive, but are very accurate.  We
are hoping that SQL already performed some checksum for each 8K page that we
could utilize to compare at a page level rather than generating our own MD5
checksums.  Please let me know if SQL has such a technology or if you
have any suggestions.

Thank you,
David Aschmann

Author
27 May 2005 11:19 AM
John Bell
Hi David

This was answered in .server. Please do not multipost.

John

Show quoteHide quote
"DavidMA" wrote:

> Hello,
>
> Does SQL have any sort of checksum value attached to each 8K page or is
> there a feature we can turn on to enable such a checksum?  I'm trying to
> optimize our block data synchronization product specifically for SQL
> databases.  Our product is similar in technology to rsync.  We currently use
> MD5 checksums which can be resource intensive, but are very accurate.  We
> are hoping that SQL already performed some checksum for each 8K page that we
> could utilize to compare at a page level rather than generating our own MD5
> checksums.  Please let me know if SQL has such a technology or if you
> have any suggestions.
>
> Thank you,
> David Aschmann

Bookmark and Share