Dell R810 User Manual Page 1

SERVERS: DATABASE CONSOLIDATION ON DELL POWEREDGE R810 SERVERS *See hardware details on Page 3. A Principled Technologies report commissi

Servers: Database consolidation on Dell PowerEdge R810 servers 10 Our test bed setup On the HP ProLiant DL385 server running Windows Server 2003 R2

Servers: Database consolidation on Dell PowerEdge R810 servers 11 Figure 2. Consolidated SQL Server 2008 R2 instance layout for our testing. For

Servers: Database consolidation on Dell PowerEdge R810 servers 12 Our testing results As Figure 3 shows, we were able to run 24 SQL Server 2008 R2

Servers: Database consolidation on Dell PowerEdge R810 servers 13 As Figure 4 shows, the combined OPM of 24 SQL Server database workloads on the De

Servers: Database consolidation on Dell PowerEdge R810 servers 14 02,0004,0006,0008,00010,00012,00024 HP ProLiantDL385 solutions1 Dell PowerEdgeR81

Servers: Database consolidation on Dell PowerEdge R810 servers 15 Appendix B. Information to gather before consolidation includes the following: 

Servers: Database consolidation on Dell PowerEdge R810 servers 16 will be used strictly for iSCSI traffic. Use all three NICs on the Dell EqualLogi

Servers: Database consolidation on Dell PowerEdge R810 servers 17 Figure 6. SQL Server 2008 R2 Installation Center options. Proceed through the f

Servers: Database consolidation on Dell PowerEdge R810 servers 18 Figure 7. Choosing features for installation. On the first installation, choose

Servers: Database consolidation on Dell PowerEdge R810 servers 19 instance of the database engine, you need only check the Database Engine checkbox

Table of contents Executive summary ... 3 New Dell technology makes major savings easy ...

Servers: Database consolidation on Dell PowerEdge R810 servers 20 installation path, and click Next to begin the installation. Once you have insta

Servers: Database consolidation on Dell PowerEdge R810 servers 21 Provide proper authentication to SQL Server 2000, and select the database you wan

Servers: Database consolidation on Dell PowerEdge R810 servers 22 We performed all SQL Server 2000 administration using Query Analyzer and Enterpri

Servers: Database consolidation on Dell PowerEdge R810 servers 23 NOTE: If the time a full backup requires is unacceptable given your migration mai

Servers: Database consolidation on Dell PowerEdge R810 servers 24 take some extra steps to ensure a smooth migration for SQL Server logins. Below,

Servers: Database consolidation on Dell PowerEdge R810 servers 25 stored procedure, to view orphaned users and to map a user to a login. Appendix H

Servers: Database consolidation on Dell PowerEdge R810 servers 26 Appendix A. Return on investment This section estimates the return on investment

Servers: Database consolidation on Dell PowerEdge R810 servers 27 Power savings We measured power to the test servers and storage when idle and whi

Servers: Database consolidation on Dell PowerEdge R810 servers 28 Acquisition costs include the purchase price of the server and storage hardware f

Servers: Database consolidation on Dell PowerEdge R810 servers 29 Five benefits of the Dell PowerEdge R810 solution drive the cost savings for thi

Servers: Database consolidation on Dell PowerEdge R810 servers 3 Executive summary Advances in processor, server, and database technologies enable

Servers: Database consolidation on Dell PowerEdge R810 servers 30 Acquisition costs Figure 13 details the acquisition costs. Category Description D

Servers: Database consolidation on Dell PowerEdge R810 servers 31 Savings category Costs for 1 Dell PowerEdge R810 solution Costs for 24 HP ProLia

Servers: Database consolidation on Dell PowerEdge R810 servers 32 Assumptions We made many assumptions about the hypothetical enterprise that drive

Servers: Database consolidation on Dell PowerEdge R810 servers 33  The enterprise saved the cost of the freed up software assurance agreements. T

Servers: Database consolidation on Dell PowerEdge R810 servers 34 Appendix B. Example database survey In this appendix, we provide an example surv

Servers: Database consolidation on Dell PowerEdge R810 servers 35 4. Database level a. Database properties and options b. Recovery model, auto-shr

Servers: Database consolidation on Dell PowerEdge R810 servers 36 Appendix C. Preparing the storage For the testing we conducted for this Guide, we

Servers: Database consolidation on Dell PowerEdge R810 servers 37 the specifics on configuring the internal storage, and then connecting to the iSC

Servers: Database consolidation on Dell PowerEdge R810 servers 38 Appendix D. Installing SQL Server 2008 Install an instance of Microsoft SQL Serv

Servers: Database consolidation on Dell PowerEdge R810 servers 39 15. At the Server Configuration screen, choose the service account, preferably a

Servers: Database consolidation on Dell PowerEdge R810 servers 4 payback period of less than 12 months and a 3-year return on investment (ROI) of 2

Servers: Database consolidation on Dell PowerEdge R810 servers 40 Appendix E. Installing Upgrade Advisor In this example, we walk through the steps

Servers: Database consolidation on Dell PowerEdge R810 servers 41 10. On the SQL Server parameters screen, select one or more databases and, if yo

Servers: Database consolidation on Dell PowerEdge R810 servers 42 Appendix F. Migrating databases In this appendix, we give detailed instructions a

Servers: Database consolidation on Dell PowerEdge R810 servers 43 folder, and enter a filename, such as DatabaseNameMigrationBackup.bak. 13. Click

Servers: Database consolidation on Dell PowerEdge R810 servers 44 26. Click Add to add the backup file location. Browse to the appropriate folder,

Servers: Database consolidation on Dell PowerEdge R810 servers 45 Appendix G. Transferring Windows logins In this appendix, we provide detailed ins

Servers: Database consolidation on Dell PowerEdge R810 servers 46 Appendix H. Transferring SQL Server logins In this appendix, we give detailed ins

Servers: Database consolidation on Dell PowerEdge R810 servers 47 4. Enter the following command, and click Execute: EXEC sp_change_users_login

Servers: Database consolidation on Dell PowerEdge R810 servers 48 About Principled Technologies We provide industry-leading technology assessment

Servers: Database consolidation on Dell PowerEdge R810 servers 5 Intel Xeon Processor 7500 series to a new level of power and scalability. QuickPat

Servers: Database consolidation on Dell PowerEdge R810 servers 6 In this database-specific Guide, we address the consolidation of multiple stand-al

Servers: Database consolidation on Dell PowerEdge R810 servers 7 Among the characteristics to examine on each server are the following:  Process

Servers: Database consolidation on Dell PowerEdge R810 servers 8 Microsoft SQL Server 2000. We measured how many of those workloads the new Dell Po

Servers: Database consolidation on Dell PowerEdge R810 servers 9 Savings continue after the payback period. By the end of year one, we project savi