Which parameters was a stored procedure or command executed with?
6
votes
1
answer
771
views
We are using
nHibernate
which generates queries from .NET
code. Occasionally, some queries get stuck in the sp_whoisactive
list and we cannot find out why. I have a feeling that it has to do with a missing or broken parameter. When I run sp_whoisactive
, however, I only see the parameter name (in example: @p0
), not the actual value. Is there a way to retrieve this information while the process is still running?
Example:
SELECT
this_.Id as Id6_2_, this_.HRNumber as HRNumber6_2_,
this_.FirstName as FirstName6_2_, this_.LastName as LastName6_2_,
this_.StatusTypeID as StatusTy5_6_2_,
this_.PropertyId as PropertyId6_2_, this_.DepartmentGroupId as Departme7_6_2_,
property2_.PropertyID as PropertyID10_0_,
property2_.PropertyCode as Property2_10_0_,
property2_.LMSCode as LMSCode10_0_, property2_.PropertyName as Property4_10_0_,
property2_.Report as Report10_0_, department3_.Id as Id4_1_,
department3_.Name as Name4_1_, department3_.DisplayName as DisplayN3_4_1_
FROM
[dbo].[EmployeeDepartmentGroupView] this_
LEFT OUTER JOIN
[dbo].[Property] property2_ ON this_.PropertyId=property2_.PropertyID
LEFT OUTER JOIN
[dbo].[DepartmentGroup] department3_ ON this_.DepartmentGroupId=department3_.Id
WHERE
this_.HRNumber LIKE @p0;
Please note, this is automatically generated SQL from nHibernate
.
Specs: SQL Server 2008r2
Asked by Mario Tacke
(175 rep)
Apr 28, 2014, 05:19 PM
Last activity: Jan 20, 2015, 07:46 PM
Last activity: Jan 20, 2015, 07:46 PM