Re: [ADSM-L] DB2: SSD vs more RAM
2010-11-22 04:27:40
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 enough. (Just one
Intel X25E does 35K IOPS random 4K read.) I'm not sure how much doubling the
RAM would help with operations such as expiration, DB backup etc. compared to
nice SSD setup.
I'm wondering why so little discussion here on using solid state devices for
TSM databases? Some of you must be doing it, right?
On Nov 17, 2010, at 7:50 PM, Remco Post wrote:
> 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 <louw AT sun.ac DOT za>" <louw AT
> SUN.AC DOT ZA> wrote:
>
>> 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.
>>
>> Currently I have RAM set at 24GB but its way cheaper doubling the RAM than
>> to buy 8 x SSD's
>> Currently I have 8 x SSD vs 6 x SAS 15K
--
Henrik Ahlgren
Seestieto
+358-50-3866200
|
|
|