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
Solved

SQL Server 2005 on Win 2008 STD R2

Posted on 2012-03-27
3
411 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
  • 2
3 Comments
 
LVL 77

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 77

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
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…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

791 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