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...
Posted to
SQLMaster
by
Satya Jayanty
on
11-04-2011
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...
Posted to
Jack Vamvas's Blog
by
Jack Vamvas
on
01-05-2011
Filed under:
Filed under: Server, Memory, dynamic, AWE, on SQL, Edition, full, 2005, Standard, releasing, bit, 32