TDP for SQL Stripes and Performance Tunning

1
1424

When you backup SQL with TDP agent (only for legacy method), you can use buffering parameters and stripes so that improving data transfer rate of SQL databases could be possible.

The number of buffers that Data Protection for SQL allocates to the read and write threads can be specified in the /buffers (3 by default) and /sqlbuffers (0 by default) parameters of the command line interface. The size of these buffers can be specified in the /buffersize (1024 by default) and /sqlbuffersize (1024 by default) parameters. Inaddition to this /Stripes (1 by default) parameter determines the number of sessions in TSM Servers.

For example, you can use these parameters in your tdpsql.cfg file to backup SQL databases with 5 sessions;

BUFFers 10
BUFFERSIze 8192
STRIPes 5
SQLBUFFers 32
SQLBUFFERSIze 4096

 

1 COMMENT

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.