Hi,
I am planning to have 3 (app) database intalled on one sql 2000 server, what
is the best way/s to do this?
Thanks.You could either locate all databases on the one server or install multiple
instances with each DB in its own instance. I don't really see any need for
instances though as its 6 of one or half dozen of the other. I've ran with
30+ dbs on one instance in a production environment.
"anoni" wrote:
> Hi,
> I am planning to have 3 (app) database intalled on one sql 2000 server, what
> is the best way/s to do this?
> Thanks.|||Hi,
All depends up on the resource usage for your individual application and SQL
Server edition you are going to use.
If it is enterprise edition on a Windows Advanced server you could add more
RAM (> 4 GB) and enable AWE.
After that you can have 3 databases in the same database instance.
Incase if your resource usage is less and number of concurrent users are
less then you could go for SQL Server standard edition with 2 GB of RAM
in Server and have all the 3 databases in same database instance.
Note:-
For installing multiple instance:- For each instance you need to get
seperate SQL server License.
Thanks
Hari
SQL Server MVP
"anoni" <anoni@.discussions.microsoft.com> wrote in message
news:C4E730EA-3A96-45E5-B3F5-0197749958FE@.microsoft.com...
> Hi,
> I am planning to have 3 (app) database intalled on one sql 2000 server,
> what
> is the best way/s to do this?
> Thanks.|||As long as Server is capable of handling the work, put multiple DBs in a
single instance of SQL... Maintenance is easier..
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"anoni" <anoni@.discussions.microsoft.com> wrote in message
news:C4E730EA-3A96-45E5-B3F5-0197749958FE@.microsoft.com...
> Hi,
> I am planning to have 3 (app) database intalled on one sql 2000 server,
> what
> is the best way/s to do this?
> Thanks.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment