AW: [ADSM-L] AW: [ADSM-L] disk layout for db and log

Hi,

at the Oxford TSM Symposium there was a contribution by Jarrett Potts about 
improving performance:

http://tsm-symposium.oucs.ox.ac.uk/papers/Finding%20Performance%20Bottlenecks%20in%20Tivoli%20Storage%20Manager%20Environments%20(Jarrett%20Potts).pdf

We use raw logical db (16 GB) and log volumes (4 GB) and mirror with TSM.

best regards,
Kirsten Glöer

Forschungszentrum Karlsruhe GmbH
Institut für Wissenschaftliches Rechnen (IWR)
 
Hermann-von-Helmholtz-Platz 1          Tel.:         +49 (0)7247-82-8616
76344 Eggenstein-Leopoldshafen        Fax:         +49 (0)7247-82-4972
Deutschland                                      e-mail:     Kirsten.Gloeer AT 
iwr.fzk DOT de


-----Ursprüngliche Nachricht-----
Von: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] Im Auftrag 
von Dirk Kastens
Gesendet: Mittwoch, 19. Oktober 2005 17:32
An: ADSM-L AT VM.MARIST DOT EDU
Betreff: Re: [ADSM-L] AW: [ADSM-L] disk layout for db and log


Hi,

Gloeer, Kirsten schrieb:

> within the performance guide it is recommended to use multiple db 
> volumes (4 - 16) and multiple log volumes.

Where did you get the information about using 4-16 volumes? The performance 
guide only talks about "multiple" volumes on "multiple" disks.

> A TSM server database with 195 GB seems to be very large in order to 
> reach high performance rates.

At the moment our database is 48 GB in size and is 65% utilized. What, if I use 
raw logical volumes for the db and log volumes? Maybe I should start with 3 or 
4 rlv of size 20 GB, each on a separate disk and let them be mirrored by TSM. 
My other question was about allocationg db and log volumes on the same disks or 
separating them. So there are two possible configurations:

hdisk2: db1 (20GB) + log1 (4GB) -> mirror on hdisk5
hdisk3: db2 (20GB) + log2 (4GB) -> mirror on hdisk6
hdisk4: db3 (20GB) + log3 (4GB) -> mirror on hdisk7

or

hdisk2: db1 (20GB) + db2 (20GB) -> mirror on hdisk5
hdisk3: db3 (20GB) + db4 (20GB) -> mirror on hdisk6
hdisk4: log1 (4GB) + log2 (4GB) + log3 (4GB) -> mirror on hdisk7

--
Regards,

Dirk Kastens
Universitaet Osnabrueck, Rechenzentrum (Computer Center) Albrechtstr. 28, 49069 
Osnabrueck, Germany
Tel.: +49-541-969-2347, FAX: -2470