THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Performance » Best Practices » Waits   (RSS)
  • 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 out of SQL Server performance profiling Part 2” shows us that SQL Server signal ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on February 9, 2008
  • 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 throughput will reach a plateau. After the load level is cranked up still further, the ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on November 20, 2007
Privacy Statement