Microsoft has a great article on troubleshooting SQL Server application performance problems. The article discusses various tools and techniques that can be of help when diagnosing performance issues. It also contains references to several additional articles.
INF: Information Required to Successfully Troubleshoot Application Performance Issues
Terry
"I'm not dumb. I just have a command of throughly useless information." - Calvin, of Calvin and Hobbes
INF: Information Required to Successfully Troubleshoot Application Performance Issues
Terry
"I'm not dumb. I just have a command of throughly useless information." - Calvin, of Calvin and Hobbes