Bob Dorr - Principal SQL Server Escalation Engineer – submitted a blog about the new Advanced Format Technology for disk drives a few days ago that’s worth reading.  I anticipate that there will be a lot of information in the coming weeks on how SQL Server works with the new standard for hard drive sectors.  Check out his blog, and do some searches on 512e and Advanced Format Sector sizes as he suggests…I found pretty interesting reading.

Kinda makes me want to go out and buy one of the new drives and do some testing on this.

Lee Everest

 

------------------

 

 

 

 

http://blogs.msdn.com/b/psssql/archive/2011/01/13/sql-server-new-drives-use-4k-sector-size.aspx

http://www.wdc.com/wdproducts/library/whitepapers/eng/2579-771430.pdf


Posted in: SQL Server Performance  Tags:
blog comments powered by Disqus

by Lee Everest, M.S.

Info

Poll

Do you use Azure or cloud in your organization?



Show Results

Ads

Search


Month List

Calendar

«  May 2012  »
MoTuWeThFrSaSu
30123456
78910111213
14151617181920
21222324252627
28293031123
45678910
View posts in large calendar

Tags

Disclaimer
The opinions, code, examples, et.al. expressed herein are my own personal opinions and do not represent my employer's view in any way, shape form, or fashion.  All code for demonstration purposes - no guarantees, either written or implied, are made.

© Copyright 2012 Lee Everest's SQL Server, etc. weblog