Big Amount of <free_space_in_bytes> in Buffer Pool's Database Pages
2
votes
1
answer
285
views
We were viewing
sys.dm_os_buffer_descriptors
using below query
select
d.[name] [Database_Name],
(count(file_id) * 8) / 1024 [Buffer_Pool_Size_MB],
sum(cast(free_space_in_bytes as bigint)) / 1024 / 1024 [Free_Space_MB]
from sys.dm_os_buffer_descriptors b
join sys.databases d on
b.database_id = d.database_id
group by d.[name]
order by [Buffer_Pool_Size_MB]
And for one of my databases, it shows [Buffer_Pool_Size_MB] = 77325 Megabytes, and [Free_Space_MB] = 15849 Megabytes
So its about 20% of space in pages in buffer pool is empty. Seems like a waste of resources
Questions:
- Is this a problem ?
- How can number of free_space_in_bytes
be mitigated ?
- Any other things to investigate / look at in our situation ?
Asked by Aleksey Vitsko
(6195 rep)
Aug 8, 2019, 09:13 AM
Last activity: Aug 8, 2019, 10:49 AM
Last activity: Aug 8, 2019, 10:49 AM