Maintenance routine for cleaning log tables (sysssislog and sysdtslog90)

Question

I have a SQL SERVER 2014 standard database and during the monitoring of the database, I realized that I have some SQL tables that are a little large and went to search about.

The tables are sysssislog and sysdtslog90

For the documentation, these tables are for DTS package execution log.

Is there any specific routine or standard utility for cleaning these tables or simply I can give a delete per period or even a truncate?

Answer 1

These tables are used even for logs SSIS and over time tend to get big. The recommendations I read here and here are that you can delete these logs if you don’t need to.

Is there any specific routine or standard utility for cleaning of these tables or simply I can give a delete per period or even a truncate?

I can’t remember a routine built-in that clears these tables, but you can give a truncate no problem. To not have to do this manually you can schedule a job in SQL Server Agent to do this from time to time. More information on how to do this:

• Enable SQL Server Agent
• Set up a job of type SQL query