Backup with TDP for SQL Server is very slow.

[douglasro]

Hi, everyone


I need your advices.
I have one tdp for sql server and this week the backup of the databases is very slow.
I verified opt files, I/O on physical disks, network and I didn't find anything.


The primary storage pool is a disk pool type, and the next storage pool is a tape pool.


I tried make one backup without the TDP and worked normally.

I need help.

Douglas.

 

[Trident]

Hi,
Please post dsm.opt and tdpsql.cfg

There is a lot of tweaking you can do.

 

[moon-buddy]

Hi, everyone


I need your advices.
I have one tdp for sql server and this week the backup of the databases is very slow.
I verified opt files, I/O on physical disks, network and I didn't find anything.


The primary storage pool is a disk pool type, and the next storage pool is a tape pool.


I tried make one backup without the TDP and worked normally.

I need help.

Douglas.

Has this been always like this or just this week?

If it was OK before, what changed this week?

 

[douglasro]

Hi,

Moon, this problem started only occur this week. What changes was the lto3 tape to lto4.

dsm.opt:
NODename SQL_DIARIO
password pro2010tsm
passwordaccess generate
COMMMethod TCPip
TCPServeraddress 10.25.0.13
TCPPort 1500
TCPWindowsize 512
TCPBuffSize 512
COMPRESSIon NO
SCHEDMODE polling
SCHEDLogname F:\TSM\Schedule_FULL.log
ERRORLogname F:\TSM\Error_FULL.log


INCLUDE "\...\meta\...\*" DATABASE
INCLUDE "\...\data\...\*" DATABASE


tdpsql.cfg:

SQLSERVer SRVSTIDATABASE
FROMSQLserver SRVSTIDATABASE
SQLAUTHentication INTegrated
nodename SQL_DIARIO
MOUNTWaitfordata Yes
BACKUPMethod LEGACY
DIFFESTimate 20
BUFFers 3
BUFFERSIze 1024
STRIPes 1
SQLBUFFers 0
SQLBUFFERSIze 1024
LOGPrune 60
LANGuage ENU
BACKUPDestination TSM
DATEformat 1
NUMBERformat 5
TARGETNode 1
LASTPRUNEDate 04/04/2013 09:09:13

 

[Trident]

Hi,

My settings are for an enviroment where there tsm server is runnin redhat 6 and tsm server 6.2.x.x

Set tcpwindowsize to 0. TSM server and client will then leave windowscaling to the operating system. Lots of gain in throughput.

For tdpsql.cfg. These settings are for a sql server with 128Gb of memory and storage on very fast drives ( 2 x 8Gb FC link to 3par san)

BUFFers 8
BUFFERSIze 8192
STRIPes 8
SQLBUFFers 32
SQLBUFFERSIze 4096


I am able to push 10Gbit with these settings.

Try to tune sqlbuffersize and buffersize, as these will eat memory

Stripes is the number of parallel sessions to your tsm server. Keep maxnummp higher than stripes if storage pool is devt=file. Start with a value of 2, and increase untill you are satisfied.

 

[moon-buddy]

Assuming you backup to disk directly, increase the following setting:


BUFFers 10
STRIPes 5

on tdpsql.cfg

 

[tsm_dude]

Ah, you changed from LTO3 to LTO4 ? that could be it. Did you update your drivers/firmware etc ?