Windows storport enhancement to help troubleshoot IO issues

For Windows 2008 and Windows 2008 R2 you can download a Windows storport enhancement (packaged as a hotfix). This enhancement can lead to faster root cause analysis for slow IO issues. Once you apply this Windows hotfix you can use Event Tracing for Windows (ETW) via perfmon or xperf to capture more detailed IO informationContinue reading “Windows storport enhancement to help troubleshoot IO issues”

SQL Server with NetApp SAN

If you are planning to use¬†¬†NetApp as the SAN for your SQL Server instance(s), take a look at these documents in addition to the normal SQL Server IO planning best practices documents. TR-3779 Sizing best practice guide. http://media.netapp.com/documents/tr-3779.pdf TR-3696 This is for the storage layout best practices. http://www.netapp.com/us/library/technical-reports/tr-3696.html White Paper on 1 TB DSS systemsContinue reading “SQL Server with NetApp SAN”