<div>
Ours is 122GB.<br />
<br />
Vaidas911, did you do it on W 2003 Server?<br />
<br />
I thought ours was 32KB, but the it is only 31.5K of metadata.
</div>


Ours is 122GB.

Vaidas911, did you do it on W 2003 Server?

I thought ours was 32KB, but the it is only 31.5K of metadata.

<div>
Ours also W 2003 Server, and yes, 31.5K is standart.
</div>


Ours also W 2003 Server, and yes, 31.5K is standart.

<div>
tiago_aviz, it is just not about the stripe size, but &nbsp;if it will lead to 2 IO ops instead of 1.<br />
<br />
We have 100 spindles underneath our LAN, but still the Disk IO has remained the same..
</div>


tiago_aviz, it is just not about the stripe size, but  if it will lead to 2 IO ops instead of 1.

We have 100 spindles underneath our LAN, but still the Disk IO has remained the same..

<div>
Vaidas911, perhaps you should have gone higher than 64k?
</div>


Vaidas911, perhaps you should have gone higher than 64k?

<div>
<div class="content wysiwyg-content">
KevinK recommends for SQL on Windows Server 2003 &nbsp;to have 64K sector offset for the Data drives.<br />
<br />
<a href="http://sqlblog.com/blogs/kevin_kline/archive/2008/10/06/how-to-improve-application-and-database-performance-up-to-40-in-one-easy-step.aspx" rel="ugc">http://sqlblog.com/blogs/kevin_kline/archive/2008/10/06/how-to-improve-application-and-database-performance-up-to-40-in-one-easy-step.aspx</a><br />
<br />
Ours has 32K as the Starting Offset. Since 64K is multiples of 32K, will that be ok, or is it recommended to change it to 64KB.<br />
<br />
thanks
</div>
</div>


KevinK recommends for SQL on Windows Server 2003  to have 64K sector offset for the Data drives.

http://sqlblog.com/blogs/kevin_kline/archive/2008/10/06/how-to-improve-application-and-database-performance-up-to-40-in-one-easy-step.aspx

Ours has 32K as the Starting Offset. Since 64K is multiples of 32K, will that be ok, or is it recommended to change it to 64KB.

thanks

disk alignment partitioning for SQL performance

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Computer data storage, often called storage or memory, is a technology consisting of computer components and recording media used to retain digital data. In addition to local storage devices like CD and DVD readers, hard drives and flash drives, solid state drives can hold enormous amounts of data in a very small device. Cloud services and other new forms of remote storage also add to the capacity of devices and their ability to access more data without building additional data storage into a device.

Storage

Windows Server 2003 was based on Windows XP and was released in four editions: Web, Standard, Enterprise and Datacenter. It also had derivative versions for clusters, storage and Microsoft’s Small Business Server. Important upgrades included integrating Internet Information Services (IIS), improvements to Active Directory (AD) and Group Policy (GP), and the migration to Automated System Recovery (ASR).