arifulhaq on Thu, 30 Mar 2017 03:43:21
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?
Olaf Helper on Thu, 30 Mar 2017 06:17:29
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 ... "