What is the difference in memory requirements between SQL Server 10.x and 11.0.x?
SQL Server 11.0.x uses more memory than the previous release because of new internal data structures. When comparing performance between versions 4.9.2, 10, and 11.0.x, you will need to add more memory for System 11.0.x. Try to keep the default data cache the same size as the old data cache, and allow approximately 2 times the size of the old procedure cache, since query plans for this release are double the size of those in version 4.9.2. Note The error log displays the default cache size in K bytes, not pages as in 4.9.x or 10.x. Refer to the installation documentation for total memory requirements.
