locked
Total average wait time in server RRS feed

  • Question

  • Hi, 

    I want to check total average wait time of the SQL Server which should give me the only the current average wait time only.

    This is required to know what is the current total / average wait time on the SQL server 


    Dilip Patil..


    Wednesday, August 21, 2019 9:17 AM

Answers

  • Hi Dilip Patil,

     

    Would you like information about all the waits encountered by threads that executed? Please refer to sys.dm_os_wait_stats (Transact-SQL).

     

    Hope it will help you.

     

    Best Regards,

    Rachel


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, August 22, 2019 7:58 AM