April 26, 2009 at 4:59 pm
Hi all,
This is a question:
I have this table(sysdts90) in msdb db where we store all loggins for SSIS packages(stand alone SSIS server). This table has more than a million rows now and it's growing. I think i need to purge this table. Any one has experience doing this?
Thanks
April 26, 2009 at 8:37 pm
SYSDTSLOG90 logs are usually used to debug purposes, but if your SSIS packages log all steps for each execution, you need to implement an export (recommended) and purge steps.
You could think about to disable some logs too.
---------------------
Alex Rosa
http://www.keep-learning.com/blog
April 27, 2009 at 10:42 am
Thank you for reply,
Can you tell me please what do you mean by saying "you need to implement an export (recommended)"?
Do you mean sort of archive before purge?
April 27, 2009 at 11:38 am
yeap...archive log for further analysis (if necessary).
---------------------
Alex Rosa
http://www.keep-learning.com/blog
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply