I work for a small to mid-size business, and am a jack-of-all-trades: some application development, database design, technical support, etc. I have been working a lot lately with SQL server 2005. We have some databases that contain a large (for us) amount of info... anywhere between 5-20 million rows in the largest tables. I'm interested in purchasing any type of software that will assist with performance tuning on these databases. I doubt I manage updates/inserts/deletes the most effectively, but am not sure how to identify and analyze bottlenecks. Outside of getting a consultant (which we're open to, but that's a different question), do you have any recommendations on software to help us with this?