Re: 4 spindles for db: best performing setup

2009-02-19 Thread Mark Stapleton
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of km >TSM mirroring doesnt help performance when doing expiration or reclamation >anyway which is what you want to optimize the DB for. TSM mirroring, however, DOES give one concrete benefit that OS or hardware mirroring can't

Re: 4 spindles for db: best performing setup

2009-02-19 Thread km
On 19/02, Allen S. Rout wrote: > >> On Thu, 19 Feb 2009 16:27:29 +0100, km said: > > > > RAID5 will give you the maximum amount of IOPS for the DB with disk > > redundancy, though 4 disks is on the low side. > > > TSM mirroring doesnt help performance when doing expiration or > > reclamation anywa

Re: 4 spindles for db: best performing setup

2009-02-19 Thread Allen S. Rout
>> On Thu, 19 Feb 2009 16:27:29 +0100, km said: > RAID5 will give you the maximum amount of IOPS for the DB with disk > redundancy, though 4 disks is on the low side. > TSM mirroring doesnt help performance when doing expiration or > reclamation anyway which is what you want to optimize the DB

Re: 4 spindles for db: best performing setup

2009-02-19 Thread km
On 18/02, Michael Green wrote: > You are given 4 spindles to place TSM DB on them. > How would you set them up to squeeze maximum performance for DB? > > 1. Dedicate each spindle for a DBC (result: 3 DBCs, one spindle left > out, nevermind) > 2. Create RAID 0 out of each pair of disks. Place a DBC

Re: 4 spindles for db: best performing setup

2009-02-19 Thread Richard Rhodes
ADSM-L@VM.MARIST.EDU Dist Stor cc Manager" Re: 4 spindles for db: best performing setup 02/19/2009 03:06 AM

SV: 4 spindles for db: best performing setup

2009-02-19 Thread Daniel Sparrman
will reduce performance. Best Regards Daniel Sparrman Från: ADSM: Dist Stor Manager [ads...@vm.marist.edu] för Oscar Kolsteren [oscar.kolste...@ingdirect.co.uk] Skickat: den 19 februari 2009 09:04 Till: ADSM-L@VM.MARIST.EDU Ämne: Re: 4 spindles for db: bes

Re: 4 spindles for db: best performing setup

2009-02-19 Thread Oscar Kolsteren
rds, Oscar -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Michael Green Sent: 18 February 2009 20:23 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] 4 spindles for db: best performing setup You are given 4 spindles to place TSM DB on them. How would yo

Re: 4 spindles for db: best performing setup

2009-02-18 Thread Steven Harris
Sent by: "ADSM: ADSM-L@VM.MARIST.EDU Dist Stor cc Manager" [ADSM-L] 4 spindles for db: best performing setup 19/02/

4 spindles for db: best performing setup

2009-02-18 Thread Michael Green
You are given 4 spindles to place TSM DB on them. How would you set them up to squeeze maximum performance for DB? 1. Dedicate each spindle for a DBC (result: 3 DBCs, one spindle left out, nevermind) 2. Create RAID 0 out of each pair of disks. Place a DBC on each RAID (result: 2 DBCs on two separa