This is in no way an advertisement for Microsoft Services but I must admit this week was a great learning experience for me. It made me realize that I know less about SQL Server than I thought and made me doubt myself a bit :(. SQL Representative showed me a few tools like syscompare, sqlnexus and PAL. These tools helped me tie all the information I needed for performance tuning together and packaged this information in a beautiful report that you may submit to managers. If your shop has a contract with Microsoft and your SQL Servers do not perform as well as they should be, definitely seek these services. Download SQLRAP Datasheet here.