Please or Register to create posts and topics.

live query profiler sql code

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

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

That's perfect ! thanks