<body><script type="text/javascript"> function setAttributeOnload(object, attribute, val) { if(window.addEventListener) { window.addEventListener('load', function(){ object[attribute] = val; }, false); } else { window.attachEvent('onload', function(){ object[attribute] = val; }); } } </script> <div id="navbar-iframe-container"></div> <script type="text/javascript" src="https://apis.google.com/js/platform.js"></script> <script type="text/javascript"> gapi.load("gapi.iframes:gapi.iframes.style.bubble", function() { if (gapi.iframes && gapi.iframes.getContext) { gapi.iframes.getContext().openChild({ url: 'https://draft.blogger.com/navbar/11356004?origin\x3dhttp://openrent.blogspot.com', where: document.getElementById("navbar-iframe-container"), id: "navbar-iframe" }); } }); </script>

Result of enabling AWE on 8GB SQL Server

AWE enables SQL Server to use ram beyond 4GB in a 32-bit architecture. Here is the "before" and "after" states on a SQL Server with 8GB of RAM (where SQL Server was allocated 7GB). Note the 272MB available before AWE and the 6.79GB available AWE was enabled.

posted on July 08, 2009
| Permalink |