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.
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. |
 |
|
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. |
 |
|
Jahanzaib
Posting Yak Master
115 Posts |
Posted - 2011-04-15 : 15:17:25
|
Its depend on the Server specification,if you have enough hardware like1-CPU2-RAM3-SpaceIf you create 2 database on a single instance then you take advantage on the resource as AWE,Max Threads and NUMAIf you create 2 instance for each database then each instance has it own memory ,own log writer ,db writer etcTotally Depends on the available HardwareRegards,Syed Jahanzaib Bin HassanMCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBA |
 |
|
gregoryagu
Yak Posting Veteran
80 Posts |
Posted - 2011-04-17 : 08:07:39
|
Thanks Syed, good points.Greg |
 |
|
|
|
|
|
|