Archives for October 2013

Coming to the PASS Summit?

Are you coming to Charlotte next week for the PASS Summit?  Let's connect!  When ever it's open, I'll be in the Exhibit Hall at the SQL Sentry booth unless I'm delivering a session or something of that nature.  Here's the sessions I've got on the calendar - Tue, Oct 15: First-timers Get to Know Your Community with Kendal Van Dyke (Blog | Twitter), 2:45-3:45 and 4:00-5:00 PM First-timers Orientation Panel Discussion (moderator), 6:00-6:45 PM Opening Ceremonies and Quizbowl, until 8:00 PM Wed, Oct 16: Keynote, Blogger’s table Session: Convince Me - Persuasion Techniques That … [Read more...]

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 resource, activity, or process.  Since wait statistics are categorized by type, one look will quickly tell the variety of problem that needs your attention, assuming you know meaning for Microsoft's lingo for each wait type. (As an aside, wait stats were implemented in the earliest days of relational database computing because the early RDBMSes ran on … [Read more...]