The TaskOutputPropertyValue table is growing very large
Article ID: 177057
Updated On:
Products
IT Management Suite
Issue/Introduction
In the SQL database, the TaskOutputValueProperty table is growing very large.
Environment
ITMS 7.x - 8.x
Cause
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.
Resolution
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:
- Decrease the frequency of these Task's run schedule.
- Implement policies to accomplish the objective of repeated Tasks.
- Verify that the Clean Up Task Data task is running as required. If it is holding too much data please lower the row count and time Task Output is kept, according to the needs of your environment.
- Location: Settings > Notification Server > Task Settings > Clean Up Task Data
Additional Information
The TaskOutputProperty table is getting very large, how can we clean it up? - 176114
Feedback
Yes
No
Powered by
