March 2, 2010 at 3:02 am
Hi, I',m tearing my hair out trying to find out a definitive answer to how much memory SQL Server can address. We currently run 32-bit SQL Serer 2000 on 32-bit OS. We now have a replacement server which is 64-bit OS and has a lot more RAM (16GB). If I continue to run 32-bit SQL Server 2000 on the 64-bit OS, can it address more than 4GB of the available memory? If I upgrade to 2005 32-bit, can it address more than 4GB? Or, do I have to upgrade to 64-bit SQL Server to take advantage of the extra memory? I've found articles which completely contradict each other on this. Any advice would be greatly apreciated.
March 2, 2010 at 3:21 am
Provide more and specific detail like What OS version and edition you will be using and what SQL Server edition you are considering?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 2, 2010 at 3:29 am
The OS version is Windows 2003 Server 64-bit. We currently run SQL Server 2000 32-bit. I'd like to upgrade to a later version but have just found out our 32-bit app won't run on 64-bit. So I'm stuck with 32-bit. If I go to SQL Server 2005 32-bit on the 64-bit OS, will it be able to access more than 4GB?
Thx
March 2, 2010 at 3:38 am
If you use AWE, yes, providing the edition that you have can use more memory than that. Standard (and lower) are limited in what they can use
Why does the app depend on the SQL bit size? It's just accessing SQL server and, for that, it doesn't matter if the SQL is 64 bit or 32 bit. Unless there are odd linked server drivers in use that is.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 2, 2010 at 3:43 am
Thanks Gail. Does that mean to access the available memory we'll have to make the AWE tweak and be running the SQL Server Enterprise edition? i.e. Standard won't work.
Our app is Visual Basic 32-bit and my developers tell me that they've tried it on 64-bit but some dlls don't work. I'm not convinced by this and I might just try it to see if it works.
March 2, 2010 at 4:05 am
john.mansfield (3/2/2010)
Thanks Gail. Does that mean to access the available memory we'll have to make the AWE tweak and be running the SQL Server Enterprise edition? i.e. Standard won't work.
No it means you need to check what the memory limits of SQL standard edition is. It's different 2000/2005 iirc. I don't recall offhand what the limits are.
Our app is Visual Basic 32-bit and my developers tell me that they've tried it on 64-bit but some dlls don't work. I'm not convinced by this and I might just try it to see if it works.
I can fully understand it not running on a 64 bit OS, that makes perfect sense. Hence you wouldn't install it on a desktop running a 64 bit OS. However, apps connecting to SQL (using ADO/ADO.net) won't be affected by - or even know - whether SQL's 32 bit or 64 bit.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 9, 2010 at 3:21 am
hi ,
how to find os 32bit or 64bit. i am installed os xp sp2 is possible to install sql server 2005 enterprise edition 64-bit extended. plz replay me
March 9, 2010 at 3:35 am
how to find os 32bit or 64bit.
Start ==> Run ==> Wwnver
March 9, 2010 at 3:39 am
Enterprise edition is not supported on non-server operating systems. So you should be installing Enterprise edition on one of the Windows Server operating systems (Server 2003 or Server 2008)
If this is to test and play with, consider developer edition instead. The licensing costs for Enterprise edition are a little steep for personal development.
While Windows XP did have a 64 bit edition, it was not common and not that many people ran it. It's very likely that you have 32 bit XP and hence cannot install a 64 bi app.
My computer -> Properties should tell you what version you have
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 9, 2010 at 3:49 am
Joy Smith San (3/9/2010)
how to find os 32bit or 64bit.
Start ==> Run ==> Wwnver
You mean WinVer?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 9, 2010 at 4:13 am
Sorry...typo...
Yes.. Winver.
Viewing 11 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply