1

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?

Improve this question

1 Answer 1

Reset to default
4

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:

SELECT
  database_id AS DatabaseID,
  DB_NAME(database_id) AS DatabaseName,
  COUNT(file_id) * 8/1024.0 AS BufferSizeInMB
FROM sys.dm_os_buffer_descriptors
GROUP BY DB_NAME(database_id),database_id
ORDER BY BufferSizeInMB DESC
GO
Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .