Solved

SQL 2012 could use more GB RAM?

Posted on 2014-10-23
6
188 Views
Last Modified: 2014-10-30
the workstation has both sql 2008r2 and also 2012 installed together. (both 32 bit on a 32 bit machine with 32 bit win7).

it seems just from user experience that sql 2012 'seems' to be running slower than if just ran sql 2008r2. could it be justified from any Microsoft documents that sql 2012 could use few more GB Ram for better performance, everything else being the same.
0
Comment
Question by:25112
6 Comments
 
LVL 32

Assisted Solution

by:ste5an
ste5an earned 100 total points
ID: 40401259
On a 32bit host?

No way. AWE support is no longer available since SQL Server 2012. See Breaking Changes to Database Engine Features in SQL Server 2012:

Support for AWE
32-bit Address Windowing Extensions (AWE) support is discontinued. This might result in slower performance on 32-bit operating systems. For installations using large amounts of memory, migrate to a 64-bit operating system.

You must (and honestly already should) change to a 64bit host.
0
 
LVL 78

Assisted Solution

by:David Johnson, CD, MVP
David Johnson, CD, MVP earned 100 total points
ID: 40401263
right now both sql servers are competing for the same amount of ram.  The default is to use all available ram.  you should only have 1 version of sql server running or you have to double your ram requirements.  Each instance of SQL Server the recommended amount of ram is 2 GB or more.. So with only 4GB to play with because of the 32bit OS both are memory starved.
0
 
LVL 45

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 200 total points
ID: 40401297
You can still AWE in SQL Server 2008R2 so it can reach 16GB of RAM. Check the MSDN article.
About the SQL Server 2012 instance there's nothing you can do.
0
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 
LVL 57

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 100 total points
ID: 40401828
Adding on to David's comment, I've often found self throttling of memory not to work well when more than one piece of software has that feature.

Once a machine gets over 80% or so of memory capacity, you can really see some significant slow downs.

Consider capping the amount of memory each SQL server instance will use.   With that done however, you still may not find performance acceptable, but the machine will stay responsive.

Jim.
0
 
LVL 5

Author Comment

by:25112
ID: 40402115
I forgot to mention the machine has 4GB RAM in all.

If I ran only SQL 2008R2 or only SQL 2012 at one time, should I expect same response time (as there is no competition for memory) or even in that will SQL 2008R2 response be better?

or
will the below become regardless true even in the 4GB environment
"This might result in slower performance on 32-bit operating systems. For installations using large amounts of memory, migrate to a 64-bit operating system."
 ?
0
 
LVL 45

Accepted Solution

by:
Vitor Montalvão earned 200 total points
ID: 40402304
If I ran only SQL 2008R2 or only SQL 2012 at one time, should I expect same response time (as there is no competition for memory) or even in that will SQL 2008R2 response be better?
Since you can enable AWE in the SQL 2008R2 instance it can use up to 4GB so I would say that SQL 2008R2 will response better. Anyway, with that short of RAM I would never install two instances of SQL Server in that machine.

"This might result in slower performance on 32-bit operating systems. For installations using large amounts of memory, migrate to a 64-bit operating system."

For years that I don't work with 32bit OS anymore. That was a relief and Microsoft is pushing is clients to do the same by not supporting 32bit in their earlier products versions.
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
This video discusses moving either the default database or any database to a new volume.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now