Hi Friends,

This is my 45th blog on SQL Server Trace Flag 3213 in the series of One Trace Flag a Day. You can go to all blogs under that series by clicking here.

This is one of the trace flag which can provide you the internal information about backup and restore operations. In simple words we can say that, by using this trace flag we can check the total amount of memory or buffers used for backup or restore operation. Let me show you practically for backup operation:



BUFFERCOUNT: Specifies the total number of I/O buffers to be used for the backup operation. You can specify any positive integer. however, large numbers of buffers might cause out of memory errors because of inadequate virtual address space in the Sqlservr.exe process.The total space used by the buffers is determined by buffercount * maxtransfersize.

MAXTRANSFERSIZE: Specifies the largest unit of transfer in bytes to be used between SQL Server and the backup media. The possible values are multiples of 65536 bytes (64 KB) ranging up to 4194304 bytes (4 MB).

Below is the figure which can show you the complete overview of backup operation.


Finally do not forget to turn off the trace flags.

PS: Do not use trace flags in production environment without testing it on non production environments and without consulting because everything comes at a cost.


Prince Kumar Rastogi

Like us on FaceBook | Join the fastest growing SQL Server group on FaceBook

Follow Prince Rastogi on Twitter | Follow Prince Rastogi on FaceBook