monitoring

What tools in SQL Server will notify you about blocking and help track the queries behind your toughest blocking and deadlocking problems?

Hindsight is everything. I was lucky to be trained by a great team of DBAs back when I first started with SQL Server. But it’s hard to know exactly what you really need to know, particularly as new tools are becoming available.