We will be having two separate vendors database solutions on our SQL Server 2000. Both applications need to be able to be stopped and started independently. It looks like "named instances" will be a good feature for us to use. How do I compare the overhead of two named instances running on a server as opposed to both apps running in one instance. I am assuming one distance is the most efficient, so how much degradation might I expect with two or three instances running?
You can assume that both apps are not system hogs although one app will be new so we really don't know that for sure. It seems like the different users accessing the proper instance with no possibility of overlap would make the two-instance scenario preferable. Also, is there any advantage to having the heavier used app being the default instance or would I be better off making them both "named"?
You are in effect running 2 SQL Servers on the same machine, so you are going to have resources for two SQL Servers used. The only real way is to test the two apps together in a single database, separately, and on different instances. I don't understand why having the need to shut down an app means you have to do anything special in SQL Server. Shutting down an app should be a feature of the application, not stopping the SQL Server.
For More Information
- Dozens more answers to tough SQL Server questions from Michael Hotek are available here.
- The Best Microsoft SQL Server Web Links: tips, tutorials, scripts, and more.
- The Best SQL Web Links
- Have a SQL Server tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical SQL Server questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
Dig Deeper on Microsoft SQL Server Installation
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.