Presentation: T-Log First: How SQL Server storage (should) affect your Disk Architecture & T-SQL Design
Attached are the PowerPoint and scripts from my "T-Log First: How SQL Server storage (should) affect your Disk Architecture & T-SQL Design" presentation. This was first shown at the February 21st, 2012 Tulsa SQL meeting. This walks through the very basics of Write-Ahead Logging in SQL Server, how the Transaction Log file is written to differently from the Data file, and how all that naturally leads to the hardware best practices that you always hear and wonder about as a SQL newbie. There's also a demo script that further proves how you can manipulate transaction log writes for improved performance. After I gave my presentation I discovered that Tim Chapman described this process much more succinctly a few years ago in the "explicit transactions" section of his optimization article: http://www.techrepublic.com/blog/datacenter/optimize-sql-server-queries-with-these-advanced-tuning-techniques/179 Consider this further validation :^) Thanks to all the folks ...