I'm trying to monitor the table partition size changing in IQ so that I can find out the fastest growing partition and if needed, will split it to balance load for better performance. But now, I'm facing this problem --
1. in the syspartition table, there's no partition's size info,
2. in the sp_iqdbspaceobjectinfo -- only tell me how many partition in this dbspace.
So is that I can only read the partition key's barrier value, and use count(*) to get the rows number and then use sp_iqestspace to count the partition size? And if there's any other accurate way to get the partition size infomation?
Thanks for your help.