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 that came out to the meeting - it made for a fun night. Especially when I deleted my demo database right before the meeting and had to re-download mid-presentation, that was really exciting :^P Also if any MVP's or others come across this and have corrections or feedback, I'd love to hear from you.
Otherwise I hope this helps someone whose looking for a nice 'n easy intro to these topics.
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 that came out to the meeting - it made for a fun night. Especially when I deleted my demo database right before the meeting and had to re-download mid-presentation, that was really exciting :^P Also if any MVP's or others come across this and have corrections or feedback, I'd love to hear from you.
Otherwise I hope this helps someone whose looking for a nice 'n easy intro to these topics.
Comments
Post a Comment