alexmarco
ADSM.ORG Member
- Joined
- Nov 9, 2007
- Messages
- 4
- Reaction score
- 0
- Points
- 0
Hi, guys and ladies..
I m looking for a tool , or formula with help me for make a capacity planning of my TSM Servers.
I m thinking in one thing like this:
Day 01.
Verify how much data has backep up in my tsm server of tests, with this command:
select cast(float(sum(bytes))/1024/1024/1024 as decimal(14,2)) as TGBU from summary where (end_time between '2007-11-08 08:00:57' and '2007-11-09 08:00:56') and activity='BACKUP'
This command returns how much GB/DAY has backep up:
TSM SERVER 01:
Operation Results
TGBU
----------------
350.31
TSM SERVER 02:
Operation Results
TGBU
----------------
300.16
Total = 650 GB/day of backep up data.
Other thing:
Using another select command, i can discover how much scracth tapes i have in my library:
select library_name, count(*) as volumes, status from libvolumes group by library_name,status
LIBRARY_NAME VOLUMES STATUS
------------------ ----------- ----------
TSM_LIB01 953 Private
TSM_LIB01 54 Scratch (TSM Server 01)
TSM_LIB02 1012 Private
TSM_LIB02 107 Scratch (TSM Server 02)
The TSM SERVER 02 is the library manager of my backup network.
So... with this two commands i discover:
In one day my TSM s backep up 650 GB of data, that is my yesterday status of tapes:
LIBRARY_NAME VOLUMES STATUS
------------------ ----------- ----------
TSM_LIB01 953 Private
TSM_LIB01 57 Scratch (TSM Server 01)
TSM_LIB02 1012 Private
TSM_LIB02 108 Scratch (TSM Server 02)
Then: in one day, 4 scratch LTO 01 cartridges has used during the backup.
Now, my questions are:
How i can discover the amount of cartridges used in a month period?
There is a tool, or formula (excel, for example) to make this capacity planning?
The expiration schedule is working properly.
Anyone help me?
I m looking for a tool , or formula with help me for make a capacity planning of my TSM Servers.
I m thinking in one thing like this:
Day 01.
Verify how much data has backep up in my tsm server of tests, with this command:
select cast(float(sum(bytes))/1024/1024/1024 as decimal(14,2)) as TGBU from summary where (end_time between '2007-11-08 08:00:57' and '2007-11-09 08:00:56') and activity='BACKUP'
This command returns how much GB/DAY has backep up:
TSM SERVER 01:
Operation Results
TGBU
----------------
350.31
TSM SERVER 02:
Operation Results
TGBU
----------------
300.16
Total = 650 GB/day of backep up data.
Other thing:
Using another select command, i can discover how much scracth tapes i have in my library:
select library_name, count(*) as volumes, status from libvolumes group by library_name,status
LIBRARY_NAME VOLUMES STATUS
------------------ ----------- ----------
TSM_LIB01 953 Private
TSM_LIB01 54 Scratch (TSM Server 01)
TSM_LIB02 1012 Private
TSM_LIB02 107 Scratch (TSM Server 02)
The TSM SERVER 02 is the library manager of my backup network.
So... with this two commands i discover:
In one day my TSM s backep up 650 GB of data, that is my yesterday status of tapes:
LIBRARY_NAME VOLUMES STATUS
------------------ ----------- ----------
TSM_LIB01 953 Private
TSM_LIB01 57 Scratch (TSM Server 01)
TSM_LIB02 1012 Private
TSM_LIB02 108 Scratch (TSM Server 02)
Then: in one day, 4 scratch LTO 01 cartridges has used during the backup.
Now, my questions are:
How i can discover the amount of cartridges used in a month period?
There is a tool, or formula (excel, for example) to make this capacity planning?
The expiration schedule is working properly.
Anyone help me?
Last edited: