ADSM-L

Help with TSM server being hammered by clients

2003-11-04 14:52:45
Subject: Help with TSM server being hammered by clients
From: "French, Michael" <Michael.French AT SAVVIS DOT NET>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 4 Nov 2003 13:51:07 -0600
        TSM Server 4.2.4.1 (Solaris)
        TSM Client 4.2.3 (Solaris)
        
        TSM DB 83GB (40% util)
        TSM Log 4.6GB 

        I am having a serious problem with 4 Solaris clients hammering the 
server during their backups.  Each client has a lot of file held on TSM, about 
4-5 million per node and growing, though not much data, only a couple of 
hundred GB's per node.  The server is very responsive when these clients are 
not backing up, all other backups run without lagging the server.  I have about 
120 nodes backing up to this server daily.
        What could be causing this performance problem?  Here is a show logpin 
during last nights backup:

tsm: I02SV1000>show logpin
Dirty page Lsn=4675033.188.3116, Last DB backup Lsn=4677956.167.3489, 
Transaction table
Lsn=4677883.231.3853, Running DB backup Lsn=0.0.0, Log truncation 
Lsn=4675033.188.3116 
Lsn=4675033.188.3116, Owner=DB, Length=128
Type=Update, Flags=C2, Action=ExtDelete, Page=6110475, Tsn=0:180594521, 
PrevLsn=4675033.180.2739,
UndoNextLsn=0.0.0, UpdtLsn=4675033.176.827 ===> ObjName=AF.Bitfiles, Index=12, 
RootAddr=29,
PartKeyLen=1, NonPartKeyLen=7, DataLen=20
The recovery log is pinned by a dirty page in the data base buffer pool. Check 
the buffer pool
statistics. If the associated transaction is still active then more information 
will be displayed
about that transaction. 
Database buffer pool global variables: 
CkptId=25232, NumClean=269056, MinClean=393192, NumTempClean=393216, 
MinTempClean=196596,
BufPoolSize=393216, BufDescCount=432537, BufDescMaxFree=432537,
DpTableSize=393216, DpCount=124149, DpDirty=124149, DpCkptId=21890, 
DpCursor=92805,
NumEmergency=0 CumEmergency=0, MaxEmergency=0.
BuffersXlatched=0, xLatchesStopped=False, FullFlushWaiting=False.

Is the large number of DpDirty pages bad?  I think so, but I don't know the 
techincal details behind this value.  The log is at 0% util when backups start 
during the evening and by midnight last night, the log was up to 80% and 
climbing rapidly.  Once I cancel these 4 clients from backing up, the log stops 
filling so rapidly.  Does anyone else have problems with clients that have 
large numbers of small files?  How do you handle backing them up?  It seems 
like these nodes take 8-10 hours a piece which seems very slow.

Thanks in advance for any assistance that you can provide!

Michael French
Savvis Communications
IDS01 Santa Clara, CA
(408)450-7812 -- desk
(408)239-9913 -- mobile
 

<Prev in Thread] Current Thread [Next in Thread>