Ang: Re: Ang: Re: DB2: SSD vs more RAM

2010-11-23 Thread Daniel Sparrman
get hit long before you notice you have internal issues within the TSM server. Best Regards Daniel Sparrman -"ADSM: Dist Stor Manager" skrev: - Till: ADSM-L@VM.MARIST.EDU Från: Henrik Ahlgren Sänt av: "ADSM: Dist Stor Manager" Datum: 11/23/2010 08:27 Ärende: Re: A

Re: Ang: Re: DB2: SSD vs more RAM

2010-11-22 Thread Henrik Ahlgren
uot;ADSM: Dist Stor Manager" skrev: - Till: ADSM-L@VM.MARIST.EDU Från: Henrik Ahlgren Sänt av: "ADSM: Dist Stor Manager" Datum: 11/22/2010 23:27 Ärende: Re: DB2: SSD vs more RAM Yep, doing a 200 GB database with high-end and reduntant SLC NAND is definedly not cheap (let alone the

Ang: Re: DB2: SSD vs more RAM

2010-11-22 Thread Daniel Sparrman
ADSM: Dist Stor Manager" skrev: - Till: ADSM-L@VM.MARIST.EDU Från: Henrik Ahlgren Sänt av: "ADSM: Dist Stor Manager" Datum: 11/22/2010 23:27 Ärende: Re: DB2: SSD vs more RAM Yep, doing a 200 GB database with high-end and reduntant SLC NAND is definedly not cheap (l

Re: DB2: SSD vs more RAM

2010-11-22 Thread Henrik Ahlgren
Yep, doing a 200 GB database with high-end and reduntant SLC NAND is definedly not cheap (let alone the 2 TB Bill Colwell described in his post). Not that bunch of 15K disks and the power to run them is free, either. Cost per IOPS for disk is actually terrible. Just a thought (don't take too se

Re: DB2: SSD vs more RAM

2010-11-22 Thread Colwell, William F.
ing dedup, expect the db to grow very big very fast. Thanks, Bill Colwell Draper Lab -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Henrik Ahlgren Sent: Monday, November 22, 2010 4:25 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: DB2: SSD vs mo

Re: DB2: SSD vs more RAM

2010-11-22 Thread Pretorius, Louw
Hi Henrik, Well as I was specing a new TSM server i thought, why not try for the best performance possible and although the SSD drives drives the server costs up by 50% it wasn't out of the ballpark, therefore I wanted to hear from the community what their ideas were. As it stands I have a 100

Re: DB2: SSD vs more RAM

2010-11-22 Thread Henrik Ahlgren
Or maybe he has a huge amount of DB entries? If his options are either six SAS 15K or eight SSDs (50GB each), it means his DB is propably in the multi-hundred gigabyte range. If he just needs the IOPS for smaller DB, then he would not need 8 SSDs to beat 6 platters, even one or two could be eno

Re: DB2: SSD vs more RAM

2010-11-17 Thread Remco Post
SSD to me seems overkill if you already have 24 GB of RAM, unless you need superfast performance and are going to run a very busy TSM server with a huge amount of concurrent sessions. -- Gr., Remco On 17 nov. 2010, at 12:16, "Pretorius, Louw " wrote: > Hi all, > > I am currently in the pr

Re: DB2: SSD vs more RAM

2010-11-17 Thread Maurice van 't Loo
Hi Louw, For a single instance 24GB of RAM should be enough. For the OS is using SSD a bit nonsence, even SATA is enough, so don't spend to much on that. But if you want speed, look at the SSD cards of Fusion-IO (fusionio.com) these cards are build for enterprise usage and have redundancy on the