July 24, 2015 at 3:15 pm
Anyone installs multiple instances on a SQL server either virtual or physical?
All my company's SQL server currently only have single default instance.
I know we can install named instance besides default instance, but I have an impression that will make the administration work complicated.
Like different folders for different version, complex when doing upgrade of service pack, the file could be messed up etc.
But I really didn't work much in a heavily used multiple instances server.
Any DBA experience and recommendations?
The reason I ask is we recently have a department that they don't have a SQL license, but would want to install another SQL instance on one of our existing SQL servers to avoid to buy a SQL license for budget reason.
I would rather just install the database on the same instance other than install another instance.
Also if existing instance is 2008 and they want to install a 2012 instance, do they need to buy a license?
Thanks,
July 25, 2015 at 6:49 am
sqlfriends (7/24/2015)
Anyone installs multiple instances on a SQL server either virtual or physical?All my company's SQL server currently only have single default instance.
I know we can install named instance besides default instance, but I have an impression that will make the administration work complicated.
Like different folders for different version, complex when doing upgrade of service pack, the file could be messed up etc.
But I really didn't work much in a heavily used multiple instances server.
Any DBA experience and recommendations?
I use two instances (2012 and 2014) on a physical server, and it's functioning all well. The environment is multi-user and high-concurrent. So, if your server could allow that, then you can proceed on.
Regarding licensing, you'd better speak with your sys-admin colleagues.
Igor Micev,My blog: www.igormicev.com
July 25, 2015 at 7:22 am
sqlfriends (7/24/2015)
Anyone installs multiple instances on a SQL server either virtual or physical?All my company's SQL server currently only have single default instance.
I know we can install named instance besides default instance, but I have an impression that will make the administration work complicated.
Like different folders for different version, complex when doing upgrade of service pack, the file could be messed up etc.
But I really didn't work much in a heavily used multiple instances server.
Any DBA experience and recommendations?
The reason I ask is we recently have a department that they don't have a SQL license, but would want to install another SQL instance on one of our existing SQL servers to avoid to buy a SQL license for budget reason.
I would rather just install the database on the same instance other than install another instance.
Also if existing instance is 2008 and they want to install a 2012 instance, do they need to buy a license?
Thanks,
Quick thought, running multiple instances on the same server is a common practice. In my experience the most common reason would be the separation of data and duties, although that's not always the case.
Running different versions from which you are licensed will require a license for those instances, check with your licensing vendor for further details.
😎
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply