tag:blogger.com,1999:blog-4402664127960334547.post82141426711075843..comments2024-03-24T10:38:58.256-05:00Comments on Nebraska SQL from @DBA_ANDY: Backup Checksums and Trace Flag 3023@DBA_ANDYhttp://www.blogger.com/profile/09130139756284009675noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-4402664127960334547.post-53731652578469967362014-04-23T16:04:31.908-05:002014-04-23T16:04:31.908-05:00Calculating backup checksums does cost CPU cycles ...Calculating backup checksums does cost CPU cycles (http://technet.microsoft.com/en-us/library/ms189055.aspx) so monitor your CPU - in general SQL Servers are not CPU-bound, but if you find it is a problem, consider whether you can add additional CPUs to resolve the situation rather than disabling the checksums (pending licensing of course).<br /><br />Thanks for reading and commenting!@DBA_ANDYhttps://www.blogger.com/profile/09130139756284009675noreply@blogger.comtag:blogger.com,1999:blog-4402664127960334547.post-44628733865151318792014-04-22T10:31:04.033-05:002014-04-22T10:31:04.033-05:00does using checksum effect backup performance ??does using checksum effect backup performance ??Unknownhttps://www.blogger.com/profile/02120699767816925215noreply@blogger.comtag:blogger.com,1999:blog-4402664127960334547.post-76335910876579547532014-04-01T23:05:00.135-05:002014-04-01T23:05:00.135-05:00Thanks for sharing this. It's the thing I have...Thanks for sharing this. It's the thing I have been looking for. We use a backup software to backup sql. It was a surprise to me our server guys told me there is no such a check box to enable backup checksum when they set up backup. I then went to find their official technical document. Yeah, they are right. No backup checksum. I am looking to implement this change in our environment after some testing. Cheers for that.Patrick Genoreply@blogger.com