Simon's SQL

SQL,DBA,tuning,Trouble Shooting,Performance

misaligned log ios which required falling back to synchronous io between 4096 and 512e

Posted by Simon Cho on 02/13/2015

https://kb.netapp.com/support/index?page=content&id=1010881
https://kb.netapp.com/support/index?page=content&id=3011193
https://kb.netapp.com/support/index?page=content&id=1014111
http://www.netapp.com/us/system/pdf-reader.aspx?m=tr-3428.pdf&cc=us
http://www.netapp.com/us/system/pdf-reader.aspx?m=tr-3747.pdf&cc=us
http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1009658

http://blog.jgriffiths.org/?p=592
https://www.vmware.com/support/developer/vddk/vmdk_50_technote.pdf?src=vmdk
http://www.randomnoun.com/wp/2013/09/12/determining-the-file-at-a-specific-vmdk-offset/

http://blogs.msdn.com/b/saponsqlserver/archive/2014/10/02/message-misaligned-log-ios-which-required-falling-back-to-synchronous-io-in-sql-server-error-log.aspx
https://msdn.microsoft.com/en-us/library/windows/desktop/hh182553(v=vs.85).aspx
http://support.microsoft.com/kb/982018?wa=wsignin1.0
https://msdn.microsoft.com/en-us/library/windows/desktop/hh182553(v=vs.85).aspx
http://blogs.msdn.com/b/psssql/archive/2013/05/15/sql-server-storage-spaces-vhdx-and-4k-sector-size.aspx
https://technet.microsoft.com/en-us/sqlserver/aa365683(v=vs.100).aspx
http://blogs.msdn.com/b/psssql/archive/2011/01/13/sql-server-new-drives-use-4k-sector-size.aspx
https://msdn.microsoft.com/en-us/library/windows/desktop/hh848035(v=vs.85).aspx
https://msdn.microsoft.com/en-us/library/cc966412.aspx#EEAA
http://sqlcommunity.com/SQL-TEAMS/SAP-on-SQL
https://kb.netapp.com/support/index?page=content&id=1010803&actp=search&viewlocale=en_US&searchid=1423875704148

One Response to “misaligned log ios which required falling back to synchronous io between 4096 and 512e”

  1. pipe dream said

    If you are going for best contents like myself, only
    pay a visit this site all the time as it gives feature contents, thanks

Leave a Reply to pipe dream Cancel reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s