Data Protection for SQL Server is a multi-threaded application that uses asynchronous execution threads to transfer data between the SQL and Tivoli® Storage Manager servers.
To accomplish this, multiple data buffers are used to allow one thread to receive data from one side, while another thread sends data to the other side. For example, one thread can read data from an SQL Server while another sends data to the Tivoli Storage Manager server.
The number of buffers that Data Protection for SQL Server allocates to these threads is specified by the /buffers and /sqlbuffers parameters. The size of these buffers is specified by the /buffersize and /sqlbuffersize parameters. These parameters are set on the Properties page. When the parameters are set on the Properties page, the dsm.opt file is updated. You can also use the command-line interface to update the dsm.opt file.