Here is a good set of scripts to use: http://sqlserverperformance.wordpress.com/2012/06/12/sql-server-2005-diagnostic-information-queries-june-2012/

BUT you need to know a bit to INTERPRET the resulting outputs. MUCH better is to hire a professional to give your systems/applications a review and MENTOR you on how to do the same. Win-Win.