
27
Migrating to a Dell PowerEdge R515 server from two legacy database servers
APPENDIX A – EXAMPLE DATABASE SURVEY
In this appendix, we provide an example survey of detailed
information you may want to gather about the SQL Server instances
and databases you are targeting for consolidation. While this survey is
a good starting point, it may not contain every relevant detail for your
particular environment.
1. Hardware level
a. CPU
i. Vendor
ii. Model
iii. Number of cores per socket
b. Memory
iv. Total quantity in GB
v. Memory speed
c. Storage
vi. Quantity, both current and projected growth
vii. Disk speed
viii. Repository type (Fibre Channel SAN, iSCSI SAN, SCSI
direct-attached)
ix. Disk interface (SCSI, SAS, etc.)
2. OS level
a. Server name
b. IP address, subnet, etc.
c. Domain information
d. Operating system version, build number, and service pack
e. Drive letter information and layout
3. SQL Server instance level
a. Whether it’s clustered, version, edition (Workgroup,
Standard, Enterprise), 64-bit or 32-bit (and if 32-bit, with
or without AWE), and service pack level
b. Authentication mode (Windows only or Mixed Mode)
c. Instance name (if not a default instance)
d. SQL port number (e.g., is it the default 1433 or another
port? If a named instance, what is the port?)
e. Communication protocol (named pipes or TCP/IP)
Komentarze do niniejszej Instrukcji