Post reply

Filegroup for memory optimized tables and garbage collection

  • January 14, 2017 at 1:19 pm

    #320572

    I've used FileTables and I know that I can run "sp_filestream_force_garbage_collection" to perform garbage collection on demand.

    I'm new to memory-optimized (MO) tables.  I created a filestream filegroup and file for MO tables. Does SQL Server releases the memory used for MO tables once data is deleted, or is it necessary to perform garbage collection on the filegroup for the MO tables? I couldn’t find anything in the literature.

    Thanks

  • January 16, 2017 at 2:06 am

    #1922900

    N_Muller - Saturday, January 14, 2017 1:19 PM

    I'm new to memory-optimized (MO) tables.  I created a filestream filegroup and file for MO tables. Does SQL Server releases the memory used for MO tables once data is deleted, or is it necessary to perform garbage collection on the filegroup for the MO tables? I couldn’t find anything in the literature.

    Memory-resident tables use garbage collection, rows are marked as deleted, cleaned up after nothing needs them any longer.
    That said, you do not need to force garbage collection and you should not force garbage collection. Let SQL handle it automatically.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply