Developers frequently make a big mistake: they tune out on discussions of storage performance and IO. Don’t fall into this trap! Understanding how storage impacts SQL Server performance helps you tune the right parts of your code and focus on what really matters. In this 30 minute video, Microsoft Certified Master Kendra Little demonstrates why developers need to understand the IO impact on writes and reads in SQL Server. She’ll show you how simple configuration changes can sometimes save hundreds of hours of developer time.
Interested in the tools or references in the video? Check out the links at the bottom of this post.
Links and References
- Learn more about Hammerora for SQL Server, the load testing tool I use in the video
- Gather scripts on wait stats using our SQL Server First Responder Kit scripts
- Check out sp_whoisactive, the stored procedure by Adam Machanic I use to check on what’s currently running in the demo
2 Comments. Leave new
Kendra.
a huge fan of yours, please you tell anyone. lol
Kendra. One stupid question. (sorry about that) What’s the difference between SQl server 2008 and SQL server 2008 R2. I have read many articles and none have a clarification on this. Please help. I am lost in this aspect of sql.
Thanks and many thanks for all the hard work.
Hi Alejandro,
SQL Server 2008 R2 is a separate version of SQL Server– it was named “R2” instead of being given a different year, but it’s entirely its own version, was licensed independently, etc. (In other words, it’s not a service pack.)
More information is in Brent’s blog post here: https://www.brentozar.com/archive/2009/09/sql-server-2008-r2-frequently-asked-questions/
Hope this helps!
Kendra