Tag Archives: tempdb

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 MSSQLTips.com, that presentation is also available online for viewing. Here is the  Read more »

August 30, 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