I need to identify hot partitions of Sybase IQ table (Sybase IQ 16). In Sybase ASE i can use MDA tables (monOpenPartitionActivity), is there any way to measure logical, physical reads for individual partitions in Sybase IQ? I tried sp_iqsysmon, but it doesn't show statistics for individual partitions.
Asked by Alex
(155 rep)
Jul 3, 2016, 09:50 AM
Last activity: Jul 9, 2016, 01:16 PM
Last activity: Jul 9, 2016, 01:16 PM