I have a database server that hosts multiple minor databases not related to SharePoint and I want to utilize this server for a SP2010 environment database role.
What are the implications of installing a dedicated NAMED SQLServer instance (e.g. SERVER\SPInstance) vs reusing the default instance (SERVER\MSSQLSERVER) containing other user databases?
I as understand it, a named instance has its own dedicated windows services and system databases. Sounds like pure extra overhead to me, but I'm thinking maybe SharePoint would benefit somehow from a dedicated named instance.
I suppose the main things on my head regarding the implications are:
Portability (i may need to move 1 or more CDB's eventually)
Thanks in advance for any thoughts shared.