Performance effect if SQL2000 and SQL2005 on same box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Han - 13 Mar 2008 18:49 GMT

Hi everyone,

I am going to upgrade SQL2000 to SQL2005 because 3rd party application
requires SQL2005. My plan is upgrade my current database on SQL2000 to
SQL2005, but keeping SQL2000 for fall back plan.

Is there any impact on performance if I have SQL2005 and SQL2000 running on
the same machine?

Thanks alot for any help in advance.

Han.

Reply to this Message

Tibor Karaszi - 13 Mar 2008 19:14 GMT

You will obviously have resource usage of you have both service started at the same time. But having
2000 installed but not started will not degrade performance of a 2005 install on that machine.

Signature

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

> Hi everyone,
>
[quoted text clipped - 8 lines]
>
> Han.

Reply to this Message

Linchi Shea - 13 Mar 2008 19:50 GMT

The issues are not different from running two SQL2000 instances or two
SQL2005 instances.

Linchi

> Hi everyone,
>
[quoted text clipped - 8 lines]
>
> Han.

Reply to this Message