Azure Running Queries

by

Aşağıdaki sorgu kullanılarak Azure da çalışan sorgular bulunabilir.

select r.session_id,dateadd(hour,3,start_time) as start_time, cast(cast(total_elapsed_time as decimal(20,2))/60000 as decimal(10,2))
as run_time_minutes,command,login_name,client_id,app_name,*
FROM
sys.dm_pdw_exec_requests r
inner join sys.dm_pdw_exec_sessions s on r.session_id = s.session_id
where
r.status = 'Running' and s.status <> 'Closed' and s.session_id <> session_id()

Leave a Comment