.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Confused about Disk Alignment/ Partition Offset

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
I am all confused by disk alignment, partiton offset.Why do we need to calcualte offset which most of the articles talk about, This is from White Paper  Disk Partition Alignment Best Practices for SQL Server where its stressed that Partition_Offset ÷ Stripe_Unit_Size-- should be an integer 'The performance question here is usually not one of correlation per the formula, but whether the cluster size is the NTFS default of 4,096 bytes or has been explicitly defined at 64 KB, which is a best practice for SQL Server.' Also how do we calculate Stripe Unit Size for SAN. Thanks all for your replies !!  

View Complete Post

More Related Resource Links

Disk Partition Alignment SQL 2005 on Win 2008


Needed some help for Win 2008.


Gives info about disk partition alignment. It states that Win 2008 'ATTEMPTS' to get the partition aligned for us.

If I run,

fsutil fsinfo ntfsinfo e:

on our Win 2008 server, it still gives the partition as 8KB. Do, we need to change it to 64KB?

Using DISKPART for disk alignment and understanding the output


I understand that in 2008 server it'll align the disks for you automatically.  I've run the following commands on another one of my DB servers and the offset was 1024 on all of them.  I get the following from my other DB server and it doesn't list the alignment on every partition save the first one.

DISKPART> select disk 0

Disk 0 is now the selected disk.

DISKPART> list partition

  Partition ###  Type              Size     Offset
  -------------  ----------------  -------  -------
  Partition 1    Primary            100 MB  1024 KB
  Partition 2    Primary             39 GB   101 MB

DISKPART> select disk 1

Disk 1 is now the selected disk.

DISKPART> list partition

  Partition ###  Type              Size     Offset
  -------------  ----------------  -------  -------<

disk alignment question!


Brand new sql cluster installation, setting up the disks.

Windows 2008 R2

SQL 2008 Enterprise

Dell 610 x2 (active/passive cluster)

Dell Powervault SAN - 8x450GB 15k SAS - RAID5

OLTP system with pretty even read/write ops

How do these number below look?

128KB stripe size

64KB cluster size

1024KB offset

Are my alignments correct? Should my stripe size be bigger since 8 disks? I am new to this and still don't quite understand the formulas.


file upload in chunks or not buffering in memory before writing to disk?


What are the options for handling file uploads to reduce the memory footprint?  Is there a way to upload in chunks?  Is there a way to stream upload directly to disk instead of loading entire file in server memory?


center alignment of web page


Hiiii Coders,

I have build a website . Now what i want is that it should be centralized according to resolution i.e.. on increasing resolution its margin from both sides should be equal.

Remember I have completely done with my website.

How can i get it done

plz provide some code snippet

thanx and regards 

Windows With C++: The Virtual Disk API In Windows 7


This month we look inside the Windows 7 beta to examine the Virtual Disk API and the Microsoft Virtual Hard Disk (VHD) format.

Kenny Kerr

MSDN Magazine April 2009

Formview + EditItemTemplate + Bind + PageLoad + Prerender = Confused


I am working with a formview edititemtemplate.  Currently in my page load, i have some stuff that would show or hide certain panels based on dropdownlist values.  These dropdown values get binded during page load.  I need to be able to change the values/dropdowns, without rebinding the old data, and updating the visibility of the panels based on predefined rules.

I have experimented with putting my formview.databind() in page load if isnotpostback, in prerender, in prerender if isnotpostback.   I have tried my rules (ex if ddlState.selectedvalue = "DE" then pnlDelaware.visible = "true") in the page load, and the page render.   I'm just not sure how to get the stars aligned here.

The closest i have come is having the databind in the pageload if notispostback, and the rules in the prerender.   However I get an error "dropdownlist has a SelectedValue which is invalid because it does not exist in the list of items.


How to change The DateTime Automatically according to User TimeZone Offset?

I have an application in which we are displaying DateTime in many pages. we want to display these DateTime's according to UserTime zone. UserTimeZone will be in database. All DateTime values will be saved int UTC format. My Requirement is I want set the TimeZoneOffset of user in ServerSide based on the User TimeZoneOffset All the DateTime values needs to be Added/Substracted while showing the DateTime values to user. I dont want to manully add/substract TimeZoneOffset value in all pages. Is there any way the DateTime  automatically change to the User Timezone.  How can I do this? Thanks in Advance ChellamNaidu

Partition Query

Hi All, I have cube with 10 partition ,i want to process only last partition with with last 30 days . Now i want to know when i processed this partition of 30 days whether data of 30 days updated or get added with the existing one ...if getdate-1 havunf value 10 in column a before 30 days partition will become 20 after i process only 30 days partition alone   Kindly suggest Amit

