sys.dm_pdw_errors maximum rows

Question

As per this document, sys.dm_pdw_errors can retain a maximum of 10,000 records. Why am I seeing only 3,200 in my environment?
Dedicated SQL Pool
Gen2: DW2000c

Answer 1

Hi Taiob Ali , Thankyou for using Microsoft Q&A platform and thanks for posting your query here. It seems that you are seeing only 3,200 records in your ded sql pool environment, while the documentation states that sys.dm_pdw_errors can retain a maximum of 10,000 records.

Pausing compute causes the storage layer to detach from the Compute nodes. The compute resources are released from your account. You are not charged for compute while compute is paused. Resuming compute reattaches storage to the Compute nodes, and resumes charges for Compute. When you pause a dedicated SQL pool (formerly SQL DW), DMV counters are reset.

For more details, kindly check this documentation: Pausing and resuming compute Hope it helps. Kindly accept the answer by clicking on Accept answer button. Thankyou

Answer 2

The count of rows in the DMVs, including sys.dm_pdw_errors, resets when a dedicated SQL pool is either paused or when its scale is changed. If your environment underwent such operations, this could explain the lower count of records