Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL Server 2005 on Win 2008 STD R2

Posted on 2012-03-27
3
Medium Priority
?
431 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 79

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 79

Accepted Solution

by:
arnold earned 2000 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

670 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