how to change a remote partition into local partition

Our production cube is very huge and the process time is very long (10+ hours), and the data volume is still increasing. Since we have some idle server during cube process period, I'd like to try to put some partitions on the idle server to cut the process time. But I also want to bring these remote partitions back to local after the process is completed. Is it possible to change partition from remote to local? if so, how?

ROW_NUMBER() OVER - PARTITION BY should be different from ORDER BY

I have noticed incorrect usage for OVER - PARTITION BY - ORDER BY with same (BY) column lists, making the query nondeterministic as far as the generated ROW_NUMBER() is concerned.  If random sort needed, use NEWID() instead. Demo follows. -- WRONG PARTITION BY ... ORDER BY ... usage - nondeterministic sort SELECT ProductName = Name, Color, PartRowID = ROW_NUMBER() OVER(PARTITION BY Color ORDER BY Color) FROM AdventureWorks2008.Production.Product WHERE Color IS NOT NULL ORDER BY Color, PartRowID /* ProductName Color PartRowID .... Men's Bib-Shorts, L Multi 3 AWC Logo Cap Multi 4 Long-Sleeve Logo Jersey, S Multi 5 .... */ -- CORRECT PARTITION BY ... ORDER BY ... usage - UNIQUE sort (Name is unique) SELECT ProductName = Name, Color, PartRowID = ROW_NUMBER() OVER(PARTITION BY Color ORDER BY Name) FROM AdventureWorks2008.Production.Product WHERE Color IS NOT NULL ORDER BY Color, PartRowID /* ProductName Color PartRowID .... Long-Sleeve Logo Jersey, M Multi 3 Long-Sleeve Logo Jersey, S Multi 4 Long-Sleeve Logo Jersey, XL Multi 5 Men's Bib-Shorts, L Multi 6 .... */ Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM

System.Data.SqlClient.SqlError: There is insufficient free space on disk volume 'C:\' to create th

I received the following error...*****System.Data.SqlClient.SqlError: There is insufficient free space on disk volume 'C:\' to create the database. The database requires 2739929088 additional free bytes, while only 801185792 bytes are available. (Microsoft.SqlServer.Smo)*****I have looked at the solution recommended on this forum http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=79848 but I am still baffled as to why it says that I don't have enough disk space?  I ran the RESTORE FILELISTONLY command and it told me that the "size" was 1.4 GB and I've got 60GB left. I am starting to resolve that my .BAK is corrupt.  Are there any other reasons as to why I am unable to restore my backup?Thanks for any help in advance!

MDW Disk Usage for Database Report Error - A data source has not been supplied for the data source D

Hello, On the MDW Disk Usage Collection Set report, I get the following error when I click on a database hyperlink. A data source has not been supplied for the data source DS_TraceEvents SQL profiler shows the following SQL statements are executed (I've replaced the database name with databaseX) 1. exec sp_executesql N'SELECT dtb.name AS [Name] FROM master.sys.databases AS dtb WHERE (dtb.name=@_msparam_0)',N'@_msparam_0 nvarchar(4000)',@_msparam_0=N'databaseX' this returns zero rows as databaseX does not exist on my MDW central server, but is a database on a target server (i.e. one that is being monitored and uploaded into the MDW central server). 2. USE [datatbaseX] this produces the following error: Msg 911, Level 16, State 1, Line 1 Database 'databaseX' does not exist. Make sure that the name is entered correctly. why is the report looking for the database on my server? thanks Jag Environment: MDW (Management Data Warehouse) on SQL 2008 R2  

How large do you make your MSDTC Physical Disk Resource?

MSDTC requires a physical disk resource for the 4mb log it uses.  How large do you typically make the disk used as the MSDTC Physical Disk resource?  I don't know if there is a need to go beyond 4MB.  I'm guessing 100MB is a safe number.  Do you agree? Thanks,    Dave

Disk Stripe Width

Since SQL Server uses 64K pages, isn't it MORE advantageous to use a larger stripe width, say, 1MB?  This would allow for multi-page reads. Doc  

gridview table alignment problem

hi all, i designed a gridiview, within that ItemTemplate i drew an table then tr then some of td's, now the problem is after every row im getting one empty row, what is the problem and how to resolve it. below is my code <ItemTemplate>                                             <table cellspacing="0" cellpadding="0" style="border-right:1px solid Black;" >                                                 <tr  >                                                     <td width="1%" align="center" style="border-right:1px solid Black;">          &n

IS There is any way out to process only one partition of cube and data of other partition remain ava

HI ALL. Please let me know is there is any way out to process one partition only,while data of other partition remain available in the cube with the help of SSIS
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend