• You'll need to set up basic monitoring to understand more fully what's happening on the system. Gails articles are an excellent place to start. You can also look at the book Troubleshooting SQL Server for some excellent information. If you do want to at least look at what might need to be tuned on the queries, and I understand it's an app that you can't change, you can check out my book on Query Tuning.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning