Opteron & SQL and Memory problem

[istolyar]

I have 2 Amd Opterons running windows 2003 and SQL 2000 with 8GB of RAM When I use 4GB I have no problems, as soon as I use switch /PAE and use all 8GB SQL crash with error "SQL2k: Process 54 generated fatal exception c0000005" Any Idias?

 

[glugglug]

Why would you use an ugly Intel hack like PAE on an Opteron? MS estimated /PAE switch to have a 30% performance penalty.

AMD CPUs do not support PAE. There would be absolutely no point for them to do so, just using a 64-bit version of the app is cleaner and faster.

 

[istolyar]

2003 Server not availible yet in 64 bit

 

[glugglug]

Try here

 

[istolyar]

It is beta. This is production server and collocation facility. I can?t afford to be beta tester at this time.

 

[MrChad]

Why do you need 8 GB of RAM for a SQL database server? If your database needs that kind of horsepower, you should really be looking at a UNIX/Oracle solution.

 

[istolyar]

Well, at this time I have no options.

 

[glugglug]

Originally posted by: MrChad
Why do you need 8 GB of RAM for a SQL database server? If your database needs that kind of horsepower, you should really be looking at a UNIX/Oracle solution.

Actually, from experience I would say a single PC running SQL server is more powerful than 5 boxes with the same hardware working together in an Oracle RAC system.

MS actually did something right. (In stealing the code from Sybase heh).