Sample Header Ad - 728x90

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