Microsoft SQL Server

Dell and Microsoft have worked closely on SQL Server solutions. This section of the wiki is dedicated to providing information about SQL Server on Dell solutions. Use the discussion threads at the bottom of the pages to ask questions and post comments.

Microsoft SQL Server Quick Links

Microsoft SQL Server White Papers Validated Configurations
Dell SQL Server Reference Architecture Business Continuity Strategy

Featured White Paper

Dell SQL Server 2005 Reference Architecture
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.

Related Links





No user avatar
TDA-Terry
Latest page update: made by TDA-Terry , Feb 25 2009, 8:13 PM EST (about this update About This Update TDA-Terry Edited by TDA-Terry

6 words added
2 words deleted

view changes

- complete history)
Keyword tags: database sql server
More Info: links to this page
Started By Thread Subject Replies Last Post
boberoi diskpart - Disk Alignment 5 Sep 17 2008, 9:41 PM EDT by brian_summers
Thread started: Sep 17 2008, 12:15 PM EDT  Watch
Hi,

Referencing the Dell SQL Server Reference Architecture whitepaper above.
I just installed a SQL Server box (Dell 2950 with 8 internal 2.5 inch 146k 10k SAS drives) with the following Raid Partitions:

Disk 0 (Drives 1&2) - OS and tempdb - Raid 0
Disk 1(Drives 3&4) - Logs - Raid 1
Disk 2(Drives 5 to 8) - Database - Raid 10

Do I need to use Diskpart on any of the drives and if so which ones.

The command for diskpart is:

Create partition primary align=1024

What number should I use for align?

I want to know where to get the info for the following formula:

((Partition offset) * (Disk sector size)) / (Stripe unit size)

What Partition offset should I use. Also when formatting the drives with NTFS what Allocation unit size should I use.

Thanks

Bunti


2  out of 2 found this valuable. Do you?    
Show Last Reply
mprest SQL 2008 Filestream 2 Mar 29 2008, 5:48 AM EDT by brian_summers
Thread started: Mar 26 2008, 10:08 AM EDT  Watch
Has anyone worked with SQL 2008 Filestream yet? We're working on a web-based filestream project where we'd use Poweredge servers and a PowerVault MD3000i. Once the MD3000i was full we'd start adding more. Thanks.
1  out of 1 found this valuable. Do you?    
Keyword tags: database sql server
Show Last Reply
brian_summers Script (or atleast dictate) a unique path for log files? 7 Jan 28 2008, 5:20 PM EST by todd_muirhead
brian_summers
Thread started: Dec 29 2007, 1:57 AM EST  Watch
Is it possible to script (or atleast dictate) a unique path for log files when installing a SQL instance?
I have a customer that is asking.

He is able to manually change the directory path for log files after installing, but he's looking to automate the install process.
Any ideas?

Brian
1  out of 1 found this valuable. Do you?    
Keyword tags: database sql server
Show Last Reply
Showing 3 of 3 threads for this page

Related Content

  (what's this?Related ContentThanks to keyword tags, links to related pages and threads are added to the bottom of your pages. Up to 15 links are shown, determined by matching tags and by how recently the content was updated; keeping the most current at the top. Share your feedback on Wetpaint Central.)