Simon's SQL

SQL,DBA,tuning,Trouble Shooting,Performance

Archive for February, 2015

Parallelism

Posted by Simon Cho on 02/24/2015

http://blogs.msdn.com/b/craigfr/

Advertisements

Posted in Common | Leave a Comment »

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

Posted in Common | 1 Comment »