Dell PowerEdge 2950 Deployment SQL Server 2008 x64 on Windows Server 2003 R2 Enterprise x64 PDF Installation Instructions Manual

The Dell™ PowerEdge™ 2950 is an excellent server for deploying SQL Server 2008 x64, the latest release of Microsoft’s highly available and high-performing data management platform. This Deployment Guide reviews the approach that Principled Technologies (PT) and Dell recommend for implementing a tested and validated solution for SQL Server 2008 x64 on the Dell PowerEdge 2950 9th generation server and Microsoft Windows
Server 2003 Enterprise R2 x64. PT has performed hands-on testing and research and drawn on real-world experiences to document best practices and help systems administrators and database administrators simplify operations and take advantage of new features in SQL Server 2008
x64.

New features of SQL Server 2008 x64
SQL Server 2008 x64 introduces a wide variety of new features. While there are far too many to discuss in this Guide, the following
list mentions some of the more significant ones:
• Policy-based management. SQL Server 2008 x64 lets you automatically enforce and monitor policies for database operations. You can also push these policies out to your servers.
• Resource Monitor. The Resource Monitor allows you to monitor which users are running which queries and how long those queries run. This ability helps you to better tune your server for optimal performance.
• Resource Governor. The Resource Governor lets you limit the resource consumption of incoming requests by classifying incoming connections as specific workload types and defining limits for those types. You can also redefine the limits in real time.
• Backup compression. SQL Server 2008 x64 can automatically compress database backups, a feature previously only available via the purchase of third-party software products.
• Performance data collection. SQL Server 2008 x64 lets you store performance data in a centralized database. It also provides enhanced tools for analyzing and reporting on such performance data.
• FILESTREAM data. The new SQL Server 2008 x64 FILESTREAM data type allows you to store large binary data, such as documents or images, directly in an NTFS file system. The data object remains part of the database and maintains transactional consistency. Applications can access
the data via an NTFS streaming API.
• “Hot add” CPUs. On supported hardware platforms you can now add one or more CPUs while SQL Server 2008 x64 is running. As with SQL Server 2005, you can also hot add memory.

Installing and setting up Windows Server 2003 R2 Enterprise x64 and SQL Server 2008 x64 in this environment In this section, we focus on installing and setting up Windows Server 2003 R2 Enterprise x64 and SQL Server 2008 x64 on the Dell PowerEdge 2950 server. We begin by defining the environment we used for our sample setup and then address configuring the server’s drives.

Defining our environment
BEST PRACTICE: Use the latest tested and validated software, firmware, and driver versions for NICs, storage arrays, and other components. You can find these software components in the Solutions Deliverable List (SDL) at Figure 1 presents the setup we used in our hands-on testing and
research for this Guide. The heart of the setup was a Dell PowerEdge 2950 with the following components:
• two Intel Xeon Processor E5335 (Clovertown) processors, each running at 2.0 GHz
• 16 GB of PC2-5300F RAM
• three 73.0 GB, 15,000 rpm, Seagate Cheetah ST373455SS SAS hard disks
• Dell PERC 5/i integrated RAID controller
• two Broadcom BCM5708C NetXtreme II GigE integrated NICs
We connected the server to an external Active Directory domain controller via a gigabit switch. We installed Windows Server 2003 R2 Enterprise x64 using the Dell OpenManage Server Assistant 8.10.0 from the Dell PowerEdge Installation and Server Management Bootable CD version 5.2. Then we applied Service Pack 2 before installing SQL Server 2008 x64. The version of SQL Server we used was the November Community
Technology Preview (CTP), which identified itself as: Microsoft SQL Server code name “Katmai” (CTP) – 10.0.1075.23 (X64) Nov 8 2007 14:13:37. This was the latest version of SQL Server 2008 x64 available as of the start of our work on this Guide.

Download Dell PowerEdge 2950 Deployment SQL Server 2008 x64 on Windows Server 2003 R2 Enterprise x64 PDF Installation Instructions Manual


Related E-Books:

    None Found

June 8, 2010 | Posted in Dell Manual, Server, Software

Comments

Leave a Reply