Explanation:When Forced Parametrization is enabled, Simple Parametrization can still occur. 5. Point out the wrong statement :
A. MisGuided Plan Executions/sec represents number of plan executions per second in which the query plan has been generated by using a plan guide.
B. Execution plans remain in the procedure cache as long as there is enough memory to store them.
C. When a user process inserts an execution plan into the cache, the user process sets the current cost equal to the original query compile cost
D. All of the mentioned
Answer:A
Explanation:When Forced Parametrization is enabled, Simple Parametrization can still occur. 5. Point out the wrong statement :
A. MisGuided Plan Executions/sec represents number of plan executions per second in which the query plan has been generated by using a plan guide. B. Execution plans remain in the procedure cache as long as there is enough memory to store them. C. When a user process inserts an execution plan into the cache, the user process sets the current cost equal to the original query compile cost D. All of the mentioned
Explanation:Guided Plan Executions/sec represents number of plan executions per second in which the query plan has been generated by using a plan guide. 6. Which of the following SQL Server SQL Statistics counter represents number of auto-parametrization attempts per second ?