Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2006
    Posts
    104

    Unanswered: Virtualisation and db2 8.2 performance

    Hi,
    Currently we run our production databases on Windows 2000 cluster. The tablespaces and logs are on SAN. Db2 version is 8.2.6.

    There is a push from data center management to virtualise all our servers. That means our porduction databases will soon be running in Virtual Machine with identical specifications as our current db production server.

    we will be using VMWARE for virtualisation.

    Is there any feedback good/bad on DB2 Performance on virtual servers? Anyhting to watch-out for in VM configurations?



    Thanks in advance

    Harikumar

  2. #2
    Join Date
    Mar 2006
    Posts
    104
    Hi,

    I am re-posting - hoping to get some reponses in new year

    Harikumar

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by sundaram
    our porduction databases will soon be running in Virtual Machine
    Generally speaking, it is a very bad idea. There are two things to which DBMSes are very sensitive: memory and disk I/O. Virtualizing both (or either) means that DB2 will not be in control of physical memory or disk access, and all assumptions it makes for query optimization may be wrong at random. For example, DB2 may think that a table scan with a large available (but virtual) bufferpool and efficient prefetch from a (virtual) disk might be the best strategy for a certain query, while the hypervisor decides that it needs to page out half of the DB2 VM virtual memory to make room for another virtual machine, and the DB2 containers share the physical storage with Windows registry database...

    In other words, virtualizing database servers might be acceptable in development or functional test environments, but never in production.
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •