Cleanup of stale DB entries skipped

MateiG 0 Reputation points
2024-10-07T07:46:35.11+00:00

Hello,

My Microsoft SQL Server error log contains very often the following line "RemoveStaleDbEntries: Cleanup of stale DB entries skipped because master db is not memory optimized.

Parallel redo is started for database 'database_y' with worker pool size [4].

Parallel redo is shutdown for database 'database_y' with worker pool size [4].

RBPEX::NotifyFileShutdown: Called for database ID: [5], file Id [0]

Starting up database 'database_y'. " where database_y has database ID: [5]

DBCC CHECKDB ('database_y')

CHECKDB found 0 allocation errors and 0 consistency errors in database 'database_y'

Do you have any idea how to continue the investigation?

Thank you.

Best regards,

Matei

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Erland Sommarskog 120.2K Reputation points MVP
    2024-10-07T21:40:38.4066667+00:00

    Find pillow, sheet and blanket. Find a pyjamas. Slip in. Sleep peacefully.

    Or in other words, these messages are just white noise and nothing to care about.

    1 person found this answer helpful.
    0 comments No comments

  2. MikeyQiaoMSFT-0444 3,300 Reputation points
    2024-10-08T09:53:34.5666667+00:00

    Hi,MateiG

    Welcome to Mircsoft Q&A forum!

    The message indicates that the cleanup task for outdated database entries was skipped due to the lack of memory-optimized configuration for the master database.

    The message 'CHECKDB on database 'database_y'' indicates that no issues were found with the database, which is good news.

    Therefore, the prompts mentioned are informational, and you do not need to worry.

    Regards

    Mikey Qiao


    If you're satisfied with the answer, don't forget to "Accept it," as this will help others who have similar questions to yours.

    1 person found this answer helpful.
    0 comments No comments

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.