A two-socket, AMD Opteron 6200 or 6300 series based system could have 32 physical cores, while a two-socket Intel Xeon E7-2800 series based system could have 20 physical cores.
Start evaluating SQL Server 2008 R2 Standard today.Even if your database server has a much higher amount of RAM than 64GB, it will only be able to use 64GB of RAM for each of these services.I dont really have a problem with the four processor socket limit, but I do think that a 16 physical processor core limit dvr player windows 7 is simply too low.Despite this, I recognize that some organizations simply cannot afford these extra licensing costs (even though it is still far more affordable than Oracle licensing).I would love to hear your thoughts and opinions on this!Yes, SQL Server 2008 R2 Express with Tools and SQL Server 2008 R2 Express with Advanced Services will allow 10GB databases as well.Note: There are multiple files available for this download.Once you click on the "Download" button, you will be prompted to select the files you need.Microsoft is essentially limiting you to using about 1000.00 of RAM if you are using SQL Server 2012 Standard Edition.We increased the maximum database size in SQL Server 2008 R2 Express from 4GB to 10GB.Modern, two-socket servers have 24 memory slots, so they can hold 384GB of RAM with these affordable 16GB dimms. .I would really like to see Microsoft eliminate both the RAM limit and the physical core count limit for SQL Server 2012 Standard Edition.Are any other limits changed in SQL Server 2008 R2 Express?What about CPU and memory limits?Even though you are limited to 64GB of RAM per service per instance, you should strongly consider getting a slightly larger amount, such as 72GB or 96GB, so that you can set your Max Server Memory setting to 65536 (which would be 64GB and still.
SQL Server 2008 R2 Express is still limited to 1 CPU and 1 GB or RAM.
As a DBA and consultant, I would like to see everyone running SQL Server 2012 Enterprise Edition.