OpenText often installs with two SQL Server databases. One database is for OpenText and the other database is for Microsoft SharePoint Server. This often leads to random acts of installation including putting two or more instances of SQL Server on the same computer. This situation should be avoided for several reasons:
A solid rule of thumb is to have just one SQL Server instance per machine to get the best performance. In this series of posts I will cover:
This type of issue can occur with SQL Server instances running on multiple virtual machines on the same machine. There are valid reasons for running SQL Server on a virtual machine, but it should never be done unless there is a solid requirement.
The steps to determine the number of installed instances on the same machine are shown by the visual step-by-step below.
Verify that nothing breaks, different databases sometimes require different server configurations.
Multiple instances of SQL Server running on the same machine is an easy way to lose performance and scalability. Often when addressing tuning issues, we focus on what is happening inside of a SQL Server and we miss the forest of instances sitting on the same box. The above steps take less than a minute to perform and clarify if there is an issue.