November 10, 2008 at 12:07 pm
Hi, I have the next question.
I must to design a SQL Server, these have been a holder to Data Warehouse and others data bases.
I'll think two ways to work, one create all databases in the same instances, other create one instances for Data Warehouse and other instances for the last of databases.
What will be the advantages for one or other way to work?
Thanks.
November 10, 2008 at 12:10 pm
one instance, SQL Server can manage resources within itself.
multiple instances - resource contention, tempdb separation.
I wouldn't necessarily look to put a warehouse on the same instance as other databases. Typically it is loading and working with larger amounts of data than the other instances and needs more resources.
November 10, 2008 at 12:14 pm
So you recommend that use two instances.
These can have some problems the ports of communications or some other term to have a count?
November 10, 2008 at 12:20 pm
If you must use one physical server, I'd do one instance. Two instances can be tricky and it sounds like you don't really know how this works. In that case I'd go with the simple solution, one instance.
November 10, 2008 at 12:31 pm
Thks.
January 13, 2009 at 6:05 am
If I have two instances in the same server, I have two services of SQL working in the same time, and I need more resources for the server. I have't clear if these two instances can be problems with the ports of SQL or another problem working ion parallel.
I need these configuration because I manage de warehouse only, no the other data base and contain diferent information tha one or other can be seen.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply