METADATA: database_id = 8 QDS_INTERVAL_STABILITY(qds_interval), lockPartitionId = 0

Martin Ng 0 Reputation points
2023-04-24T15:41:10.98+00:00

Hi all, During our weekly index maintenance window, we saw quite a few waits on 'METADATA: database_id = 8 QDS_INTERVAL_STABILITY(qds_interval), lockPartitionId = 0'. Haven't seen it before? Does anyone have any idea what it is and what causes it?

  • select @@version We're Microsoft SQL Server 2016 (SP3-GDR) (KB5014355) - 13.0.6419.1 (X64) May 29 2022 21:05:29 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor)
  • 2 nodes AG Group using Synchronous-Commit Availability Mode Thanks!
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,070 questions
{count} votes