|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Page Checksums?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 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 |
|||||||||||||||||||||||