This article presents a utility that will show you what SQL statements are using the transaction logs, in terms of log space used and transaction duration.
2016-06-17 (first published: 2015-03-10)
This article identifies which indexes are used when T-SQL code runs, and proposes ways of improving these targeted indexes, leading to better performing code.
2012-08-03 (first published: 2009-09-17)
This article describes a utility that allows you to inspect cached plans and extract information that can be useful in improving the performance of your SQL.
2012-06-22 (first published: 2009-06-11)
This article describes a utility that allows you to identify what SQL statements are currently executing.
2009-12-11 (first published: 2008-10-28)
The attached article describes a utility that allows you to quickly identify which queries are running slower than expected. Note this article was updated to correct the formatting issues.
2008-08-14 (first published: 2008-08-07)