Resource Governor Enablement

Category: sql server dbengine

Question

arifulhaq on Thu, 30 Mar 2017 03:43:21


Hi,

We are going to implement Resource Governor in our SQL Server 2012 Production database. Can anyone tell me the followings-

1) Do we need to restart instance for this?
2) If we do not need to restart instance then will the existing connection will redirected to newlu created resource pool/groups?

Replies

Olaf Helper on Thu, 30 Mar 2017 06:17:29


Hello,

No need to restart SQL Server, the changes will take immediatly effect, but not for existing Connections, only for new once; see Enable Resource Governor : " ... The classifier function is run for new connections ... "