ms 2000 server upgrade to ms 2008 server

ms 2000 server upgrade to ms 2008 server

Post by dGVjaGllMj » Fri, 13 Mar 2009 04:24:01

I am currently looking into upgrading my ms 2000 server to a ms 2008 server
w/ a 64 bit processor.
I noticed that the highest memory upgrade I can do for this 2000 system
right now is 2GB. I know I will need at least 4GB of ram for the new O/S.

Being a newbie to all this. My question is .... Can I put 4 GB of ram in the
server now even though max is 2GB? I will be clearing out the old O/S and
installing the new one so will it make a difference?


1. I cannot upgrade MS SQL Server 6.5 to MS SQL Server 2000

2. CPU usage changed after upgrading to MS SQL Server 2000 from MS SQL Server 6.5

Hi All,

I had two Window NT 4.0 Server, say A and B... We recently upgraded
from MS SQL Server 6.5 to MS SQL Server 2000 on Computer A, and for
Computer B, I installed SQL Server 2000 from scratch. These two have a
same RAM(512MB) and CPU the setup for hardware is almost

For server A, there are around 10 connection to this SQL Server...
For server B, there are also around 10 connection to this SQL

The database for SQL Server B is a copy from SQL Server A.... I
restored the database on SQL Server B from the backup dump of Server

We have a store procedure called usp_GetMemo(ID Interger) ... we feed
ID number to this store procedure and return its return Description...
this table has ID column and it's Non-Cluster index, allow the
duplicate row... there are 1.7 million records for this table...

Here is problem... whenever i execute more than 100 times for this
store procedure(usp_GetMemo(ID)) continuously, the CPU usage of
Computer A is 3 times bigger than computer B....

I did run the command "DBCC DBReindex" , "Update Statistics" for this
table on computer A, but did not make any difference...

Keep in mind that Computer A has been upgraded to SQL server 2000
while Computer B installed from scratch... would that make difference
somehow?? Before the upgrading, the CPU usage of computer A is the
same as Computer B...

Any help will be really appreciated,
Thanks alot,

3. Interface between the MS Sql Server 2000 and the MS Exchange Server 2000

4. Using MS SQL Server 2005 Enterprise Manager with MS SQL Server 2000

5. best pratices for transferring MS SQL Server 7 database to MS SQL Server 2000

6. Upgrading from MS Project Server 2002 to MS Project Server 2003

7. executing a stored procedure on MS SQL Server 2000 within MS Excel 2000

8. MS Office 2000, MS Win 2000 Adv Server

9. Problem by design - MS-SQL Server 2000 and MS-Access 2000 project.

10. Upgrading from SQL Server 2000 Standard to SQL Server 2008 Standard or Enterprise?

11. move to new windows server and upgrade sql server 2000 to 2008

12. Linked Server Lock up on : MS-SQL Server 2000(SP3a) + Windows Server 2003 STD

13. ms Sql server 2000 installed in windows server 2000

14. Is it possible to run MS SQL Server 2008 std on Windows Server std 2003r2?

15. MS Office 2008 [Entourage 2008] and CalDAV [iCal Server]