ADSM-L

[ADSM-L] sql tdp hang issue

2007-12-14 09:54:00
Subject: [ADSM-L] sql tdp hang issue
From: "Park, Rod" <rod.park AT TYSON DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 14 Dec 2007 08:52:59 -0600
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.