Share via

removestaledbentries: cleanup of stale db entries skipped beacuse master db is not memory optimized

T Lee 0 Reputation points
2025-02-26T05:37:46.5733333+00:00

removestaledbentries: cleanup of stale db entries skipped beacuse master db is not memory optimized

The above message is occurring frequently and persistently. How can I resolve this issue?"

  • sql-server 2022
SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
147 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 41,286 Reputation points
    2025-02-26T08:16:16.7866667+00:00

    Hi T Lee,

    It seems the message is informational rather than an error. It means that SQL Server skipped cleaning up stale database entries for the master database because the master database isn’t configured to be memory‐optimized.

    If your system is operating normally, you can ignore these.

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

  2. Erland Sommarskog 119K Reputation points MVP
    2025-02-28T20:55:30.3466667+00:00

    Several users have reported this, and I think I have seen it on my own instance as well. The message as such is benign. But if you get it such volumes in the errorlog that hides more relevant information, I can understand that you want to get rid of it.

    I would recommend to open a support case if you have a support contract good enough.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.