Database Reference
In-Depth Information
Check the BIOS power management settings on all servers that may host a
database to ensure they are enabled for performance versus power savings. You
may use more energy but your database performance will improve.
As you can see, you have a lot to consider when configuring a virtualized environment
to optimally support a database.
DBAs' Top Reasons to Virtualize a Production Database
What DBAs like most about virtualization is the many service-level agreement
enhancements it makes possible. One customer I met with made an interesting
observation. They had gone down the path of virtualizing everything but their production
databases. They then noticed six months later the development and test databases had
more uptime than the production databases that the company ran its business on. This
was also noticed by the other stakeholders in the organization. Let's use
Figure 2.2
as a
high-level guide to the many reasons why, as a DBA, you would virtualize your
production databases.
Figure 2.2
Reasons to virtualize a production database.
