Question

Which of the following query disables the resource governor?

(a) ALTER RESOURCE GOVERNOR ENABLE CONFIGURE;

(b) ALTER  GOVERNOR DISABLE;

(c) ALTER RESOURCE GOVERNOR DISABLE;

(d) None of the mentioned

The 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

Answer 1

Correct option is (c) ALTER RESOURCE GOVERNOR DISABLE;

The best I can explain: You can disable the Resource Governor by using either SQL Server Management Studio or Transact-SQL.