Networks

Ask something
Question Locked

Disk Geometry

0 helpful
2 replies

by sysadminii 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.

2 replies

by gsquared

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, https://www.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.

This discussion is closed to new replies.