Solved

SQL Server 2005 on Win 2008 STD R2

Posted on 2012-03-27
3
416 Views
Last Modified: 2012-06-21
I am running SQL Server STD 2005 on a Win 2008 STD R2.

For SQL data - separate storage -  RAID 5 - where the RAID policy is set to Read Ahead.

When formatting the drive - what - Allocation Size Units is best recommended to get max performance for SQL.  Some sites say 4K while some say 64K - so how to pick what and when?


I have an an accounting system and a SharePoint database  using this SQL server. All databases files combined is about  >50GB


Thanks
0
Comment
Question by:3Musketeers
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 78

Expert Comment

by:arnold
ID: 37774631
Win2k8 has alignment of the partition.
In case of large files, you should use the higher value. If you are also using the pace for file sharing, you should use the 4k.
What is the write policy, write through or write back?
You are looking at individual files for unit allocation and not cumulative.
http://www.microsoft.com/download/en/details.aspx?id=21949
http://technet.microsoft.com/en-us/sqlserver/bb671245
http://sqlblog.com/blogs/greg_low/archive/2009/07/05/disk-partition-alignment-best-practices-for-sql-server-whitepaper.aspx
0
 

Author Comment

by:3Musketeers
ID: 37785026
write policy is write through
read policy is read ahead
on the RAID controller

will not be using the drive for sharing files at all...
0
 
LVL 78

Accepted Solution

by:
arnold earned 500 total points
ID: 37785496
If it only will have large files, you should use the larger allocation units.
If you have the time, you could format the storage in one way small allocation units
then use the sql storage testing tools
http://sqlserverio.com/2010/06/15/fundamentals-of-storage-testing-io-systems/
http://support.microsoft.com/kb/231619
http://sqlserverpedia.com/wiki/SAN_Performance_Tuning_with_SQLIO

You could use the simpler of the two to see the differences.
and then decide for yourself.

http://msdn.microsoft.com/en-us/library/dd758814%28v=sql.100%29.aspx
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever notice how you can't use a new drive in Windows without having Windows assigning a Disk Signature?  Ever have a signature collision problem (especially with Virtual Machines?)  This article is intended to help you understand what's going on and…
A safe way to clean winsxs folder from your windows server 2008 R2 editions
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question