Re: multiple instances to one instance?

Pro: better use of resources -among others...

Con: Potential security issues. Be sure to remove Northwind and Pubs
databases.

I would use the /3GB setting to use more of the extra memory -perhaps
setting Max Memory to about 2.75GB.

--
Arnie Rowland*
"To be successful, your heart must accompany your knowledge."



"sturmerp" <sturmerp@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B43B29A0-B0B8-4232-ACFD-4F65E1912A3A@xxxxxxxxxxxxxxxx
I am a DBA new to SQL server. Currently, our server (win 2000 sp4 / 3GB
RAM)
has multiple instances of SQL server installed. Two of the SQL server
instances (sp3) are for accounting and the other instance (sp4) is for
db's
used in other applications.

All of the db's are slated to move to a box with updated hardware (
win2003
/ 3.5 GB RAM) running SQL Server 2000 sp4

As part of the transfer, we are considering putting all db's into a single
instance. If sp4 is not an issue for the accounting databases, there are
no
db naming conflicts and no logins gaining elevated permissions, what are
the
pros and/or cons for moving from multiple instances to a single instance?

Thanks in advance for your input,
Pat


.

Relevant Pages

  • Re: Archbishop criticizes Israel for "safrificing innocent civilians"
    ... but you never present anything pro or con to relevant points. ... who substitues his own "doctrinal statement" for the Nicene Creed. ... That only proves that you have a knack for picking bad seminaries for ...
    (soc.religion.christian)
  • Re: whats the best
    ... The latest version of BlackIce Defender is 3.5 and it does block phone home ... > PRO: Easy to use, ... > CON: If you allow an app to go through, you have to go to it and modify it ... Cookie control doesn't stop 3rd party cookie. ...
    (comp.security.firewalls)
  • Pros and Cons of the top 20 Dem Pres contenders
    ... Pro: Articulate; ... Con: L.A. Law was kind of overrated now that you think about it. ... Technically still running for president. ... Con: Potential attack ad: "Sometimes Optimus Prime is a robot, ...
    (rec.sport.football.college)
  • Re: Best way to copy whole content of HD into another
    ... Pro: Should be thoroughly tested already and allow restore of data ... Con: Copies a lot of cruft if the filesystem isn't very full. ... Usually does special and sparse files great. ...
    (comp.unix.bsd.freebsd.misc)
  • Re: Hennessy hammocks...
    ... Any pro or con comments? ... As long as you've got two trees, you have somewhere to set up your ... The straps that come with the hammock are about three feet long, ...
    (rec.outdoors.camping)