SQL Server 2012 is a big release compared to what we have seen from 2005 to 2008, though R2 has been an additional release with BI capabilities. Now SQL 2012 equipped with much more enhancements and new features to manage your data platform. In specific to this release its good to know about new edition...
Filed under: Filed under: best practices, enterprise edition, beginners, dba practices, editions, setup, Business Intelligence, installation, licensing, sql server 2012, standard
Using the sql statement I checked for memory SQL Server has allocated through AWE mechanism select sum(awe_allocated_kb) / 1024 as [AWE allocated, Mb] from sys.dm_os_memory_clerks This was 18222 MB. Checking the sp_configure, the run value was max server memory was 18222 (MB). So far, good. I was not...
Jack Vamvas's Blog
Filed under: Filed under: Server, Memory, dynamic, AWE, on SQL, Edition, full, 2005, Standard, releasing, bit, 32