Skip to Content
0
Aug 18, 2016 at 02:30 PM

How to monitor table partition size changing in IQ?

78 Views

Dear All,

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.

Regards

Eisen