Browse by Tags

• Waits

• 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 | 9 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