Browse by Tags

• Best Practices
• Storage
• Waits

• Performance Impact: Some Data Points on Read-Ahead

  In the next series of posts, I'll focus on SQL Server I/O, revisiting some common issues and taking a closer look at some others. In each post and as always, I'll make the case with specific data points from my tests. For the first two posts in this series, Read More... Posted Friday, July 04, 2008 4:24 PM by Linchi Shea | 1 Comments Filed under: Performance, Storage, SQL Server 2005

• SQL Server Checkpoint I/O Behavior

  Andrew Kelly in a recent post here advised visiting/revisiting the SQL Server I/O basics, and I completely agree. A firm grasp of the basics can make it easy to understand some system behaviors that otherwise may be puzzling at times. A question that Read More... Posted Saturday, January 19, 2008 3:11 AM by Linchi Shea | 5 Comments Filed under: Performance, Storage, SQL Server 2005

• A Rose By Any Other Name

  Regardless of the DBMS make or model, the transaction throughput curve of a database system is often shaped like a trapezoid. As the load level goes up initially, so does the transaction throughput. As the load level continues to go up, the transaction Read More... Posted Tuesday, November 20, 2007 4:04 PM by Linchi Shea | 8 Comments Filed under: Performance, Waits, Best Practices, SQL Server 2005 Attachment(s): proc_name.gif

• Performance Impact: The Potential Cost of Read_Committed_Snapshot

  In response to my previous blog post-- Performance Impact: Setting a Database to Read Only , Shailesh Khanal mentioned that he observed significant performance degradation from READ COMMITTED SNAPSHOT OFF to ON for a read-only workload. This is counter Read More... Posted Friday, October 05, 2007 12:49 AM by Linchi Shea | 3 Comments Filed under: Performance, Best Practices, SQL Server 2005 Attachment(s): RCS.gif