64bit windows and 32bit SQL

I have a 64bit Windows Server machine running a 32bit version of SQL 2000
Standard. I am running into 'insufficient memory available' errors. I
upgraded the RAM from 4GB to 8GB, but the problem persists.
Do I need to use the /PAE or /3GB boot switch even though I am running a
64bit version of Windows? Do I need AWE setup for SQL to access more
memory?
I figure this has more to do with the 32 bit version of SQL not being able
to access all the memory. Any ideas?SQL 2000 Standard is limited to 2GB RAM.
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
http://kevin3nf.blogspot.com
"Marc Speed" <vw_marc@.hotmail.com> wrote in message
news:egONT2E$GHA.1220@.TK2MSFTNGP04.phx.gbl...
>I have a 64bit Windows Server machine running a 32bit version of SQL 2000
>Standard. I am running into 'insufficient memory available' errors. I
>upgraded the RAM from 4GB to 8GB, but the problem persists.
> Do I need to use the /PAE or /3GB boot switch even though I am running a
> 64bit version of Windows? Do I need AWE setup for SQL to access more
> memory?
> I figure this has more to do with the 32 bit version of SQL not being able
> to access all the memory. Any ideas?
>
>|||> I am running into 'insufficient memory available' errors.
Throwing more memory at the problem is probably not the solution. Have you
installed SP4? Do you get the error with only certain types of queries?
Hope this helps.
Dan Guzman
SQL Server MVP
"Marc Speed" <vw_marc@.hotmail.com> wrote in message
news:egONT2E$GHA.1220@.TK2MSFTNGP04.phx.gbl...
>I have a 64bit Windows Server machine running a 32bit version of SQL 2000
>Standard. I am running into 'insufficient memory available' errors. I
>upgraded the RAM from 4GB to 8GB, but the problem persists.
> Do I need to use the /PAE or /3GB boot switch even though I am running a
> 64bit version of Windows? Do I need AWE setup for SQL to access more
> memory?
> I figure this has more to do with the 32 bit version of SQL not being able
> to access all the memory. Any ideas?
>
>