Yes, that is kinda what I guessed. I have the 4TB SQL backup still
running from Saturday. It is only 50% done.
There has got to be a better way to handle SQL backups of LARGE databases.
This is causing numerous headaches/problems with other backups by
pre-allocating the space or if going to tape, locking the tape drives for
the duration.
Del, I know we discussed this and stripes (I have it configured for 3)
for improving the speed, but this goes back to my question about breaking
up the SQL backup into multiple chunks, especially with this new issue of
it locking 4TB of disk space to contain the backup, until it finishes. I
can't have 1-backup detrimentally effecting everyone else and at the speed
it is running, it will take almost a week to finish.
Suggestions?
From: "Billaudeau, Pierre" <P.Billaudeau AT SAQ.QC DOT CA>
To: ADSM-L AT VM.MARIST DOT EDU
Date: 09/13/2011 12:22 PM
Subject: Re: [ADSM-L] Disk storage pool 100% utilized but NOT
cached
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
Hi Zoltan,
Is it possible you had a very large (or several) backup running
using the remaining 66% (over 4 tb) of your backup pool ? Current backups
freezes backup data space on the disk pool so it is not eligible for
migration.
Pierre Billaudeau
Analyste en stockage
Livraison des Infrastructures Serveurs
Société des Alcools du Québec
514-254-6000 x 6559
-----Message d'origine-----
De : ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] De la part de
Zoltan Forray/AC/VCU
Envoyé : 13 septembre 2011 10:23
À : ADSM-L AT VM.MARIST DOT EDU
Objet : [ADSM-L] Disk storage pool 100% utilized but NOT cached
I think I know the answer to this question but figured it would be a good
question to ask,
This morning I was getting reports that backups were failing due to
backups not being able to get space in the disk stgpool.
When I did a "Q STG", this is what I get:
9:25:34 AM MOON : q stg
Storage Device Estimated Pct Pct High Low Next Stora-
Pool Name Class Name Capacity Util Migr Mig Mig ge Pool
Pct Pct
----------- ---------- ---------- ----- ----- ---- --- -----------
ARCHIVEPOOL DISK 205 G 0.3 0.3 90 70 TS1130
BACKUPPOOL DISK 6,369 G 100.0 33.9 90 70 TS1130
Why would a disk storage pool be "100% Utilized" and only 34% migratable
when I don't have Caching turned on?
Zoltan Forray
TSM Software & Hardware Administrator
Virginia Commonwealth University
UCC/Office of Technology Services
zforray AT vcu DOT edu - 804-828-4807
Don't be a phishing victim - VCU and other reputable organizations will
never use email to request that you reply with your password, social
security number or confidential personal information. For more details
visit http://infosecurity.vcu.edu/phishing.html
------------------
Information confidentielle : Le présent message, ainsi que tout fichier
qui y est joint, est envoyé à l'intention exclusive de son ou de ses
destinataires; il est de nature confidentielle et peut constituer une
information privilégiée. Nous avertissons toute personne autre que le
destinataire prévu que tout examen, réacheminement, impression, copie,
distribution ou autre utilisation de ce message et de tout fichier qui y
est joint est strictement interdit. Si vous n'êtes pas le destinataire
prévu, veuillez en aviser immédiatement l'expéditeur par retour de
courriel et supprimer ce message et tout document joint de votre système.
Merci.
|