i got error during global indexing job.
i setup sql repository using sql scanner & inspector
and there are about 1500sqls in the sql repository.
i send all the sqls to global indexing from sql repository.
during global indexing job, i get error messages as below
** ERROR:Available Memory is low, Now cancelling command.
i have 2Gbytes Memory in my test system
and i also set memory thresholds to 100% in SQL Optimizer options.
So, i think SQL Optimizer has to suppot one of this options.
find queries for a specific table (filter option), and send to global indexing
just this filted queries.
install sql optimizer agents on serveral systems and using parallel optimization or global indexing job (just like Benchmark factory ^^)