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.