Just after some advice in regards to sql instances.
At the moment most of our services which we would have hosted internally have been moved to the cloud via the supplier. Some DB's are still in house on a 2012 box running sql 2012.
At the moment I have created an instance for each db and allocated more than enough resources for the box (VM) for each instance. Biggest DB's being finance, followed by slightly smaller one for mail archiving and 3 smaller ones. The 3 small ones wouldn't be heavy on read and writes so it's not a worry.
The reason for creating an instance for each db is security as at times we need to allow the supplier into carry out work on the db and don't want them to have access to the other db's.
What are peoples thoughts on instances for each db? I don't want to create two many, but from general reading some people say it's fine as long as there is enough resources etc while others disagree with creating instances at all.
I have a need for some more db's but they are general and don't pose a security risk so instead of creating a new instance for each I might plan on creating a "GENERAL" instance and dumping them in there.
At the moment most of our services which we would have hosted internally have been moved to the cloud via the supplier. Some DB's are still in house on a 2012 box running sql 2012.
At the moment I have created an instance for each db and allocated more than enough resources for the box (VM) for each instance. Biggest DB's being finance, followed by slightly smaller one for mail archiving and 3 smaller ones. The 3 small ones wouldn't be heavy on read and writes so it's not a worry.
The reason for creating an instance for each db is security as at times we need to allow the supplier into carry out work on the db and don't want them to have access to the other db's.
What are peoples thoughts on instances for each db? I don't want to create two many, but from general reading some people say it's fine as long as there is enough resources etc while others disagree with creating instances at all.
I have a need for some more db's but they are general and don't pose a security risk so instead of creating a new instance for each I might plan on creating a "GENERAL" instance and dumping them in there.
