To view "recent expensive queries" I use Activity Monitor. Some of the queries there are with parameters.
Is there a way to know the values?
SQL Server Activity Monitor – Understanding Parameters
activity-monitorsql serversql-server-2008-r2
Related Question
- SQL Server – Check for Opened Activity Monitor
- Sql-server – Why is the processor % different in Activity Monitor vs Resource Monitor
- SQL Server Activity Monitor Timeout Error – How to Resolve
- SQL Server – How to Monitor Activity in SSMS Using Only T-SQL
- Sql-server – SQL Server 2014 View any Live execution plan in Activity Monitor
- Sql-server – SSMS Activity Monitor Expensive Query start time
- SQL Server – Troubleshooting Paused Activity Monitor
- SQL Server 2014 – Meaning of Active and Recent Expensive Queries
Best Answer
No, not directly from the Activity Monitor.
You would need to capture those details either using a server-side trace, or using Extended Events.
See the details on this question and the answers for details about how to create a trace to collect that data.