ADSM-L

[ADSM-L] TDP for SQL gui takes 20 min to display inactive

2012-12-21 08:37:34
Subject: [ADSM-L] TDP for SQL gui takes 20 min to display inactive
From: "Schaub, Steve" <steve_schaub AT BCBST DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 21 Dec 2012 08:26:44 -0500
Tsm server 6.2.4.0
Tsm client 6.2.3.0
Tdp client 6.3.0.1
Windows 2003EE x64

Our DBA's are complaining that when they have to use the TDP gui to restore 
older databases by selecting "active/inactive", it sometimes takes 20+ minutes 
for the list of databases to refresh.

My first suspicion was that the meta data had somehow gotten off to tape, but I 
have confirmed the primary data is all on disk (ST03_DISK_P04), only copypool 
(ST03_TAPE_C04) is on tape.

Any ideas what would cause this behavior?

tsm: TSMBCP01>q occ archer_sql ARCHER\COMPOUND\meta*

Node Name  Type Filespace   FSID Storage    Number of  Physical   Logical
                Name             Pool Name      Files     Space     Space
                                                       Occupied  Occupied
                                                           (MB)      (MB)
---------- ---- ---------- ----- ---------- --------- --------- ---------
ARCHER_SQL Bkup ARCHER\CO-    12 ST03_DISK-   142,148    555.27    662.44
                 MPOUND\m-        _P04
                 eta\0000
ARCHER_SQL Bkup ARCHER\CO-    12 ST03_TAPE-   141,452    374.17    374.17
                 MPOUND\m-        _C04
                 eta\0000


tsm: TSMBCP01>q stg st03_disk_p04

Storage      Device       Estimated    Pct    Pct  High  Low  Next Stora-
Pool Name    Class Name    Capacity   Util   Migr   Mig  Mig  ge Pool
                                                    Pct  Pct
-----------  ----------  ----------  -----  -----  ----  ---  -----------
ST03_DISK_-  DISK             100 G    2.5    2.5    70   50  ST03_TAPE_-
P04                                                           P04


Steve Schaub
Systems Engineer II, Windows Backup/Recovery
BlueCross BlueShield of Tennessee
-----------------------------------------------------
Please see the following link for the BlueCross BlueShield of Tennessee E-mail 
disclaimer:  http://www.bcbst.com/email_disclaimer.shtm

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