Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Two instances or one shared database?

Author  Topic 

gregoryagu
Yak Posting Veteran

80 Posts

Posted - 2011-04-07 : 20:56:40
Which is better in terms of resource usage: Two instances of Sql Server 2008 on the same computer, or just put both databases in the same instance?

So far I have had two instances, but I notice the two processes end up taking up quite a bit of memory and I thought maybe I should combine them both into one instance.

I don't know of any good reason to have both instances - they were formerly set up like that.

Greg

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2011-04-08 : 03:02:02
An instance will take up quite a lot of resources so a single instance will always take up less. The consideration should be how much separation you want - do you want to be able to take down or cash an instance and leave the other running, do you want different server level access, be able to have two different databases with the same name, .....

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

gregoryagu
Yak Posting Veteran

80 Posts

Posted - 2011-04-09 : 22:44:47
OK, thanks. I think I am going to combine them, as I don't really need the seperation.
Go to Top of Page

Jahanzaib
Posting Yak Master

115 Posts

Posted - 2011-04-15 : 15:17:25
Its depend on the Server specification,if you have enough hardware like

1-CPU
2-RAM
3-Space

If you create 2 database on a single instance then you take advantage on the resource as AWE,Max Threads and NUMA

If you create 2 instance for each database then each instance has it own memory ,own log writer ,db writer etc

Totally Depends on the available Hardware

Regards,
Syed Jahanzaib Bin Hassan
MCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBA
Go to Top of Page

gregoryagu
Yak Posting Veteran

80 Posts

Posted - 2011-04-17 : 08:07:39
Thanks Syed, good points.

Greg
Go to Top of Page
   

- Advertisement -