• The instance does not need to be restarted at all. That's overkill. The next comment issued by the connection will have the limits enforced.

    The reconfigure is needed, but you could argue that is part of the changing of the resource allocations.

    The host, instance, or database do not need to be changed. Immediately is the best answer.