What is the syntax for DBCC FREEPROCCACHE with all the optional parameters in T-SQL?(a) DBCC FREEPROCCACHE [ ( { plan_handle | sql_handle | pool_name } ) ](b) DBCC FREEPROCCACHE [ ( { plan_handle | sql_handle | pool_name } ) ] [ WITH NO_INFOMSGS ](c) DBCC FREEPROCCACHE [ ( { sql_handle | pool_name } ) ] [ WITH NO_INFOMSGS ](d) None of the mentionedThis question was posed to me by my school teacher while I was bunking the class.I want to ask this question from Query Plan Reuse topic in portion Performance Tuning and Optimization of SQL Server

What is the syntax for DBCC FREEPROCCACHE with all the optional parame

1.	What is the syntax for DBCC FREEPROCCACHE with all the optional parameters in T-SQL?(a) DBCC FREEPROCCACHE [ ( { plan_handle \| sql_handle \| pool_name } ) ](b) DBCC FREEPROCCACHE [ ( { plan_handle \| sql_handle \| pool_name } ) ] [ WITH NO_INFOMSGS ](c) DBCC FREEPROCCACHE [ ( { sql_handle \| pool_name } ) ] [ WITH NO_INFOMSGS ](d) None of the mentionedThis question was posed to me by my school teacher while I was bunking the class.I want to ask this question from Query Plan Reuse topic in portion Performance Tuning and Optimization of SQL Server
Answer» Right choice is (b) DBCC FREEPROCCACHE [ ( { plan_handle \| sql_handle \| pool_name } ) ] [ WITH NO_INFOMSGS ] Explanation: DBCC FREEPROCCACHE REMOVES all elements from the plan cache, removes a specific plan from the plan cache by specifying a plan handle or SQL handle, or removes all cache ENTRIES associated with a SPECIFIED resource POOL.

Discussion

No Comment Found

Related InterviewSolutions

___________ lets you affinitize a resource pool to one or more schedulers or NUMA nodes for greater isolation of CPU resources.(a) MAX_IOPS_PER_VOLUME(b) AFFINITY(c) MAX_CPU_PERCENT(d) MAX_MEMORY_PERCENTI had been asked this question in unit test.I would like to ask this question from Resource Governor in portion Performance Tuning and Optimization of SQL Server
____________is a hard cap limit on the CPU bandwidth for all requests in the resource pool.(a) MIN_CPU_PERCENT(b) CAP_CPU_PERCENT(c) MAX_CPU_PERCENT(d) MAX_MEMORY_PERCENTThe question was posed to me in class test.My question is taken from Resource Governor in chapter Performance Tuning and Optimization of SQL Server
Which of the following query disables the resource governor?(a) ALTER RESOURCE GOVERNOR ENABLE CONFIGURE;(b) ALTERGOVERNOR DISABLE;(c) ALTER RESOURCE GOVERNOR DISABLE;(d) None of the mentionedThe question was posed to me during an online interview.I'd like to ask this question from Resource Governor topic in section Performance Tuning and Optimization of SQL Server
Which of the following query enables the Resource Governor?(a) ALTER RESOURCE GOVERNOR CONFIGURE;(b) ALTER RESOURCE RECONFIGURE;(c) ALTER RESOURCE GOVERNOR RECONFIGURE;(d) None of the mentionedThe question was posed to me by my school teacher while I was bunking the class.Question is taken from Resource Governor topic in division Performance Tuning and Optimization of SQL Server
Point out the wrong statement.(a) Two workload groups (internal and default) are created and mapped to their corresponding resource pools when SQL Server is installed(b) A resource group serves as a container for session requests that have similar classification criteria(c) Resource Governor also supports user-defined workload groups(d) Resource Governor does not impose any controls on a dedicated administrator connection (DAC)I got this question in a job interview.This question is from Resource Governor topic in portion Performance Tuning and Optimization of SQL Server
Enabling the Resource Governor requires _________ permission.(a) CONTROL SERVER(b) CONTROL(c) SERVER(d) SELECTThe question was asked during an interview for a job.My question is based upon Resource Governor topic in division Performance Tuning and Optimization of SQL Server
You cannot use the ____________ statement to enable Resource Governor when in a user transaction.(a) ALTER RESOURCE GOVERNOR(b) ALTER GOVERNOR(c) ALTER RESOURCE(d) All of the mentionedI got this question by my school teacher while I was bunking the class.My enquiry is from Resource Governor topic in portion Performance Tuning and Optimization of SQL Server
Point out the correct statement.(a) You can set IO thresholds on the internal resource pool(b) There is workload monitoring or workload management between SQL Server instances(c) A resource group represents the physical resources of the server(d) Resource management is limited to the SQL Server Database EngineThe question was posed to me in an online quiz.My doubt is from Resource Governor topic in division Performance Tuning and Optimization of SQL Server
Resource Governor is a feature that enables you to specify limits on the amount of ____________(a) CPU(b) Physical IO(c) Memory(d) None of the mentionedThe question was posed to me in an interview.This interesting question is from Resource Governor topic in chapter Performance Tuning and Optimization of SQL Server
Which of the following partitioned attribute can appear in the following physical and logical operators?(a) Index Seek(b) Drop(c) Alter(d) None of the mentionedI had been asked this question in homework.My question is from Partitioning topic in portion Performance Tuning and Optimization of SQL Server

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment