Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
In-memory oltp - Checkpoint files not getting recycled RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    We have in-memory OLTP database with just one table (memory optimized). Since last 2 weeks checkpoint files are not getting flushed unless we restart services.

    We have been using this table for last 2 years with no issues till earlier this month. Database just have one table which has 400K records and size of table is 500 MB.

    We use this table to store user sessions and on an average we get insert/delete 60K records everyday. Number of selects is much higher but not sure if that would impact size of checkpoint file.

    Below are questions we are puzzling with

    1. What gets recorded in checkpoint files and could number of selects impact size of checkpoint file
    2. How are checkpoint files managed? How and when they get cleaned up

    Below are few other details in regards to environment this is happening on

    • SQL server 2016(SP1) 13.0.4001.0
    • DB compatibility level 120
    • DB recovery model - Full
    • Weekly full, Daily diff and every 30 min log backups
    • Checkpoint file of 128 MB is generated almost every minute.

    Thanks

    Prashant

    • Moved by Dave PatrickMVP Thursday, February 21, 2019 5:29 AM looking for forum
    Thursday, February 21, 2019 5:21 AM

Answers