hi Folks
what exactly is the SysTaskParam table for? and should it have over 3m records?
It looks like a table that should be cleared down by a system process - as it just looks like 1 off task parameters that where required for what ever task it was linked to?
can anyone advise?
cheers
mal
Every time you submit a task to the agent, the parameters are stored in this table so the running task can access them. Overtime, it can add up.
hi Mark
and does it just grow indefinitely? we have over 3million records in here and i noticed some sql issues when data was being retrieved from it
mal
It is supposed to be automatic. Go into System Agent and click on Actions for your Agent:
Try changing it to 45 days and then restarting the Task Agent service. If that doesn’t work, I would submit a ticket.
folks
just incase it helps someone else
we restored one of our test DBs with a copy of Live and forgot to change the agent details to the test agent - so it was hammering away at live causing us the performance degradation!
lessons learnt!
thanks
mal