SAN vs Local Disks vs SSD vs Flash

Posted in 2013

NITIN MATHUR — Tue, 16 Apr 2013 15:27:20 — source: IIUG Forums & Mailing Lists

Hi, Our team is in process of migrating the DB servers to a new data centre and I have an option to decide for storage for our heavily used OLTP database (not huge in size, probably 30 GB) where there are lot of inserts (20 million records/day) to a particular table during the day. The IDS version is 11.50 FC8 (this will be upgraded to 11.70 FC5 next week) OS is SunOS 5.10 Generic_147441-07 i86pc i386 i86pc (32 GB memory) Please suggest which one is a good option. regards, Nitin

↪ replying to NITIN MATHUR

Art Kagel — Tue, 16 Apr 2013 16:07:46 — source: IIUG Forums & Mailing Lists

Absolute best? Go for as many local SSD drives as you can get, RAID10 them together and carve out your devices for chunks from there. Reserve 2 (or more) drives as a RAID1 pair (or smaller RAID10 array) for logical and physical logs. Select SSD drives carefully, they are not all created equal! Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Apr 16, 2013 at 11:27 AM, NITIN MATHUR <nitin_maths@rediffmail.com>wrote: > Hi, > > Our team is in process of migrating the DB servers to a new data centre > and I > have an option to decide for storage for our heavily used OLTP database > (not > huge in size, probably 30 GB) where there are lot of inserts (20 million > records/day) to a particular table during the day. > > The IDS version is 11.50 FC8 (this will be upgraded to 11.70 FC5 next week) > > OS is SunOS 5.10 Generic_147441-07 i86pc i386 i86pc (32 GB memory) > > Please suggest which one is a good option. > > regards, > > Nitin > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c20c9a466f9804da7c8e62

↪ replying to Art Kagel

NITIN MATHUR — Tue, 16 Apr 2013 20:38:02 — source: IIUG Forums & Mailing Lists

Thanks Art. regards, Nitin

Glossary

IDS (Informix Dynamic Server)