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 » Waits   (RSS)
  • Revised File & Wait Statistics Procedures

        For many years I have been using a set of stored procedures to capture and report on both the file and wait statistics inside of SQL Server and I just recently did some more modifications that I wanted to make available. Since many of you have received copies of the past revisions via conferences or articles and such I ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on September 2, 2015
  • What PASS sessions will I try to attend?

    Every year at PASS, I do the same thing. I hmm and haw over which sessions I want to go to, and I end up making some tough choices at game time.  This year I believe I'll be pretty busy, so my typical pie-in-the-sky view of how much I'll be able to attend just isn't going to pan out.  Instead, I have selected 5 sessions that I really ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on October 29, 2010
  • 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
  • CPU Pressure is Huge, But Where is the Wait?

    SQL Server waits enable you to identify where SQL Server is spending a lot of time doing nothing but waiting. This allows you to quickly zoom in and focus on the problem areas that are most relevant to the root cause, and will most likely help cut down time you may otherwise waste on, for instance, irrelevant perfmon counters or SQL trace events. ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on December 31, 2006
Privacy Statement