Re: VMWare and Oracle IO

  • From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
  • To: "niall.litchfield@xxxxxxxxx" <niall.litchfield@xxxxxxxxx>
  • Date: Tue, 7 Oct 2014 11:22:43 -0500

Swappiness should be 0.  Make sure transparent huge pages are turned off. Dirty 
background ratio =3. Dirty ratio=15. Dirty expire centisecs= 500. Dirty write 
back centisecs=100

Install package tuned and enable enterprise storage profile. Put 
elevator=deadline in grub.conf

Sent from my iPad

> On Oct 7, 2014, at 10:59 AM, Niall Litchfield <niall.litchfield@xxxxxxxxx> 
> wrote:
> 
> Hi Jared
> 
> How is the storage provisioned to the VMs? Worst case is probably thin 
> provisioned vmdk on top of a thin provisioned LUN from a storage array 
> vendor. 
> 
>> On Tue, Oct 7, 2014 at 4:29 PM, Jared Still <jkstill@xxxxxxxxx> wrote:
>> Fellow Oracleites:
>> 
>> I have  been investigating a client database or two that have been 
>> experiencing IO problems since being virtualized via VMWare.
>> 
>> SA's claim no IO issues, but we have seen an Oracle IO take up to 3.5 
>> seconds.  
>> Seems slow to me.
>> 
>> One thing I have learned is the the priority settings on VMWare disk shares 
>> can cause this issue for lower priority systems when the favored system(s) 
>> are requesting a lot of IO.
>> 
>> What other gotcha's should we be looking for?
>> 
>> Thanks!
>> 
>> Jared Still
>> Certifiable Oracle DBA and Part Time Perl Evangelist
>> Principal at Pythian
>> Pythian Blog http://www.pythian.com/blog/author/still/
>> Oracle Blog: http://jkstill.blogspot.com
>> Home Page: http://jaredstill.com
> 
> 
> 
> -- 
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info

Other related posts: