Home Forums SQL Server 2008 SQL Server 2008 - General Performance issues - Application running on SQL2008 Standard backe end DB RE: Performance issues - Application running on SQL2008 Standard backe end DB

  • It's about capturing metrics. If you suspect that an action on the app is delayed by other actions on the database, you'd focus on queries against the database during the time in question. The best way to capture queries using 2008 servers is trace (although extended events are available, they're harder to use). Here's an intro to trace.

    "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