optimize oracle on vmware n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Optimize Oracle on VMware PowerPoint Presentation
Download Presentation
Optimize Oracle on VMware

Loading in 2 Seconds...

play fullscreen
1 / 24

Optimize Oracle on VMware - PowerPoint PPT Presentation


  • 107 Views
  • Uploaded on

Optimize Oracle on VMware. Tips for Optimal Virtualized Oracle Databases PHLOUG Philadelphia, PA June 16th. Bert Scalzo …. Database Expert & Product Architect for Quest Software Oracle Background: Worked with Oracle databases for over two decades (starting with version 4)

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Optimize Oracle on VMware' - jun


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
optimize oracle on vmware
Optimize Oracle on VMware
  • Tips for Optimal Virtualized Oracle Databases
  • PHLOUG
  • Philadelphia, PA
  • June 16th
bert scalzo
Bert Scalzo …

Database Expert & Product Architect for Quest Software

Oracle Background:

Worked with Oracle databases for over two decades (starting with version 4)

Work history includes time at both “Oracle Education” and “Oracle Consulting”

Academic Background:

Several Oracle Masters certifications

BS, MS and PhD in Computer Science

MBA (general business)

Several insurance industry designations

Key Interests:

Data Modeling

Database Benchmarking

Database Tuning & Optimization

"Star Schema" Data Warehouses

Oracle on Linux – and specifically: RAC on Linux

Articles for:

  • Oracle’s Technology Network (OTN)
  • Oracle Magazine,
  • Oracle Informant
  • PC Week (eWeek)

Articles for:

  • Dell Power Solutions Magazine
  • The Linux Journal
  • www.linux.com
  • www.orafaq.com

2

books by bert
Books by Bert …

Coming in 2009 …

3

couple of questions
Couple of Questions…
  • How many people are doing Oracle on
    • VMware Server (freeware)
    • VMware Workstation 6.x
    • VMware ESXi (freeware)
    • VMware Infrastructure 3
    • Other Virtual Platforms
        • Virtual Box
        • Hyper Visor
        • Zen Server
        • Oracle VM Server
        • Sun xVM
agenda
Agenda

Discuss the Virtualization Trend

Challenge: Shared Resources

Used Quest Tools to Simplify & Maximize Results

  • Foglight for VMware
  • Foglight Database Performance Analysis
  • Benchmark Factory for Databases

440% Database Improvement on Same Hardware!

How is that possible – What Black Magic was used?

Result = Easy Best Practices for Oracle on VMware

the trend is clear
The Trend is Clear …

Virtualization is proliferating for many good reasons

Hardware new purchase costs continue to decrease

Hardware overall performance continues to increase

Database Administrators have been hesitant to date

But minimal virtualization overhead costs are quickly becoming much less of an issue, even for databases

In the near future, databases too will be the norm …

fundamental challenge understanding the impact of resource sharing
Fundamental ChallengeUnderstanding the impact of resource sharing

CPUMulti-Core Processors

Network

Shared Connectivity

Load Balancing

Redundancy

Core 4 Resources

Memory

Sharing

Over-commitment

Disk

Shared storageFiber, iSCSI, NAS

nothing new here
Nothing New Here …

DBA’s have always cared deeply about database server CPU, memory, disk and network utilization

But often in the past databases were on dedicated hardware – so databases were more “solo islands”

Now we must account for shared everything – and not just disk space as with SAN/NAS/iSCSi storage servers

We might even have different database platforms sharing our resources (e.g. Microsoft SQL Server)

some tools i used
Some Tools I used …

Not pitching or selling anything here – just disclosure

There are lot’s of good tools out there - pick whatever

In brief – here’s what I used and why (its purpose):

  • Load Generator = Benchmark Factory for Databases
  • Virtualization Monitor = Foglight for VMware
  • Database Performance = Foglight Database Performance Analysis
  • Database Ad-Hoc Diagnostics = Spotlight for Oracle
slide10

Foglight for VMware

Monitor Shared Resources

Find & Fix

Genuine VM

Performance Issues

Help to Squeeze

Maximum

“Overall”

