CloudMonix Support

A: We plan to add a standard metric that tracks currently executing queries, however, in the meantime, capturing them can be done via DatabaseSqlQuery metric.  The SQL statement to supply to this metric is as follows

SELECT 
s.login_name as [Login],
Substring(sqltext.TEXT,1,2048) as [SQL],
req.Session_Id as SessionId,
req.status as [Status],
req.command as Command,
req.cpu_time as Cpu,
req.total_elapsed_time as ElapsedTime
FROM sys.dm_exec_requests req inner join sys.dm_exec_sessions s ON req.session_id = s.session_id
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext 

Don't forget to highlight this metric on the dashboard