Best practices for IDS on virtual machine?

- IBM's Hypervisor has the lowest overhead and highest IO rates. - If you must use VMWare make sure you are using the vSphere hypervisor, it's IO is about double the older hypervisors from VMWare or running without one. - Yes RAID10. - As much as possible make sure you do not have competition for the physical disks underneath your LUNS, ESPECIALLY not Windows Filesystems and NEVER email stores. The access patterns are just too different from database access patterns. - EXT2 with DIRECT_IO, yes. - Yes to separate dbspaces for high access data like rootdb, logical logs, physical logs, high access tables and indexes. Informix assigns IO resources per dbspace and per chunk depending on specifics. More dbspaces and more chunks can lead to more total IO throughput. Keeping logical logs on different LUNs from physical logs and from high IO data dbspaces will take advantage of more physical resources like IO channels and spindles. Apologies for the previous mispost, Moderators please delete. I notice that you recommend ext2 with DIRECT_IO. Is this to avoid the journaling overhead of ext3? Is there a substantial performance boost in switching to ext2? Is JFS or Reiserfs better for this. I take it that the Plog and Llog should remove the need for the journal in ext3.