Multiple Instances SQL2K and 2005

Hi, we have a 2 node cluster running Server 2003 with a single instance of
SQL 2005. We are looking to migrate as many apps as possible to SQL 2005,
but will likely need to keep a SQL2000 instance. In addition, we want to
isolate some of the SQL databases that are web accessible and will setup an
instance for that. So, are there any reservations running this:
(2) SQL 2005 instances
(1) SQL 2000 instance
on the same cluster? We have Enterprise edition of the OS and SQL Server.
We plan to run a multi instance setup with an active and passive node so all
3 instances would run on the same node. The hardware should be able to
handle all 3 instances.
Also, any special steps to install SQL service packs in this scenario?
Thanks,
TJ
TJ,
There is no issue running SQL 2000 and SQL 2005 on the same machine. I have
done so in Production with no issues. Infact I currently have SQL 2000, SQL
2005 and SQL 2008 installed on my laptop side by side.
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration /
Microsoft Office SharePoint Server 2007: Configuration)
MCITP (dbadmin, dbdev)
"TJ" wrote:

> Hi, we have a 2 node cluster running Server 2003 with a single instance of
> SQL 2005. We are looking to migrate as many apps as possible to SQL 2005,
> but will likely need to keep a SQL2000 instance. In addition, we want to
> isolate some of the SQL databases that are web accessible and will setup an
> instance for that. So, are there any reservations running this:
> (2) SQL 2005 instances
> (1) SQL 2000 instance
> on the same cluster? We have Enterprise edition of the OS and SQL Server.
> We plan to run a multi instance setup with an active and passive node so all
> 3 instances would run on the same node. The hardware should be able to
> handle all 3 instances.
> Also, any special steps to install SQL service packs in this scenario?
> Thanks,
> TJ
>

Multiple instances ready for Production prime-time?

Hello,

Is the multiple instances capability of SQL2K mature enough for a
Production system?

We're looking at upgrading our hardware but the proposed solution
calls for consolidating two currently separate SQL Server's onto one
machine with two CPU's.

Of the current two servers, one is for OLTP (~800Mb) and the other for
reporting (some ad-hoc, some canned queries, 2-3Gb). We purge the OLTP
db nightly and archive the purged data in the reporting server where
it stays for a couple of months before getting purged from there.

Maybe I'm being overly cautious here but the OLTP system is especially
time-sensitive. If anything causes it to slow down significantly we
lose $$$.

Thanks,

Martin V.mvirta@.olgc.on.ca (Martin V.) wrote in message news:<6542479.0401131417.51f0734a@.posting.google.com>...
> Hello,
> Is the multiple instances capability of SQL2K mature enough for a
> Production system?
> We're looking at upgrading our hardware but the proposed solution
> calls for consolidating two currently separate SQL Server's onto one
> machine with two CPU's.
> Of the current two servers, one is for OLTP (~800Mb) and the other for
> reporting (some ad-hoc, some canned queries, 2-3Gb). We purge the OLTP
> db nightly and archive the purged data in the reporting server where
> it stays for a couple of months before getting purged from there.
> Maybe I'm being overly cautious here but the OLTP system is especially
> time-sensitive. If anything causes it to slow down significantly we
> lose $$$.
>
> Thanks,
> Martin V.

I must admit that I've never used multiple instances for production,
but I would also be wary of this proposed approach. The two instances
will always be competing for system resources at some level - while
you can assign each to a CPU, and also limit the memory avilable to
each instance, if there is a usage 'spike' in the OLTP system, it may
be that there are no spare system resources to respond. In addition,
if the two instances use the same I/O subsystem, then long-running
queries on the OLAP side may slow down OLTP access to the disks.

Personally, I see the value of instances in situations where you need
to test something like a new replication topology but you don't have a
whole bunch of physical servers. In this case, multiple instances are
a good way to verify that the functionality works, although it's not
easy to test performance in a meaningful way without an accurate
physical system.

In any event, you should really test the proposed configuration to get
a proper answer, and especially under stress or limit conditions.

Simon

multiple instances

