We're using Resource Governor to limit CPU for specific users at particular times of the day. This works fine for new sessions but obviously the active sessions are using the resource pool that they were assigned at the time of connection.
Is there any method for changing an active session's resource pool without killing it and requiring a reconnection - which is rarely practical?
Thanks.