Have a Wetpaint account? Sign in
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.
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.
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 ArchitectureThis 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
TDA-Terry |
Latest page update: made by TDA-Terry
, Feb 25 2009, 8:13 PM EST
(about this update
About This Update
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?
Keyword tags:
diskpart Partition Alignment
|
|||||
| 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
|
|||||
| brian_summers | Script (or atleast dictate) a unique path for log files? | 7 | Jan 28 2008, 5:20 PM EST by todd_muirhead | ||
 |
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
|
||||
Showing 3 of 3 threads for this page
