By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
What are the pros and cons of installing multiple instances of SQL Server 2005 on a machine in order to monitor multiple projects vs. installing multiple databases within the same instance?
I've done both in different projects. Resource-wise, I haven't really seen big differences. With multiple instances, you do have a bunch of things duplicated but it's not that serious. It also depends on the level of activity. If they're both likely to be active, you'll do better with a single instance as you get a shared lot of memory for proc cache, etc. But two instances of SQL Server do seem to share memory pretty well. The issue is often more to do with whether the two instances have the same admin relationships. Are they the same administrators?
Dig Deeper on Microsoft SQL Server Installation
Related Q&A from Greg Low
Should developers be granted permissions to production queue in a SQL Server environment? See why expert Greg Low suggests proc access by WITH ...continue reading
A SQL Server application that needs user permission to create and modify tables in SQL Server 2005 may be handled best via a schema.continue reading
Find how to save stored procedure output to the network drive via SQL Server Management Studio.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.