Multiple SQL Instances
Posted on 2014-07-31
We have a client with one SQL Server 2012 license running an Active/Passive cluster. the server is running a few databases (about 20 mostly Sharepoint, Citrix PVS, Citrix XenAPP datastore etc.)
We have been told by a 3rd party that we should Create a second Instance on the same box and move our AX 2012 Databases to it (that its "critical"), however were not seeing any real issues that suggest any problem with the database server. What metrics can we monitor to ascertain whether this there are any issues that really would benefit from a separate instance.
We are aware that its "Best Practice" that's not what i am asking, I'm simply asking what performance indicators would identify a need for this.
Aside from memory isolation and a separate TempDB (were not suffering from much TempDB contention), what performance benefits does it provide?