Today’s Annoyingly-Unwieldy Term: "Intra-Query Parallel Thread Deadlocks"

I’ve received a couple of questions in email and in comments about deadlocks involving mysterious-sounding non-lock resources like “exchangeEvent” and “threadpool“.  There are a couple of examples in the comments for post http://blogs.msdn.com/bartd/archive/2006/09/25/deadlock-troubleshooting-part-3.aspx, and here’s a forum post on the topic: http://forums.microsoft.com/Forums/ShowPost.aspx?PostID=3913233&SiteID=1.     Here’s one example (note that I’ve omitted the “inputbuf” and “executionStack” nodes…

9

Defining Complex Server "Health" Policies in SQL 2008

Policy Based Management (PBM) is a new feature in SQL Server 2008 that allows you to define a set of policies that capture the intended state for a group of servers.  For example, you could define a policy that says that your user databases should all have the auto update statistics database option enabled.  (If…

7

Query Fingerprints and Plan Fingerprints (The Best SQL 2008 Feature That You’ve Never Heard Of)

  In versions of SQL Server before SQL Server 2008, it can be difficult to determine the cumulative cost of the queries running on a server if the workload includes unparameterized queries.  The only truly reliable method is to capture a Profiler trace during a representative time period, then post-process the trace with a utility…

4