• Very interesting news about SQL 2008 and Extended Events. I'm looking forward to when we can upgrade our production servers to that.

    For now the WMI deadlock system has provided a nice and easy to read history of deadlocks for us and we've hooked in an e-mail notification as well. CPU usage for WMI is roughly 2-3% on our box and we have capacity to spare so it's been worth it.