http://www.sqlservercentral.com/Content tagged Administration, SQL Server 2005, Performance Tuning 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/How should you approach indexing your database? Do you have a good strategy for deciding which indicies to create and on which columns? Aaron Ingold brings us a great article discussing these very topics that is likely to become a must read for many DBAs. http://www.sqlservercentral.com/articles/Performance+Tuning/2770/2007/12/24http://www.sqlservercentral.com/articles/Performance+Tuning/2770/How should you approach indexing your database? Do you have a good strategy for deciding which indicies to create and on which columns? Aaron Ingold brings us a great article discussing these very topics that is likely to become a must read for many DBAs. http://www.sqlservercentral.com/articles/Performance+Tuning/2770/2007/12/24http://www.sqlservercentral.com/articles/Performance+Tuning/2770/Sanchan Saxena gets to grips with the new index-tuning tools and features in SQL 2005http://www.sqlservercentral.com/redirect/articles/2651/2006/10/17http://www.sqlservercentral.com/redirect/articles/2651/