[Prior Post] [Next Post]
In the prior post of this series, we showed how to move databases to one SQL Server instance. Once this process is completed, we need to disable or uninstall the other instances. My recommendation is to always disable instances and delay uninstalling the instance. Disabling the instance is quick and can be quickly undone. The software and configuration will stay on disk but will not be loaded into memory. Uninstalling (and possibly reinstalling later) is a time consuming activity that rarely has a payback (unless you need to recover a license for use elsewhere).
Disabling instances is a 60 second activity usually. Visual step-by-step instructions are shown below.
SQL Server Reporting Services(name)
Disabling instances results in no memory or CPU usage while maintaining immediate availability, if required. If you are dealing with multiple ISV offerings on the same SQL Server instance, there is always the possibility of peculiarities between offerings, which may make it difficult to consolidate the databases to one instance. My experience is that this occurs rarely, but it is known to happen. Some offerings require explicit SQL Server settings, which should be visible on the Server Properties dialog in SSMS.