Yearly Archives: 2013

Killing Sessions with External Wait Types

This afternoon I was asked a question that comes up once or twice a year by email. I answered as usual, and only later realized that the topic was a reasonably good match for this month’s TSQL Tuesday topic. I thought I might share the question, and the answer, with a larger audience this time.  Read more »

December 11, 2013 Posted by: 6 Comments - Permalink

Care and Feeding of Your System Databases Webcast

Over the summer it’s been my privilege to speak on the subject of Care and Feeding of Your System Databases at the CACTUSS SQL Server user groups in Austin as well as at SQLSaturday #222 in Sacramento. With the assistance of Idera and, that presentation is also available online for viewing. Here is the  Read more »

August 30, 2013 Posted by: Leave a comment - Permalink

Slides Available for CACTUSS System Databases Presentation

Thanks to everyone who came out to hear me present at CACTUSS this week, I had a lot of fun.  As promised, here are the slides and demos for my Care and Feeding of Your System Databases presentation. Feel free to contact me if you have any questions!

May 23, 2013 Posted by: Leave a comment - Permalink

SQL Server bug: Incorrect values in sys.dm_db_session_space_usage for deferred drops

For the past few months I have been chasing down an issue which has been plaguing my attempts at tempdb monitoring, and in just the last week I’ve received news that it is indeed a confirmed bug in SQL Server.  I’m sharing what I’ve found here for the benefit of the SQL community. One of  Read more »

May 21, 2013 Posted by: 5 Comments - Permalink

Speaking at CACTUSS User Groups in Austin next week

After taking a break from speaking for a while, I’m happy to announce that I’ll be presenting at the CACTUSS Central and CACTUSS North meetings in Austin, TX on May 20 and May 21, respectively.  I’ll be bringing a new presentation, “Care and Feeding of Your System Databases.”  We’ll go over the SQL Server system  Read more »

May 16, 2013 Posted by: Leave a comment - Permalink