Performance Degradation Due to [sys].[sp_td_clean_old_patterns_v2] Procedure

Ekaterina Dyatlova 0 Баллы репутации
2025-04-29T11:34:39.71+00:00

I am reaching out to request assistance regarding a performance issue we are experiencing in our Azure SQL Database.

We have observed that a system stored procedure named [sys].[sp_td_clean_old_patterns_v2] is being executed periodically. During its execution, it causes significant blocking on our user queries—particularly those performing simple SELECT operations—by introducing PAGEIOLATCH_SH waits. These waits indicate contention while the database engine attempts to read pages into memory, and we suspect that the system procedure may be placing a heavy I/O load on the server.

Unfortunately, we have not found any official documentation on the purpose or behavior of this procedure, nor on how or when it is triggered. As a result, we are unable to determine:

What exactly this procedure does.

Whether its execution schedule can be controlled, configured, or limited.

If there is a way to mitigate its impact on customer queries.

Whether its behavior is expected under our service tier and configuration.

Could you please provide:

An explanation of what this procedure does and when/why it runs.

Recommendations for how to reduce or eliminate its impact on database performance.

Any best practices to avoid blocking caused by system-initiated processes like this one.

Your assistance on this matter would be greatly appreciated, as the current behavior is affecting the responsiveness of our application.

SQL Server | Другое
Комментариев: 0 Без комментариев
Голосов: {count}

Ваш ответ

Автор вопроса может помечать ответы как принятые. Это позволяет пользователям узнать, что ответ помог решить проблему автора.