axperf: Overcoming parameter sniffing issue in Microsoft Dynamics AX 2012-R2 – CU6

[Blog bot]

Источник: http://blogs.msdn.com/b/axperf/archi...12-r2-cu6.aspx
==============

Parameter sniffing is the default behavior that SQL Server uses when compiling parameterized SQL statements. When a stored procedure or a parameterized SQL statement is compiled or recompiled, the parameter values passed for that invocation are "sniffed...(read more)

Источник: http://blogs.msdn.com/b/axperf/archi...12-r2-cu6.aspx