SELECT DISTINCT r.session_id, g.name as workload_name, s.host_process_id, s.host_name, c.client_net_address, s.login_name, s.original_login_name, r.status, r.command, r.cpu_time, r.total_elapsed_time, r.total_elapsed_time/(1000*60) AS total_elapsed_time_min , t.text as Query_Text FROM sys.dm_exec_requests r CROSS APPLY sys.dm_exec_sql_text(sql_handle) t INNER JOIN sys.dm_exec_sessions s ON r.session_id = s.session_id LEFT OUTER JOIN sys.dm_exec_connections رفع خطای this could be due to credssp encryption در ریموت دسکتاپ
مفاهيم اوليه شبكه
تست قطعی شبکه با پاورشل
r ,s ,name ,dm ,time ,sys ,dm exec ,sys dm ,total elapsed ,elapsed time ,session id
درباره این سایت