SQL Profiler: Features and setup in SQL Server 2005
SQL Profiler can be considered the best native SQL Server resource because, for one thing, it understands micro-level processing on any SQL Server. Get an introduction to SQL Profilerand its features and setup processes.
SQL Server PerfMon
This screencast series offers tips on how to use SQL Server PerfMon counters to track Windows memory, disk IO and the buffer manager. Find out the maximum numbers to watch for when using SQL Server Performance Monitor in your system.
Tricks for using the SQL Server Index Tuning Wizard
Gathering tricks for using the SQL Server Index Tuning Wizard can improve overall performance in SQL Server. Figuring out how to optimize the Tuning Wizard in conjunction with SQL Profiler will be a big help in your server environment.
SQL Server 2000 Query Analyzer: 10 tricks for simple querying
Even though Microsoft excluded this tool from SQL Server 2005, many improvements can be made to the raw performance of your SQL Server statements, as well as to your job performance as a DBA or developer, by simply using these tricks for simple querying in SQL Server 2000's Query Analyzer.
SQL Server Management Studio client tool enhancements
Although using Query Analyzer or Enterprise Manager can be reassuring to a long-time DBA, many upgrades point towards it being time to step out of your comfort zone and learn about the features and enhancements in SQL Server Management Studio.
Tracking query execution with SQL Server 2005 Profiler