Output from sp_iqversionuse differs on coordinator and secondary servers.
In this example, the oldest version 42648 is in use by connection 108 on the coordinator (mpxw). Committing or rolling back the transaction on connection 108 releases 7.9MB of space. Version 42686 is in use by secondary server (mpxq) according to output from the coordinator. Using the secondary server output, the actual connection is connection 31. The actual amount of space returned from releasing version 42686 depends on whether 42648 is released first.
WasReported is 0 for versions 42715 and 42728 on the coordinator because these are new versions that have not yet been replicated. Since version 42728 does not appear on the secondary server output, it has not yet been used by the secondary server.
call dbo.sp_iqversionuse
VersionID |
Server |
IQConn |
WasReported |
MinKBRelease |
MaxKBRelease |
|---|---|---|---|---|---|
42648 |
'mpxw' |
108 |
1 |
7920 |
7920 |
42686 |
'mpxq' |
0 |
1 |
7920 |
304 |
42702 |
'mpxq' |
0 |
1 |
0 |
688 |
42715 |
‘mpxq' |
0 |
0 |
0 |
688 |
42728 |
'mpxq' |
0 |
0 |
0 |
688 |
call dbo.sp_iqversionuse
VersionID |
Server |
IQConn |
WasReported |
MinKBRelease |
MaxKBRelease |
|---|---|---|---|---|---|
42686 |
'mpxq' |
31 |
1 |
0 |
0 |
42715 |
'mpxq' |
00 |
1 |
0 |
0 |