Browse by Tags

• SQL Server 2005

• Signal Waits and SQLOS Scheduler Pressure

  What does it mean if you see a high percentage of signal waits? Thanks to Microsoft whitepapers, presentations, and blogs, everybody would say it implies CPU pressure. Well, almost everyone except Mario Broodbakker, whose excellent blog “ Taking the guesswork Read More... Posted Saturday, February 09, 2008 5:59 PM by Linchi Shea | 5 Comments Filed under: Performance, Waits, Best Practices

• 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