• ricardo_chicas - Thursday, February 23, 2017 1:56 PM

    Hello all,
    I need to create a report that gets me the waits, time and percentage at database level for a period of time, but all I can find is stats at server level
    any idea on how can I get that data?

    Thanks in adavance

    I'm not even sure how that would be defined. Waits are only captured at the server level and in SQL Server 2016 also the session level. You could potentially get some information by session but that still wouldn't satisfy that request since since it's not by database, threads wait and not sessions and sessions can have multiple threads and those threads could potentially wait on various resources. What if I'm in master and use three part naming to execute a query that references a few different databases. Where is the wait? And what if I issue a distributed transaction and wait on DTC? Does that tell you anything about the database where I executed that transaction? And what if it's something running in parallel? There are a lot of things along those lines. And your on 2014 anyway. Maybe the report and whatever information is desired needs to be redefined. 

    Sue