SQL 2000 64bit

[DebiJo]

If nothing else runs on a server other than SQL.... The client application all resides on the client (which is 32 bit only). And there are no extended stored procedures.... Are there any gotcha's to running the 64 bit SQL on a 64 bit processor? The 32 bit app will connect just the same as it did to SQL 32-bit, right?

Thanks in advance,
Debi
SQL 2000
Windows 2003

 

[Catadmin]

I've never worked with SQL DataCenter and don't know anyone who has. Here's what little I do know about it.

From what I understand, 64 bit machines with 64 bit SQL are only available OEM (original equipment manufacturer). These are for the huge DataCenter / Cluster operations and the machines & SQL have to be special ordered.

That being said, I don't think your 32 bit client apps will have any problem running against the databases. Microsoft supposedly knew that there weren't any apps out there that ran 64 bits at the time they released SQL.

<facepalm> Then again, this is Microsoft. They might not care.


Catadmin - MCDBA, MCSA
Remember, "Work" is a four letter word. And you know what your mother told you about using four letter words!

 

[mrdenny]

First,
SQL 2000 64bit comes in Enterprise Edition and Developer Edition.

Any VAR should be able to sell it to you. It's not a special order item.

The 64bit SQL FAQ is here

http://www.microsoft.com/sql/64bit/howtobuy/64faq.asp

and the SQL 64bit home page is here

http://www.microsoft.com/sql/64bit/default.asp.

Back to the origional question. There should be no gotchas to running sql 64bit on 64bit hardware and os. The clients don't even need to be told that it's a 64bit machine in the background. Everything connects through ODBC which doesn't care if it's 16, 32 or 64 bit SQL Server on the backend.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)

 

[IBACFII]

What about a 32 bit SQL 2000 on a Win 2003 x86? Will SQL have problems with this or will it just run 32bit and the OS will run 64bit?

IBACFII

 

[mrdenny]

If you have Windows 2003 x86 that's the 32bit edition of Windows. Only the 32bit version of SQL will run on the 32bit version of Windows.

If you have MLV licensing from Microsoft order the 64bit software pack for SQL Server. 64bit SQL uses the same license and CALs are 32bit SQL. If you've got 64bit OS there is no reason to not use 64bit SQL.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[IBACFII]

Isn't 64 bit SQl 2000 only for the Itanium? not a AMD 252? I thought that sql2k5 is the only one that will support 64bit amd? Maybe I am wrong. We are getting a new server and were thinking a quad proc amd based machine running win 2003 with SQL. I have heard that SQL 32bit and SQL64 cost the same but the proc support might be a problem. What do you think? SQL 2k5 would be an option if it were out.

 

[mrdenny]

It shouldn't matter what the processor is. The OS should handle that.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[MDXer]

Here is a quote from an Article from SQL Server Magazine. That suggests SQL 2000 64bit on an Opteron depends on the version of the CPU.

http://www.windowsitpro.com/Article/ArticleID/44516/44516.html?Ad=1

I think 64-bit computing provides a compelling argument to consider buying AMD processors today, even if you don't plan on shifting to 64-bit computing for a year or more. In the past, SQL Server customers haven't given that much consideration to AMD-based boxes. There simply wasn't a compelling enough argument to leave the "safe" Intel route. However, AMD now offers the Opteron line of processors, which can run native 32-bit and 64-bit systems. These processors are priced considerably less than Itanium-based systems. SQL Server 2000 64-bit doesn't run on the 64-bit native mode of the Opteron, but 64-bit SQL Server 2005 will run on Opteron servers you can buy today. SQL Server 2000 32-bit will run on those same servers.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[mrdenny]

Hugh. No idea. We are an HP shop. Everything here is Intel.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[IBACFII]

HP shop? The server that we are looking at is from HP and its AMD?

IBACFII

 

[mrdenny]

Yeah, looking at the HP site I do see some of the servers are available with an AMD chip.

Give HP sales a call. They should know what is certified to run on each server.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[IBACFII]

Update.
Win 2003 64 bit will run on an AMD OPteron machine and will be able to run sql 2000 32 bit version with out any compatibility problems or so says M$

 

[ITsmyfault]

fwiw a buddy of mine who works for the consulting arm of a major tech giant (who shall remain nameless) was on a test install of Server 03 64bit with SQL 64bit not long ago here in NYC at a major client's site and he said it was a cluster fsck.. not ready for prime time.
IME MSFT has traditionally taken 3 tries at stuff it get it solid, and I don't want to be on the .9 release of their 64bit port of a 32 bit operating system. Not in production at least!
I like sleep too much.

jm2c, ymmv and the usual disclaimers apply..

Joe