Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Mirroring and different sector sizes? BAD IDEA! Expand / Collapse
Author
Message
Posted Monday, December 26, 2011 11:25 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 12:21 AM
Points: 31, Visits: 477
Comments posted to this topic are about the item Mirroring and different sector sizes? BAD IDEA!
Post #1226756
Posted Tuesday, December 27, 2011 3:10 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, September 12, 2014 3:47 PM
Points: 42, Visits: 331
Good & well written article Theo. Useful to know. Thanks

Rgds,
T.
.be
Post #1226812
Posted Tuesday, December 27, 2011 5:32 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: 2 days ago @ 6:47 AM
Points: 1,434, Visits: 1,846
Very well written article. Thank-you very much for the same.

It's difficult to keep cool and look for the root cause when such problems arise. I therefore, appreciate your dedication to the issue. I am sure this will help out a lot of the members of the community.


Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Be courteous. Drive responsibly.

Follow me on
Twitter: @sqltwins
Google Plus: +Nakul
Post #1226855
Posted Tuesday, December 27, 2011 5:36 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 3:25 AM
Points: 118, Visits: 245
Thank you. This is bound to bite me in the future.

Bookmarked




Wayne

Did you get access denied? Great the security works.

Post #1226857
Posted Wednesday, December 28, 2011 9:51 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, October 13, 2014 8:02 AM
Points: 1,258, Visits: 13,556
Thanks Theo for share your experiences with us!!!!

This article is really very important



rfr.ferrari
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!
Post #1227449
Posted Friday, December 30, 2011 6:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 17, 2014 5:54 AM
Points: 3, Visits: 171
Excellent item. This is a fine example of how to write a technical article.

Thanks.

Post #1228322
Posted Friday, December 30, 2011 12:50 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:53 AM
Points: 1,176, Visits: 778
tks for lesson learned without all the pain you endured! cheers
Post #1228533
Posted Tuesday, March 26, 2013 10:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 5, 2013 9:41 AM
Points: 1, Visits: 57
The title of the article is about Mirroring with different sector sizes but the content of the article is about disk misalignment. Very helpful info but maybe a title change?

I have several clients who have bought new SANs that go with a 4k sector sized LUN but keep the old SAN as their mirror failover. In some cases they won't or can't rebuild the old SAN's LUNs to be 4k sector based so they get warnings in the SQL Server logs about the tail of the log having to be re-written. It will slow down performance if the mirroring process has to take each 4k chunk and remap it back to 512B and then process each of the 512B chunks.. but its effects are dependent. One client I have has two HP DL980's running 160 logical cores doing all OLTP and they're mirroring is working fine enough in this setup. It spams their error logs but that's the price of not upgrading the old SAN.

Disk alignment, as you have shown, causes more IO to be required to do the same task. For a read it will be 2x. It has to grab both physical sectors that the logical sector is on in order to reconstitute the logical sector. For writes it can be worse. It's called a Read Modify Write. It has to read both physical sectors, then modify the parts that changed on both physical sectors, then write both physical sectors to storage. So there's 4x the IO's plus two 'update' transactions in the storage tier.

Post #1435598
Posted Wednesday, October 23, 2013 5:38 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 2:49 PM
Points: 495, Visits: 867
Great article and a very clear and detailed explanation - thank you very much.

Have just seen this exact same problem with a 4 replica AlwaysOn Availability Group.

Sure enough the disk sector size on one of the replica servers is different to that on the other three.
Post #1507555
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse