live query profiler sql code
Quote from Pierre-Yves on November 28, 2019, 11 h 27 minHello,
where can I found the sql code used to display stats in the live query profiler that is using sys.dm_exec_query_stats ?
Thanks
Hello,
where can I found the sql code used to display stats in the live query profiler that is using sys.dm_exec_query_stats ?
Thanks
Quote from Gregory Boge on November 28, 2019, 11 h 58 minIn this page lol http://kankuru.com/wiki/monitoring/live-queries-profiler/
Directly in the code of KMO https://github.com/KankuruSQL/KMO/blob/master/KServer.cs#L302
If your application uses lot of dynamic queries, this DMV can be huge and this query very long
In this page lol http://kankuru.com/wiki/monitoring/live-queries-profiler/
Directly in the code of KMO https://github.com/KankuruSQL/KMO/blob/master/KServer.cs#L302
If your application uses lot of dynamic queries, this DMV can be huge and this query very long
Quote from Pierre-Yves on November 29, 2019, 10 h 05 minThat's perfect ! thanks
That's perfect ! thanks