THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » performance » Administration » Internals   (RSS)
  • Wait Statistics in Microsoft SQL Server

     (Originally appearing at http://kevinekline.com/2013/10/09/wait-statistics-in-sql-server/).When it comes to troubleshooting in relational databases, there's no better place to start than wait statistics.  In a nutshell, a wait statistic is an internal counter that tells you how long the database spent waiting for a particular ...
    Posted to Kevin Kline (Weblog) by KKline on October 9, 2013
  • Learn More About SQL Server IO and Query Tuning in These Webcasts

    I'm doing two new webcasts next week on Wednesday, December 19th, one in the morning and the other after lunch.   SSDs are a Game Changer for SQL Server Storage No, session is not exclusively about SSDs.  But this is my first session on IO and storage tuning that emphasizes SSDs over hard disks.  As Bob Dylan said ''Times, they ...
    Posted to Kevin Kline (Weblog) by KKline on December 14, 2012
  • New on SQLMag.Com: Update to SP_WHOISACTIVE

    I profiled Adam Machanic's (blog | twitter) excellent stored procedure, SP_WHOISACTIVE, back in August of 2010 in my monthly SQLMag column, Tool Time.  Adam has been diligent about maintaining the tool and adding new features. Read the details on my SQLMag Tool Time column (here - ...
    Posted to Kevin Kline (Weblog) by KKline on April 21, 2011
  • New on KEK.com - Presentation: SQL Server for Oracle DBAs

    Back in late May, my pal Buck Woody (blog | twitter) and I presented SQL Server for the Oracle DBA.  Buck played Jerry Lewis' role, while I played the straight man a la Dean Martin.  You can see the recording and slide deck here.  Since both Buck and I spent a considerable number of years working on Oracle, we felt like we had ...
    Posted to Kevin Kline (Weblog) by KKline on August 2, 2010
  • Two Free Training Webcasts Open for Registration

    We've got two sessions that you need to sign up for right away.  The upcoming webcast for Oracle-oriented folks has huge registration numbers.  So get in while you still can before we hit the limit of what LiveMeeting can handle. Pain of the Week: SQL Server for the Oracle DBA Webcast: SQL Server for the Oracle DBADate: ...
    Posted to Kevin Kline (Weblog) by KKline on May 24, 2010
  • Join Me May 19th for 24 Hours of PASS

    Join Us for 24 Hours of SQL Server Training (with a special focus on SQL Server 2008 R2)Did I mention that your Cohorts in Crime (that be me and Brent Ozar) are presenting?!? The FREE 24 Hours of PASS event is bringing an exceptional lineup of SQL Server and BI experts to your computer starting at 12:00 GMT (UTC) on May ...
    Posted to Kevin Kline (Weblog) by KKline on April 26, 2010
  • Old Performance Tuning Recommendations Die Hard

    It’s interesting to me that old and inaccurate performance tuning recommendations seem to have a life of their own.  In some ways, old performance tuning recommendations are like the Undead from some kind of cheesy, 1970’s zombie movie – no matter how many times you shoot them, they just keep coming back.   Here’s a good case in point, ...
    Posted to Kevin Kline (Weblog) by KKline on June 23, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement