Hello. We are getting a new server with the following specs:
Dell PowerEdge R710
12GB Memory 1333MHZ
(2) Xeon E5503, 2.0GHZ, 4M Chache, 800MHZ, Max Mem Processors
We need to run SQL 2000 and possibly SQL 2005. I am planning on turning this into a virtual server. I would like to get the most robust SQL environment and trying to decide on SQL Enterprise vs Standard. My question revolves around the processors.
If I creat a Virtual server with:
-64 Bit Server 2003
-6 GB Ram
What should I do with SQL? Should I get enterprise version so it can use more than 2gb of RAM? I noticed that enterprise is only licensed for 1 processor. Am I correct in assuming that SQL 2000 Standard will use both processors, but only 2gb of RAM. But, SQL Enterprise will use only one processor but more than 2gb of RAM? Do I have to decide on Processor power vs memory power?
Any other words of wisdom related to my setup would be greatly appreciated.