Parameters in Activity Monitor 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?
You can right-click the query you are interested in and select Show execution plan:


Once you have the execution plan open, just right-click in an empty area and select Show Execution Plan XML.... Once you have that you will see a section in the XML &lt;ParameterList&gt;. In that node it will show you the ParameterCompiledValue:

    &lt;ParameterList&gt;
      &lt;ColumnReference Column="@records" ParameterCompiledValue="(0)" /&gt;
      &lt;ColumnReference Column="@traceid" ParameterCompiledValue="(2)" /&gt;
    &lt;/ParameterList&gt;
  &lt;/QueryPlan&gt;
&lt;/StmtSimple&gt;


Another way would be to copy the execution plan XML out and paste it into Plan Explorer and view the Parameters tab:


Edit for the nerds

If you open up Activity Monitor, and then go into tempdb you will find all the temp objects (tables and all) that Activity Monitor is using. For the Expensive Queries it is using the object dbo.#am_get_querystats. You can open that procedure up and look at the exact query they use to pull it. Pretty cool. I did this for the activity section so I could get similar information without having to open up Activity Monitor all the time.