One thing people don’t take enough advantage of is tools, especially free tools. There’s not much reason, or justification, for building out your own tools, when there’s a free one that is a click away. Below is a list of free tools, with some resources about using them. Feel free to use and share this list – if I’m missing something good, let me know in the comments.
- SQLIOSim utility
Auditing and compliance
Best Practices Analyzer
- SQL Server 2005 Best Practices Analyzer