In the SQL database, the TaskOutputValueProperty table is growing very large.
ITMS 7.x - 8.x
When a Task is run, the outcome of the Task is stored in this table. Each task run creates at least 4 records to hold the outcome of the Task.
Examples of the contents of this table are included below.
Run the following SQL query and to get a general idea of the Tasks being run that are generating a majority of the output in the table.
select tpv.*, ti.taskname from taskoutputpropertyvalue tpv
join evt_task_instances ti on ti.taskinstanceguid = tpv.taskinstanceguid
order by taskname
Then take one of the following options:
The TaskOutputProperty table is getting very large, how can we clean it up? - 176114