Informix in the SAN environment
Posted in 2004
Hi All , My question is:- Do all the practices mentioned over the years on this new group for disk layout's hold true still for performance on SAN's? I know NO RAID 5. No doubt you still get performance gains but at what price from the administration perspective. I admit it is a pretty open ended question but the idea is to get, hopefully a discussion with a number of views and ideas to use in the future for SAN environments if the "old" views are different. I also ask this question as SAN's technology is becoming more accessible ( Not to all though I know but I am lucky enough to have worked in a number of environments where they do have it). I am interested in a few that come to mind but other practices people want to discuss would be of great benefit as well. 1. Detached V attached indexes 2. Moving Physical Log and Logical Logs out of Rootdbs 3. Raw devices V cooked files using Vertias 4. Optimal Size of chunks related to version 9.4 as the 2 gig chunk limit has been removed. I also realise some of the above maybe a suck it and see type or personal preference question but I figure there are people out there who have experience of these on SAN's. Thank You Traveller2003