Is there any way to collect script of running SP with it's input value using DMVs? I am using below script to collect information about active sessions. It returns Query/SP (script), it's estimated E-Plan, resource consumption and other information.

I know to use profiler to collect script of SP with it's input value but because performance of SP varies on different input value, `it's not good idea to run profile for long time, so I want to collect it using DMV.

Is there any way to get it (exec sp_name input1, input2, input3, ..) using DMV?

select
            db_name(sp.dbid),sp.spid,er.wait_type,er.wait_time,er.wait_resource,er.total_elapsed_time,st.text,qp.query_plan
            ,ec.net_packet_size,ec.client_net_address,es.host_name,es.program_name,es.client_interface_name
            ,es.status,es.cpu_time,qmg.granted_memory_kb,es.total_scheduled_time,es.total_elapsed_time
            ,es.reads,es.writes,es.logical_reads

from
                sys.dm_exec_requests er
inner join      master.dbo.sysprocesses sp
on              er.session_id=sp.spid
inner join      sys.dm_exec_connections ec
on              er.session_id=ec.session_id
inner join      sys.dm_exec_sessions es
on              ec.session_id=es.session_id
inner join      sys.dm_exec_query_memory_grants qmg
on er.session_id=qmg.session_id
cross apply     (select text from sys.dm_exec_sql_text(er.sql_handle)) st
cross apply     (select * from sys.dm_exec_query_plan(er.plan_handle)) qp   


Thanks
Have a look at a possible method here - Getting the Query Plans and Parameters Directly from the Plan Cache