Throughput

slide11

Foglight for Database Analysis

Monitor Database Resources

Find & Fix

Genuine DB

Performance Issues

Help to Squeeze

Maximum

“Database”

Throughput

slide12

Benchmark Factory for Databases

Generate Database Workload

Stress the

Database Introduce

Performance Issues

Help to Expose

Potential

Candidates

Each step above is an individual test for my proposed best practices – and their results

slide13

440% Improvement for Proper Setup

1080 ms

Average Response

Time

200 ms

Average Response

Time

the top ten tricks applied
The Top Ten Tricks Applied …

Obtain a baseline test for relative comparisons

On the VM host, exclude VM clients from active, online virus scans

Remove Windows Indexing Service (because really don’t need fast file system searches for an Oracle database)

Remove other extraneous Windows services (there are lots)

Change the VM host registry settings to improve file system IO for databases

Optimize the VM host configuration and options

Optimize the VM client OS configuration and options for Oracle database

Remove other extraneous VM client OS services and daemons

Change VM client file system settings to improve IO performance for databases

Adjust VM client file system block size to more closely match Oracle block size

optimize all file systems for database
Optimize All File Systems for Database …

From ten overall steps – focus on these two:

#5 = Change the VM host registry settings to improve file system IO for databases

#9 = Change VM client file system settings to improve IO performance for databases

For Windows, simply adjust the following registry entry:

HKEY_LOCAL_MACHINE\System\CurrentControlSet\ Control\FileSystem\NtfsDisableLastAccessUpdate = 1

Since we know that Oracle “touches” data files every three seconds or more – why track the “date/timestamp” of when each file was lasted touched – we don’t need it

let s not forget my favorite linux
Let’s not Forget My Favorite - Linux …

We can set the arrtibute for the individual Oracle files:

chattr +A file_name

Or we can do it for an entire directory:

chattr –R +A directory_name

However the best method (because it automatically

handles any file additions) is to edit the /etc/fstab and

add the NOATIME attribute:

/dev/sda6 / ext3 defaults,noatime 1 1

/dev/sda1 /boot ext2 defaults,noatime 1 2

/dev/cdrom /mnt/cdrom iso9660 noauto,owner,ro 0 0

/dev/sda5 swap swap defaults 0 0

match file system database block size
Match File System & Database Block Size …

From ten overall steps – focus on this one:

#10 = Adjust VM client file system block size to more closely match Oracle block size

Assume we have a Linux host running a Linux based Oracle database client.

Let’s examine Scenario #2 from the chart next page.

Start by assuming that the host file system using the default block size: 2K.

Further assume that the client file system also using the default block size: 2K.

But that the Oracle DBA sets the DB block size to 4K – so we have a mismatch.

Thus each Oracle physical IO requests asks the client OS for two IO’s,

and each client IO asks the host for one IO. That’s a total of four logical

IO requests (although only two physical IO’s in reality – but note that

there’s overhead for each logical IO request, so larger numbers are worse)

services services services
Services, Services, Services …

From ten overall steps – focus on this one:

#4 = Remove other extraneous Windows services (there are lots)

#8 = Remove other extraneous VM client OS services and daemons

This step is very, very subjective – do so with great care

Your situation & needs will dictate what can be turned off

No two scenarios will be 100% alike – so mileage will vary

Therefore take my next two slides with a “grain of salt” ….

lessons learned i e best practices
Lessons Learned (i.e. Best Practices)

Tons of “low hanging fruit” (i.e. easy no-brainer stuff)

Optimize each of the four major VM platform stacks

  • Optimize the Host Machine (BIOS too)
  • Optimize the Host VMware Setup
  • Optimize the Guest VM Configuration
  • Optimize the Guest Operating System

Remember: 440% improvement for practically free 

slide24

Questions and Answers …

Thank You

Presenter:

Bert Scalzo: Bert.Scalzo@Quest.com

Note: these slides should be available on OOUG web site, but we’ll also make sure to post them on our company’s web site:

www.toadworld.com/Experts/BertScalzosToadFanaticism/tabid/318/Default.aspx