Dell PowerEdge R910 Informations techniques

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

Servers: Database consolidation on Dell PowerEdge R910 servers 10 The Dell PowerEdge R910 solution uses a little less than 1/12th the power, 1/48th

Servers: Database consolidation on Dell PowerEdge R910 servers 11 which we report in this Guide. For more details about the DS2 tool, see http://ww

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

Servers: Database consolidation on Dell PowerEdge R910 servers 13 greater than the HP ProLiant DL385 solution’s orders per minute score. The averag

Servers: Database consolidation on Dell PowerEdge R910 servers 14 0100,000200,000300,000400,000HP ProLiantDL385solutionDell PowerEdgeR910solutionOP

Servers: Database consolidation on Dell PowerEdge R910 servers 15 05,00010,00015,00020,00025,00048 HP ProLiantDL385 solutions1 Dell PowerEdgeR910

Servers: Database consolidation on Dell PowerEdge R910 servers 16  Number of logins on this SQL Server instance, and what type of logins these ar

Servers: Database consolidation on Dell PowerEdge R910 servers 17 Installing SQL Server 2008 For this Guide, we assume that Windows Server 2008 R2

Servers: Database consolidation on Dell PowerEdge R910 servers 18 options specified. On the Setup Role screen, choose a SQL Server Feature Installa

Servers: Database consolidation on Dell PowerEdge R910 servers 19 To install one or more named instances, as we did for our testing, follow the sam

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

Servers: Database consolidation on Dell PowerEdge R910 servers 20 2. Click Next to begin the installation wizard, accept the licensing terms, and

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

Servers: Database consolidation on Dell PowerEdge R910 servers 22 administration for the SQL Server 2008 R2 installation using SQL Server Managemen

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

Servers: Database consolidation on Dell PowerEdge R910 servers 24 Below, we describe how to script both Windows authenticated logins and SQL Server

Servers: Database consolidation on Dell PowerEdge R910 servers 25 SQL Server Agent jobs Almost all installations schedule SQL Server Agent jobs tha

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

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

Servers: Database consolidation on Dell PowerEdge R910 servers 28 offsetting its acquisition costs by major savings in operating costs and delivere

Servers: Database consolidation on Dell PowerEdge R910 servers 29 Figure 12. Estimated 3-year costs for the 48 HP ProLiant DL385 solutions and a si

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

Servers: Database consolidation on Dell PowerEdge R910 servers 30 Acquisition costs Figure 13 details the acquisition costs for the Dell PowerEdge

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

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

Servers: Database consolidation on Dell PowerEdge R910 servers 33 purchasing one license and software assurance agreement for each processor.  Th

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

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

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

Servers: Database consolidation on Dell PowerEdge R910 servers 37 5. Highlighting the new virtual disk, press F2, Initialization, and Start Init.

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

Servers: Database consolidation on Dell PowerEdge R910 servers 39 Active Directory domain accounts in your SQL Server environment, then choose Wind

Servers: Database consolidation on Dell PowerEdge R910 servers 4 and decreases power consumption by over 91.5 percent. The result is an estimated p

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

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

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

Servers: Database consolidation on Dell PowerEdge R910 servers 43 and enter a filename, such as DatabaseNameMigrationBackup.bak. 13. Click OK to cl

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

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

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

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

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

Servers: Database consolidation on Dell PowerEdge R910 servers 5 the expansion from two-socket (2S) to four-socket (4S) platforms, elevates the Int

Servers: Database consolidation on Dell PowerEdge R910 servers 6 Features of Microsoft SQL Server 2008 R2 SQL Server 2008 R2 is the latest release

Servers: Database consolidation on Dell PowerEdge R910 servers 7 hardware utilization—all while maintaining the previous level of application perfo

Servers: Database consolidation on Dell PowerEdge R910 servers 8  Types and rates of transactions against the databases The server you select fo

Servers: Database consolidation on Dell PowerEdge R910 servers 9 This consolidation could deliver payback in less than 6 months and an ROI of 439 p