Question

Locked

Disk Geometry

By SysAdminII ·
I have been doing some reading on Disk Geometry and how aligning your disk can enahnce performance 20-30%. Most of the articles tell you to contact your hardware vendor before performing this task but most of the articles I see also relate to Exchange Servers. My question concerns SQL 2000 and SQL 2005. I was curious what kind of performance increase would occur if you performed the Diskpart or Diskpar on a Windows 2003 Server with SQL 2000 or 2005 and what the benefit might be, if there is any. I know we have a ton of I/O's, being that we capture real time data, so I was curious if it might be beneficial to perform the dispart on any new boxes that I create? Any ideas or comments would be apprecitated.

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Diskpar and SQL

by gsquared In reply to Disk Geometry

I didn't find anything specifically on SQL Server and Diskpar(t), but I have seen some general database data on the subject. For example, http://techrepublic.com.com/5218-6230-0.html?forumID=101&threadID=203885&messageID=2120442, which states that best performance on these particular disks works if you use a 128 offset, for Exchange or SQL.

Since the use of offset is to avoid multiple IO operations, it seems to me that it could make a difference in SQL performance. I haven't tested it, but it seems to make sense.

Back to Networks Forum
2 total posts (Page 1 of 1)  

Hardware Forums