SQL Server 2005 Best Practices Analyzer
About a week a go (I admit I'm only catching up to it now…) Microsoft released the SQL Server 2005 Best Practices Analyzer. The tool analyzes and monitors the SQL Server Profiler files. It uses a predefined list of recommendations to determine if there are potential issues in the database environment.
Now if you're like me, then after downloading and installing the tool, you can't help but think to yourself "yeah great, but how do I use it?..." Well all you need to do after that is run the SQL Server Profiler and run the program on the trace files. Enjoy!