In database systems, the size of the main memory has a significant impact on performance. The goal is to keep as much relevant data as possible in the memory. Due to the structure of the memory, it can happen that part of the memory contains "air" in a figurative sense that could be used much more sensibly.
Fortunately, Microsoft SQL Server provides a good source for tracking down this waste of space that provides a good basis for responding to this problem in a constructive way: The system view sys.dm_os_buffer_descriptors. So in this talk I show how it can be used to collect information about internal fragmentation in a resource-efficient way.
Beforehand, I briefly talk about the different types of fragmentation and their relevance. Finally, I give an outlook on the possibilities of a periodic analysis to develop customized processes for the reorganization of tables and indexes.

The talk is based on my blog article of the same name, which is available here:
https://blog.ordix.de/buffer-pool-fragmentation-sql-server