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 ?
A. Batch Requests/sec
B. Failed Auto-Params/sec
C. Forced Parametrizations/sec
D. Auto-Param Attempts/sec
Answer:A
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 ?
A. Batch Requests/sec B. Failed Auto-Params/sec C. Forced Parametrizations/sec D. Auto-Param Attempts/sec
Explanation:Auto-parametrization occurs when an instance of SQL Server tries to parametrize a Transact-SQL request by replacing some literals with parameters so that reuse of the resulting cached execution plan across multiple similar-looking requests is possible. 7. The maximum size for all caches is a function of the ________ size.