SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software
Development resources, articles, tutorials, code samples, tools and downloads for ASP.Net, SQL Server, Reporting Services, T-SQL, Windows, AWS, SAP HANA and ABAP

Enable Resource Governor on SQL Server 2014

To enable Resource Governor SQL Server database administrators can use SQL Server Management Studio or execute SQL commands to manage Resource Governor to enable or disable. When SQL Server is installed the Resource Governor is disabled by default. If a database administrator wants to activate Resource Governor and use for managing resources on a SQL Server instance, he or she has to enable Resource Governor first.

This SQL Server tutorial shows how to enable Resource Governor on SQL Server 2014 instance by using SQL Server Management Studio and T-SQL commands.

Enable Resource Governor using SQL Server 2014 Management Studio

Open SQL Server Management Studio and connect to SQL Server 2014 instance.
Within Object Explorer window, drill down Management node.
Right click on Resource Governor, and choose Enable.

enable Resource Governor in SQL Server Management Studio

When the SQL Server Resource Governor is enabled, the Disable option will be active to turn off Resource Governor feature on current SQL Server instance.

While connected to the SQL Server instance via SSMS (SQL Server Management Studio), an other option is to enable or disable SQL Server Resource Governor from the Properties window.

SQL Server Resource Governor properties

On Resource Governor Properties screen, make sure you mark "Enable Resource Governor" checkbox and OK button.

Enable SQL Server 2014 Resource Governor

Enable Resource Governor using Transact-SQL Code

"Alter Resouce Governor" T-SQL command enables SQL Server database administrators to enable or disable Resource Governor tool on target SQL Server 2014 instances by using SQL code.

ALTER RESOURCE GOVERNOR DISABLE; -- to disable Resource Governor

SQL Server

SQL Server 2019 Installation
download SQL Server 2019
download SQL Server 2017
download SQL Server 2016
download SQL Server 2014
download SQL Server 2012
MacOS ve SQL Server 2019

Copyright © 2004 - 2021 Eralper YILMAZ. All rights reserved.