Home Dashboard Directory Help
Search

Option MaxTransferSize for database backup commands should be an sp_configure option. by Azhar Taj


Status: 

Closed
 as Won't Fix Help for as Won't Fix


8
0
Sign in
to vote
Type: Suggestion
ID: 837450
Opened: 3/20/2014 11:06:07 AM
Access Restriction: Public
0
Workaround(s)
view

Description

MaxTransferSize is by default set to 1 MB. At Microsoft IT we have found out that our storage arrays work with a lot less stress if MaxTransferSize is set to 256 KB. That is the recommended setting for many storage array vendors. We are currently going through this huge activity where backup jobs are being modified to add MaxTransferSize in there. If this were available as a SQL server wide option with sp_configure, it will make it so much easier for people to tweak it based upon what is appropriate for their environment.
Also, currently as per our conversation with SQL Dev, there is no way to specify MaxTransferSize for transaction log backups happening with LogShipping jobs and also any backup jobs happening via maintenance plans. Again, a server wide option would help resolve this.
Details
Sign in to post a comment.
Posted by Azhar Taj on 7/24/2014 at 10:53 AM
I see this issue has been closed as a "Won't fix". Can we have some reasons provided to us as to why this item is not worth considering? Thanks!
Sign in to post a workaround.