Server has 2 processors with 48 cores total. Row #3 is exactly what I'd expect to see for Standard Edition. Developer edition is a fully-functional Enterprise edition of SQL Server which has all limitations removed. Here is interesting thing - MEMORYCLERK_SQLBUFFERPOOL is presented by two records. Standard Edition (64-bit) on Windows Server 2016 Standard 10.0 Memory optimized tables are not used.īut in reality more than 215 Gb is being used for buffer pool: We are using columnstore so I expect that SQL Server will be limited by using 128+32 Gb of memory. Or total memory on the server if max server memory is uncapped. In addition, there can be memory consumed by other memoryĬonsumers in SQL Server which will be limited by "max server memory" The processor, memory and database size limits does not change and. Starting with SQL Server 2016 SP1, you can have anĪdditional 32GB of memory for Columnstore segment cache per instanceĪnd an additional 32GB of memory quota for In-Memory OLTP perĭatabase. With the recent announcement of SQL Server 2016 SP1, we announced the consistent programmability experience (CPSA) for developers and ISVs, who can now maintain a single code base and build intelligent database applications which scale across all the editions of SQL Server. Limited to 128GB, so the data and index pages cached in buffer pool is For example: A Standard Edition of SQL Server has buffer pool memory
0 Comments
Leave a Reply. |