A quick post of what appears to be a really useful technet article on troubleshooting SQL Server 2005 performance http://technet.microsoft.com/en-us/library/cc966540.aspx with some custom scripts.