HKCKP files \ sys.dm_db_xtp_checkpoint_files

• ran.ovadia

  Ten Centuries

  Points: 1183

  More actions

  April 9, 2021 at 8:19 pm

  #3867398

  Hi all, does anybody know how can I get rid of the old files in the folder: \$HKv2 under my data folder?

  I understand that they are InMem checkpoint files which I can see in this DM view: sys.dm_db_xtp_checkpoint_files under: relative_file_path for example : $HKv2\{85D9A12C-F870-4DCA-842A-FF2390683680}.hkckp

  I see files from the last 24 hours which consume 1 TB.

  Somehow, every hour - SQL deletes the older than 24 hours files - How can I control it?

   

  Thanks,

  Ran.

• Site Owners

  SSC Guru

  Points: 80325

  More actions

  April 10, 2021 at 9:10 pm

  #3867665

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• Evgeny Garaev

  SSCertifiable

  Points: 7428

  More actions

  April 19, 2021 at 3:38 am

  #3872867

  Check this sp sys.sp_xtp_checkpoint_force_garbage_collection - https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sys-sp-xtp-checkpoint-force-garbage-collection-transact-sql?view=sql-server-ver15

  I think it is what you are looking for...