Recommendations on LUN size
Does anyone have any thoughts on sizing LUNS in a SAN for an Informix database? I am going to be converting to new servers later this year and have the opportunity to design everything from scratch. I know it used to be more, small LUNS was better to increase spindle count, but I don't know if that still applies with today's SANS (we have a Clariion.) We currently use 5 GB LUNS, but I'm wondering if there is a best practice guideline for something different. Thanks for your input, Mary Gregory Sr. Systems Programmer Rheem Manufacturing Work (334) 260-1460 Cell (334) 462-1852
You just have to balance the need for simplicity (read fewer bigger chunks) with checkpoint flush efficiency which affects data safety (so more chunks). At checkpoint time the engine assigns one flusher per chunk, so the more chunks (up to a point of course) the faster data gets to disk. Art On Wed, Feb 18, 2009 at 2:16 PM, Mary Gregory <mary.gregory@rheem.com>wrote: > Does anyone have any thoughts on sizing LUNS in a SAN for an Informix > database? I am going to be converting to new servers later this year > and have the opportunity to design everything from scratch. I know it > used to be more, small LUNS was better to increase spindle count, but I > don't know if that still applies with today's SANS (we have a Clariion.) > We currently use 5 GB LUNS, but I'm wondering if there is a best > practice guideline for something different. > > Thanks for your input, > > Mary Gregory > > Sr. Systems Programmer > > Rheem Manufacturing > > Work (334) 260-1460 > > Cell (334) 462-1852 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. --00163646d0bee890b4046337d62f
- How many dbspaces do you have now? - on how many disks? - are any of them being hit particularly hard with I/O? - how many tables? - which Clariion and what size disks? - IDS version and OS version? - What's air-speed velocity of a fully-laden swallow? (sorry!) Bob ----- Original Message ----- From: "Mary Gregory" <mary.gregory@rheem.com> To: ids@iiug.org Sent: Wednesday, February 18, 2009 2:16:05 PM GMT -05:00 US/Canada Eastern Subject: Recommendations on LUN size [14937] Does anyone have any thoughts on sizing LUNS in a SAN for an Informix database? I am going to be converting to new servers later this year and have the opportunity to design everything from scratch. I know it used to be more, small LUNS was better to increase spindle count, but I don't know if that still applies with today's SANS (we have a Clariion.) We currently use 5 GB LUNS, but I'm wondering if there is a best practice guideline for something different. Thanks for your input, Mary Gregory Sr. Systems Programmer Rheem Manufacturing Work (334) 260-1460 Cell (334) 462-1852 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
On Wed, Feb 18, 2009 at 5:49 PM, rroussey@comcast.net <rroussey@comcast.net>wrote: > > - What's air-speed velocity of a fully-laden swallow? African swallow or European? Art > Bob > > ----- Original Message ----- > From: "Mary Gregory" <mary.gregory@rheem.com> > To: ids@iiug.org > Sent: Wednesday, February 18, 2009 2:16:05 PM GMT -05:00 US/Canada Eastern > Subject: Recommendations on LUN size [14937] > > Does anyone have any thoughts on sizing LUNS in a SAN for an Informix > database? I am going to be converting to new servers later this year > and have the opportunity to design everything from scratch. I know it > used to be more, small LUNS was better to increase spindle count, but I > don't know if that still applies with today's SANS (we have a Clariion.) > We currently use 5 GB LUNS, but I'm wondering if there is a best > practice guideline for something different. > > Thanks for your input, > > Mary Gregory > > Sr. Systems Programmer > > Rheem Manufacturing > > Work (334) 260-1460 > > Cell (334) 462-1852 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. --0016364ee12a5f231a0463396772