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
|