-----------------
-- ausevich.ru --
-----------------

SELECT
 DB_NAME(er.database_id) AS DB_Name,
 er.start_time,
 er.session_id,
 er.status,
 er.command,
 -- performance:
 er.reads+er.writes AS IO,
 er.logical_reads,
 er.cpu_time,
 er.total_elapsed_time,
 -- waits:
 er.blocking_session_id,
 er.wait_type,
 er.wait_time,
 er.wait_resource,
 -- query:
 qt.text,
 qp.query_plan
FROM 
 sys.dm_exec_requests as er
 CROSS APPLY sys.dm_exec_sql_text(er.sql_handle) qt
 CROSS APPLY sys.dm_exec_query_plan(er.plan_handle) qp
WHERE 
 er.database_id = DB_ID('MyBase')