[SQL Server] In-Memory OLTP : Afficher l'espace mémoire utilisée par chaque table optimisée en mémoire

  • Imprimer

select OBJECT_NAME(object_id) as nom_table
,SUM( memory_allocated_for_indexes_kb + memory_allocated_for_table_kb)/1024 AS memory_total_allocated_for_objet_MB
,SUM(memory_used_by_table_kb + memory_used_by_indexes_kb)/1024 AS memory_total_used_by_objet_MB
,SUM(memory_allocated_for_table_kb)/1024 AS memory_allocated_for_table_MB
,SUM(memory_used_by_table_kb)/1024 AS memory_used_by_table_MB
,SUM(memory_allocated_for_indexes_kb)/1024 AS memory_allocated_for_indexes_MB
,SUM(memory_used_by_indexes_kb)/1024 AS memory_used_by_indexes_MB
from sys.dm_db_xtp_table_memory_stats
GROUP BY OBJECT_NAME(object_id)