Dell R810 - Manual (Page 34)

Servers: Database consolidation on Dell PowerEdge R810 servers
34
Appendix B. 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’re 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
i. Total quantity in GB
ii. Memory speed
c. Storage
i. Quantity, both current and projected growth.
ii. Disk speed
iii. Repository type (Fibre Channel SAN, iSCSI SAN,
SCSI direct-attached)
iv. 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 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 (i.e., is it the default 1433 or another
port? If a named instance, what is the port?)
e. Communication protocol (named pipes or TCP/IP?)
f. Service account and all service permission information
(does SQL Agent run under a different service account?)
g. Are there any non-default master or model database
objects?
h. Are there any linked server objects?
i. Are other SQL modules involved or dependent on this
instance (e.g., Analysis Services, Reporting Services, etc.)?
j. Default installation directories, data directories, and log
directories
k. Tempdb – highly volatile? Slightly volatile? Medium usage?