Is there any way to find total allocated buffer pool size in sql server.In mysql we can find it by using the variable innodb_buffer_pool_size.Is there any equivalent for that in sql server?
Sql-server – How to check buffer pool size in sql server
buffermemorysqlsql server
Best Answer
To find out how much buffer cache each database on the sql instance is using you could run this query which uses the dmv
sys.dm_os_buffer_descriptors
: