Home Forums SQL Server 2012 SQL Server 2012 - T-SQL How can I get the waits for each database? RE: How can I get the waits for each database?

  • February 24, 2017 at 6:13 am

    #1930137

    Grant Fritchey - Friday, February 24, 2017 5:59 AM

    Azure SQL Database has a DMV sys.dm_db_wait_stats, which is absolutely wonderful. It will show you wait stats per database. However, the boxed product doesn't have that DMV. The one way you can get close would be to set up extended event sessions, filtered by database, and capture waits in that way. I don't think it's going to be the most effective mechanism though.

    Thank you Grant
    I know there is a way since we have a third party tool that is doing something like that, but I need the data in a different way....
    It sounds like too much effort just to get a different visualization from the one I have already, I will just think on a different approach then

    thanks again