• I agree with Eddie (big surprise - Hi Eddie!!). 🙂

    Waits are cumulative in SQL Server, so they are pretty useless just looking at them in isolation. What you need to do it a differential wait stats analysis (and same for file IO stalls too). Take a snapshot, wait for a period (3 minutes, 1 hour, whatever), then take another snapshot and join the two together and divide by time to get waits per millisecond for each of the different types of waits. THAT gives you actionable information you can start pursuing.

    Note that it won't tell you which queries caused slowness. You can use sp_whoisactive for real-time analysis of what is going on with SQL Server. And I ALWAYS do aggregate profiler analyses at clients to find queries that need tuning.

    ALL of the above form a core part of my performance reviews and health checks for clients, both new and existing.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service