Re: SQL Server 2005 - How many Instances on a physical Server?
- From: Ekrem Önsoy <ekrem@xxxxxxxxxxxx>
- Date: Thu, 24 Jan 2008 11:30:20 +0200
5 different SQL Server Intance means five different SQL Server services and other SQL Server related services (such as SQL Server Agent etc.). As you already guessed this does not look like the ideal solution.
Why does your app needs a dedicated instance of SQL Server?
Are you using virtualization? (Virtual Server \ Virtual Machines...). Recently I got this multi-instance licensing question from another user and redirected the question to a guy from Redmond. He answered that "you can install multi instances of SQL Server 2005 on a physical computer (I'm not talking about the virtualization here, for that question check out the link that Ben has already provided) and you need only one license of SQL Server 2005. Server license or Processor License, it does not matter".
--
Ekrem Önsoy
"Sven W." <SvenW@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:44BC2AC6-3B5B-4715-B22B-98A39E75E4FF@xxxxxxxxxxxxxxxx
Hi Newsgroup,
I have an application that stores its data on MSSQL 2005. The application
needs its own MSSQL 2005 instance.
Is it possible to run about 4-5 different instances on a single physical
Machine? I admit that this solution is not the best, but it is a work around.
Does anyone have experience with this?
How can I compare the performance impact between 5 instances with 1 database
amd 1 instance with 5 databases ?
Do I need for every single instance its own license ?
Best Regards
Sven
.
- Prev by Date: Re: Urgent problem about SQL Server
- Next by Date: DB maintaines plan Failed!
- Previous by thread: Re: Urgent problem about SQL Server
- Next by thread: DB maintaines plan Failed!
- Index(es):
Relevant Pages
|
