Here is the procedure to get the Buffer count and MaxTransfersize for your backups in sql servers
use the following trace flags:
DBCC TRACEON (3605)
DBCC TRACEON (3213)
Then run your backups and you can see the following information in your errorlog.
Backup/Restore buffer configuration parameters
Memory limit: 6143MB
Buffer count: 6
Max transfer size: 64 KB
Min MaxTransfer size: 64 KB
Total buffer space: 0 MB
Buffers per read stream: 6
Buffers per write stream: 6
Tabular data device count: 1
FileTree data device count: 0
Filesystem i/o alignment: 512
No comments:
Post a Comment