登入

Microsoft.com

Microsoft

Remove From My Forums

Question about reduce the cost of upgrade. (Non-Technical)

問題
0

登入以投票

Hi

The company that I am working on is Planning to upgrade the Database server from SQL 2000 to SQL 2005/2008

We had 4 SQL Server all the them are SQL 2000, 2 main Database Server is running of windows 2000 and other 2 is running on Window 2003.

My Company would like to use the Enterprise edition of SQL Server.

We knew that SQL 2008 require Win2003 or above. It seems like upgrade to SQL 2005 will be cheaper. But we may need to spend more again to upgrade to SQL 2008 in a year or 2.

Could you give me some advice is there any way I can get upgrade price cheaper?
Is there any Microsoft program that I can join, so that I can get the software cheaper ...etc

Do you think it is ok to run the production SQL Server inside a virtual Machine?

Thanks in advance.

2008年11月24日上午 11:01

回覆

|

引述

解答

0

登入以投票

You can allocate server resources between instances, but can't do that between databases in same instance.

2008年11月25日下午 08:22

回覆

|

引述

所有回覆

0

登入以投票

Don't run production sql on VM.

2008年11月24日下午 07:17

回覆

|

引述
0

登入以投票

Will you consider consolidating your SQL Servers, e.g. install multi-instances on a physical server or migrating databases from several SQL instances to 1 SQL instance?

2008年11月24日下午 08:14

回覆

|

引述
0

登入以投票

Hi,

Thanks for you advice. If I run Multi-instances on a physical server, When of of the database need to do a very heavy task, E.g. a lots of Join, Update, Insert, will it affect the performance on other instance of SQL Server?

Will the performance different if I have multi-instance on a physical server or putting all the databases into the same SQL instance?

Thanks again = )

2008年11月24日下午 09:36

回覆

|

引述
0

登入以投票

You can allocate server resources between instances, but can't do that between databases in same instance.

2008年11月25日下午 08:22

回覆

|

引述