http://www.sqlservercentral.com/Content tagged Administration, Performance Tuning, SQL Server 2005, Utility posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Reports summaries of connections, running requests, open transactions, open cursors, and blocking at 3 different levels of aggregation detail, ranking trouble groups first.http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/64433/2008/11/10http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/64433/Reports stats on what the query optimizer records in the DMVs as missing indexes and what it says the cost savings will be if they were present. Can limit by table / schema name patterns.http://www.sqlservercentral.com/scripts/Index+Management/63937/2008/10/06http://www.sqlservercentral.com/scripts/Index+Management/63937/