This is an old revision of the document!
Table of Contents
Increase performance on backup clients and agents
Restore file server faster
I have had a number of customers lately call me to complain about restores of a single directory on a large file server running for many hours without transferring any data. In each case I have suggested they use
TESTFLAG DISABLENQR
Each time the next restore would run in minutes.
Many of you know that this simply changes the restore from the post TSM 3.1 “No Query Restore” back to the older “Classic” restore.
Backup with TDP MSSQL
Adding the following options into tdpsql.cfg from TDPsql folder will reduce backup time from 11 hours to 1 hour
BUFFers 4 SQLBUFFers 4 STRIPes 4
Higher values can be tested:
Buffering is only used on legacy mode.
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. In addition 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
On Spectrum Protect server also change the maximum monut points
upd node <node_name> maxnummp=10
