[ADSM-L] sql tdp hang issue
2007-12-14 09:54:00
I have a dba that has one sql server that has "tsm hang" issues
according to him. They have a full backup job that backs up 7 sql db's.
The size is about 80GB total. Sometime it backs them all up with no
issues, sometime it says "waiting on tsm server" but if I look at "q se"
there are no active sessions. Right now there is one running from last
night and it has only backed up 12.5GB in 9 hours. below are some client
details and log details. Anyone have any ideas. Other sql backups run
just fine along with the other 15TB that backup each night, but of
course DBA's say it's a TSM issue.
Here is what they see when it hangs:
Full: 3 Read: 658505728 Written: 655360000 Rate: 480.95 Kb/Sec
Full: 3 Read: 658505728 Written: 655360000 Rate: 480.59 Kb/Sec
Full: 3 Read: 658505728 Written: 655360000 Rate: 480.23 Kb/Sec
Full: 3 Read: 658505728 Written: 655360000 Rate: 479.87 Kb/Sec
Waiting for TSM
server..................................................................
......................
clint info:
Node Name: WHQWPSQLCL1RS01_SQL
Platform: TDP MSSQL Win32
Client OS Level: 5.02
Client Version: Version 5, Release 3, Level 3.0
Policy Domain Name: SQL
Last Access Date/Time: 12/14/07 08:00:05
Days Since Last Access: <1
thanks,
Rod
This email and any files transmitted with it are confidential and intended
solely for the use of the addressee. If you are not the intended addressee,
then you have received this email in error and any use, dissemination,
forwarding, printing, or copying of this email is strictly prohibited. Please
notify us immediately of your unintended receipt by reply and then delete this
email and your reply. Tyson Foods, Inc. and its subsidiaries and affiliates
will not be held liable to any person resulting from the unintended or
unauthorized use of any information contained in this email or as a result of
any additions or deletions of information originally contained in this email.
|
|
|