mohsinabdul (2/14/2011)
Do you mean that 42 DBs will be less for 3 servers? i would prefer 3 a and 2 p but here we have cost constraints
Sorry dont under stand your response.
If you have 3 instances, you have 3 lots of system db's, 3 lots of sqlsvr.exe memory usage, 3 lots of clr buffer cache memory (and all the other memory buffers which use mem outside the core .exe)...
What I am saying is running 42 db's on 1 instance, uses less resources (mem and cpu) then 42 db's on 3 instances on the same box!
Adam Zacks-------------------------------------------Be Nice, Or Leave