Can I have multiple instances of SQL2K on Win 2K? If so, please adivse how.
Thanks.Yes. max 16 instances
"supernova" <abc@.yahoo.com> wrote in message
news:e$LLTt9sDHA.2492@.TK2MSFTNGP12.phx.gbl...
> Can I have multiple instances of SQL2K on Win 2K? If so, please adivse
how.
> Thanks.
>|||How do you do it?
"realgz" <gz_ho@.hotmail.com> wrote in message
news:eJazoL%23sDHA.2304@.tk2msftngp13.phx.gbl...
> Yes. max 16 instances
> "supernova" <abc@.yahoo.com> wrote in message
> news:e$LLTt9sDHA.2492@.TK2MSFTNGP12.phx.gbl...
> > Can I have multiple instances of SQL2K on Win 2K? If so, please adivse
> how.
> > Thanks.
> >
> >
>|||How about SQL 7 on Win 2K?
"realgz" <gz_ho@.hotmail.com> wrote in message
news:eJazoL%23sDHA.2304@.tk2msftngp13.phx.gbl...
> Yes. max 16 instances
> "supernova" <abc@.yahoo.com> wrote in message
> news:e$LLTt9sDHA.2492@.TK2MSFTNGP12.phx.gbl...
> > Can I have multiple instances of SQL2K on Win 2K? If so, please adivse
> how.
> > Thanks.
> >
> >
>|||No.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"supernova" <abc@.yahoo.com> wrote in message news:OOvxeh%23sDHA.3496@.TK2MSFTNGP11.phx.gbl...
> How about SQL 7 on Win 2K?
> "realgz" <gz_ho@.hotmail.com> wrote in message
> news:eJazoL%23sDHA.2304@.tk2msftngp13.phx.gbl...
> > Yes. max 16 instances
> > "supernova" <abc@.yahoo.com> wrote in message
> > news:e$LLTt9sDHA.2492@.TK2MSFTNGP12.phx.gbl...
> > > Can I have multiple instances of SQL2K on Win 2K? If so, please adivse
> > how.
> > > Thanks.
> > >
> > >
> >
> >
>|||Install SQL Server several times. Only one can be a default instance, the others has to be named
instances. You select whether to install a default or named instance (and the name) in the setup
program.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"supernova" <abc@.yahoo.com> wrote in message news:%23pCbzg%23sDHA.4056@.TK2MSFTNGP11.phx.gbl...
> How do you do it?
>
> "realgz" <gz_ho@.hotmail.com> wrote in message
> news:eJazoL%23sDHA.2304@.tk2msftngp13.phx.gbl...
> > Yes. max 16 instances
> > "supernova" <abc@.yahoo.com> wrote in message
> > news:e$LLTt9sDHA.2492@.TK2MSFTNGP12.phx.gbl...
> > > Can I have multiple instances of SQL2K on Win 2K? If so, please adivse
> > how.
> > > Thanks.
> > >
> > >
> >
> >
>|||Strictly speaking, SQL7 doesn't support multiple instances on a server. But
if I could stretch it a bit, I may argue that SQL7 actually supports two
instances on a server because it does support the active\active clustering
configuration, and when the SQL servers run on the same node (server), you
are in fact running two SQL7 instances on the server. Of course, this is not
the same as multiple instances supported by SQL2000.
--
Linchi Shea
linchi_shea@.NOSPAMml.com
"supernova" <abc@.yahoo.com> wrote in message
news:OOvxeh%23sDHA.3496@.TK2MSFTNGP11.phx.gbl...
> How about SQL 7 on Win 2K?
> "realgz" <gz_ho@.hotmail.com> wrote in message
> news:eJazoL%23sDHA.2304@.tk2msftngp13.phx.gbl...
> > Yes. max 16 instances
> > "supernova" <abc@.yahoo.com> wrote in message
> > news:e$LLTt9sDHA.2492@.TK2MSFTNGP12.phx.gbl...
> > > Can I have multiple instances of SQL2K on Win 2K? If so, please adivse
> > how.
> > > Thanks.
> > >
> > >
> >
> >
>