Already a member?
Sign in
Welcome! This is a website that everyone can build together. It's easy!
Dell SQL Server 2005 Reference Architecture
This is the wiki home for the Dell SQL Server 2005 Reference Architecture whitepaper where you can download the whitepaper as well as contribute to the discussion about it below in the discussion threads section.
Figure 1 - Architectural Overview of Dell SQL Server 2005 Reference Architecture
The layout of disks into different LUNs is also covered in the whitepaper. An example is given of how to a disk enclosure might be organized to support SQL 2005 in the following diagram.
Figure 2 - Seperation of Disk Groups and Virtual Disks within a PowerVault MD3000 Storage Array for TempDB, Transaction Logs, and Data.
The reference architecture includes detailed configuration information. The following diagrams from the paper shows how the MD3000 disk partitions need to be aligned. For details on how to configure the allignment - please see the full paper.
Misalingned Disk Partition:
Aligned Disk Partition:
Figure 3 - Misaligned and Aligned Disk Partitions on MD3000 for SQL Server 2005
The paper also includes the diagram below to explain virtual disk to partition mapping and configuration with the specific example of the two-socket, dual-core Dell PowerEdge 2950 server.
Figure 4 - Virtual Disk to Partition Mapping and Configuration for a Dual-Core Two-socket PowerEdge server hosting SQL Server 2005.
Download the complete paper here.
Discuss and Comment Below
Whitepaper Summary
Dell™ PowerEdge™ servers and Dell™ PowerVault™ storage systems are ideal choices to deploy highly reliable and sustainable Microsoft® SQL Server™ 2005 databases. This reference Architecture white paper is intended to help IT professionals design and configure SQL Server 2005 database solutions using Dell servers and storage that apply “best practices” derived from laboratory and real-world experiences. This white paper documents Dell’s recommended approach for implementing a tested and validated solution for SQL Server 2005 SP2 database on Dell PowerEdge 9th generation servers, Dell PowerVault MD3000 SAS storage enclosures and Microsoft Windows Server 2003 Standard Edition with SP2. Download the complete paper for details.Whitepaper Highlights
The following highlights are from the reference architecture paper.Figure 1 - Architectural Overview of Dell SQL Server 2005 Reference Architecture
The layout of disks into different LUNs is also covered in the whitepaper. An example is given of how to a disk enclosure might be organized to support SQL 2005 in the following diagram.
Figure 2 - Seperation of Disk Groups and Virtual Disks within a PowerVault MD3000 Storage Array for TempDB, Transaction Logs, and Data.
The reference architecture includes detailed configuration information. The following diagrams from the paper shows how the MD3000 disk partitions need to be aligned. For details on how to configure the allignment - please see the full paper.
Misalingned Disk Partition:
Aligned Disk Partition:
Figure 3 - Misaligned and Aligned Disk Partitions on MD3000 for SQL Server 2005
The paper also includes the diagram below to explain virtual disk to partition mapping and configuration with the specific example of the two-socket, dual-core Dell PowerEdge 2950 server.
Figure 4 - Virtual Disk to Partition Mapping and Configuration for a Dual-Core Two-socket PowerEdge server hosting SQL Server 2005.
Download the complete paper here.
Discuss and Comment Below
Latest page update: made by todd_muirhead
, Dec 14 2007, 2:21 PM EST
(about this update
About This Update
Edited by todd_muirhead
1 word added
2 words deleted
view changes
- complete history)
Edited by todd_muirhead
1 word added
2 words deleted
view changes
- complete history)
Keyword tags:
None
More Info: links to this page
