Dell PowerEdge R810 Manual 

Also see for PowerEdge R810: Manual Owner's manual Technical guide Update Information update

Dell PowerEdge R810 Manual  Manual pdf 15 page image

Servers: Database consolidation on Dell PowerEdge R810 servers15Appendix B. Information to gather before consolidation includes thefollowing: Server OS version and patch level SQL Server version and patch level Number of logins on this SQL Server instance, and whattype of logins these are (Windows or SQL) Current backup strategy and schedule for the databases onthis server Replication details for this SQL instance, if any Detailed information regarding permissions and roles SQL Agent jobs on this SQL ServerAfter moving your databases to their new SQL Server instance, youmust make sure that any system or application using the databasehas updated connection information. This includes logins,permissions, applications, SQL Agent jobs, third-party backupproducts, and so on.Gathering baseline performance dataDuring your research phase, you should use Performance Monitor,SQL Server Profiler, and other tools to gather data on the typicalquery load and performance statistics on the databases you areconsidering moving to the new environment. This effort serves twopurposes. First, it provides a prime opportunity to identify potentialproblems before you move to a consolidated solution. Second, youcan use the information you gather to map out your resourceallocation needs, which you can then use to configure your newinstances, either by using memory allocations, CPU affinity, orResource Governor settings.Configuring your storageIn our test bed, we used two Dell EqualLogic PS5000XV iSCSI SANarrays. This section provides an overview of the Dell EqualLogicPS5000XV configuration process when used in conjunction with theDell PowerEdge R810. Appendix C provides complete, detailedinstallation instructions.Power on the Dell EqualLogic PS5000XV array, andlog in via the serial console. Proceed through theinitialization wizard steps, assigning a groupname and member name, and configuring the IPaddress for the first NIC, eth0. If this array hasbeen previously used, you can reset the array tofactory defaults by issuing the ―reset‖ command.Connect the Dell EqualLogic PS5000XV array andDell PowerEdge R810 to the gigabit switch that