Consolidating multiple SQL Server systems onto
Dell PowerEdge R610 Servers using Microsoft’s Hyper-V
15
Getting ready
Evaluating your servers for virtualization and consolidation
You must be aware of many specific details related to each physical
server you target for consolidation, including the maintenance
window in which you migrate the server to a virtual environment,
the users the move affects, and the configuration tasks necessary
to assimilate the databases into your consolidated environment. A
more comprehensive example survey appears in Appendix A
.
Information to gather before consolidation may include the
following:
• Server OS version and patch level
• SQL Server version and patch level
• Number of logins on this SQL Server instance, and what
type of logins these are (Windows or SQL)
• Current backup strategy and schedule for the databases on
this server
• Replication details for this SQL instance, if any
• Detailed information regarding permissions and roles
• SQL Agent jobs on this SQL Server
Just as in a traditional migration, after moving your database to a
virtual machine, you must make sure that any system or
application using the database has updated connection information.
This includes logins, permissions, applications, SQL Agent jobs,
third-party backup solutions, and so on.
Gather baseline performance data
During your research phase, you should use Performance Monitor,
SQL Server Profiler, and other tools to gather data on the typical
query load and performance statistics on the database server you
are considering moving to a virtual environment. This practice
serves two purposes. First, it provides a prime opportunity to
Getting Ready
Preparing your
server
Creating
Virtual
Machines
Moving
databases to
Virtual
Machines
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commenti su questo manuale