Converting Hangfire tables to Memory Optimized Tables in SQL Server

Does Hangfire work with Memory Optimized tables in SQL Server (In-Memory tables). I’ve seen 500% performance improvements putting low record count and high insert/delete tables In-Memory for other applications. The locking is different for In-Memory tables which may cause problems.

2 Likes

This would be really not too smart to implement because all job status information would be lost after a SQL Server reboot.

You can make memory optimized tables durable.

Craig, you should try it. I’d love to know if you have success or not.

@craig how did you go with conversion to memory optimized tables?