How can query the cumulative wait stats for a session

Question

Starting from 2016, support for sys.dm_exec_session_wait_stats has been available. How should I query it before 2016?

If we use while and sys.dm_exec_session_wait_stats, I think theoretically it is also unreliable because one execution may take two intervals of time, resulting in missed collection.

My requirement is to query the waiting information during SQL execution. If you have any other ideas, I am very much looking forward to your help

Answer 1

Hi,

its strongly recommended to move out of sql server 2014, as its ready reached end of support: https://learn.microsoft.com/en-us/lifecycle/products/sql-server-2014

with newer versions you will have more improved features regarding wait stats.

Thanks

Emad