Dell R810 - Manual (Page 19)

Servers: Database consolidation on Dell PowerEdge R810 servers
19
instance of the database engine, you need only check the Database
Engine checkbox. The instances share the workstation components,
so you don’t need to install those components a second time.
The second and more important change in the installation
procedure for a named instance is on the Instance Configuration
screen. Here you must choose the Named Instance option and
supply a name for the instance. Organizations typically have
naming conventions for instances that make instance management
easier, so follow those rules when naming this instance.
We show you how: Making the move
Upgrade Advisor makes it easy
The SQL Server 2008 R2 Upgrade Advisor is a major aid in
migration research. This utility, which the SQL Server 2008 R2
setup wizard includes, scans legacy databases and SQL Server
components for compatibility issues, features, and syntax the
newer DBMS does not support, as well as many other critical
components. The utility lets you view reports quickly in the
Upgrade Advisor interface or save reports for later review.
You can install and execute the Upgrade Advisor on machines
running Windows XP SP3, Windows Vista
® SP1, Windows Server
2003 SP2, or Windows Server 2008. The Microsoft .NET TM
framework is also a requirement.
BEST PRACTICE: Use the Upgrade Advisor tool on your
SQL Server 2000 database and import a trace file to the
Upgrade Advisor tool for analysis. The trace file lets the
Upgrade Advisor detect issues that might not show up in a
simple scan of the database, such as TSQL embedded in
applications. Your migration research and planning must
account for such instances. You can capture traces of TSQL
using SQL Server Profiler on your SQL Server 2000 server
during typical hours and analyze these traces using the
Upgrade Advisor.
To install the Upgrade Advisor, use the following steps:
1. Insert the SQL Server 2008 R2 DVD. On the
splash screen, click Install SQL Server Upgrade
Advisor.
Click Next to begin the installation wizard, accept the
licensing terms, and click Next.
Click Next to accept the default Registration
information, click Next to accept the default