BlkTypes X-Type of sp_iqdbspace

[Former Member]

Hello,

1. What does X-Type mean in BlkTypes value of sp_iqdbspace?

    Please give more specific explanation 'Drop at Checkpoint' .

2. In which cases the value of X-Type dramatically increment?

Thanks in advance!!!!

[Gisung]

Hi,

As you know, during backup, only at beginning is issued a checkpoint,

so, it's possible that transaction and versioning will be accumulated to be drop at checkpoint causing increase the usage of main store

(sp_iqdbspace will help to monitor this - look amount of Blktypes 'x').

Thanks

Gi-Sung Jang