Running Two instances on same server

Hello,
Can anyone tell me the impact of running two instances on
the same server.
The reason is we want to separate out development and
production, but we don't have access to another server.Peter
> Can anyone tell me the impact of running two instances on
> the same server.
I think the instance consumes a memory and another instance will not be
able to use the memory consumed by the first one.
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:a04401c40686$c3762260$a001280a@.phx.gbl...
> Hello,
> Can anyone tell me the impact of running two instances on
> the same server.
> The reason is we want to separate out development and
> production, but we don't have access to another server.|||Thanks Uri, apart from that will everything work ok ?
Peter

>--Original Message--
>Peter
on
>I think the instance consumes a memory and another
instance will not be
>able to use the memory consumed by the first one.
>"Peter" <anonymous@.discussions.microsoft.com> wrote in
message
>news:a04401c40686$c3762260$a001280a@.phx.gbl...
on
>
>.
>|||Yep, it is a good idea to have one instance for production and another for
develping.
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:a63601c4068f$82d343b0$a101280a@.phx.gbl...
> Thanks Uri, apart from that will everything work ok ?
> Peter
>
> on
> instance will not be
> message
> on|||Peter wrote:

> Thanks Uri, apart from that will everything work ok ?
If you are doing a lot of IO intensive work, then this has the
possibility of greatly affecting the live instance. In any SQL server
instance you have a few things you need to isolate and watch
* CPU
* MEMORY CAPACITY
* MEMORY IO
* DISK CAPACITY
* DISK IO
* NETWORK IO
If you are just using the secondary instance for testing I would prefer
to have SQL installed on my workstation versus hoping that the test
environment wont hurt the production. You can get a SQL Server 2000
Developer Edition for under $50 which will install on pretty much any
current windows platform.
Aaron Weiker
http://blogs.sqladvice.com/aweiker
http://aaronweiker.com/|||As others have said, Yes it will work. However it is generally a bad idea...
I would ONLY consider doing this IF the production server is way over
configured and the additional instance will NOT hurt production. ( On the
other hand, it might be a good thing to hurt production a little - from a
political point of view.. The customers complain to their manager about
response. Their manager talks to you, and you let them know you need, but do
not have a test server - maybe you'll get the money..)
If this is a single developer environment, I would use the dev edition on my
own server ...
Wayne Snyder MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
(Please respond only to the newsgroups.)
I support the Professional Association for SQL Server
(www.sqlpass.org)
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:a04401c40686$c3762260$a001280a@.phx.gbl...
> Hello,
> Can anyone tell me the impact of running two instances on
> the same server.
> The reason is we want to separate out development and
> production, but we don't have access to another server.