![]() For example, SQL Server Management Studio, SQL Profiler that someone forgot to stop and close for a few days (accumulationg RAM it consumes), or some other app. Therefore SQL Server process can, and will, allocate more than that limit.īy the way, “Max Server Memory” corresponds to 128GB limit, it does not include columnstore or memory-optimized tables and indexes.Īlong with SQL Server process, there is an OS that takes some RAM, and other processes running on that machine. Like memory for thread stacks and direct allocations from the OS (extended sp, DLLs, win heap usage, linked server provider allocations). ![]() Everybody “steals” memory from the buffer pool □īut SQL also allocates memory outside of the buffer pool, outside of that (128+32+N*32) GB limit. If we have a big sort operation, we can here observe how it “steals” from the buffer pool, because buffer MEMORYCLERK_SQLBUFFERPOOL clerk will shrink.
0 Comments
Leave a Reply. |