Wednesday, August 17, 2011

Buffer count and MaxTransferSize for backups in sql server

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