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
tor Manager [mailto:ads...@vm.marist.edu] On Behalf Of > Henrik Ahlgren > Sent: 22 November 2010 11:25 > To: ADSM-L@VM.MARIST.EDU > Subject: Re: [ADSM-L] DB2: SSD vs more RAM > > Or maybe he has a huge amount of DB entries? If his options are either six > SAS 15K or eight SS

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
ere's any other opinions let's hear it, the more opinions the more wisdom... Regards Louw Pretorius -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Henrik Ahlgren Sent: 22 November 2010 11:25 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L]

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

DB2: SSD vs more RAM

2010-11-17 Thread Pretorius, Louw
Hi all, I am currently in the process of setting up specifications for our new TSM6.2 server. I started by adding 8 x SSD 50GB disks to hold OS and DB, but because of the high costs was wondering if it's possible to rather buy more RAM and increase the DB2 cache to speed up the database. Cu