How to get space used by In-Memory table in SqlServer

2 votes

1 answer

965 views

sql-server sql-server-2014 storage memory-optimized-tables

                          I'm trying to understand how much storage In-Memory table consumes in SqlServer:

    SELECT is_memory_optimized,durability_desc FROM sys.tables WHERE name='TBL_HSD_AD_OR'
    select count(*) [#Rows] from TBL_HSD_AD_OR with(nolock)

Now when I'm using EXEC sp_spaceused I get:

    EXEC sp_spaceused 'TBL_HSD_AD_OR'

Is there a different way to get the space used for Memory-Optimized tables?

Asked by Yosi Dahari (517 rep)

Sep 13, 2016, 06:18 AM
Last activity: Jan 29, 2023, 03:07 PM

How to get space used by In-Memory table in SqlServer

Related Questions