I have a standard SQL Server 2014 database and during base monitoring, I realized that I have some SQL tables that are a bit large and have been researching about it.
The tables are sysssislog and sysdtslog90
By documentation, these tables are for DTS package execution log .
Is there a specific routine or default utility for cleaning these tables or can I simply give a delete per period or even a truncate ?
These tables are even used for logs of SSIS and over time tend to get large. The recommendations I read here and here are you can delete these logs if you do not have to.
Is there a specific routine or standard utility for cleaning of these tables or I can simply give a delete by period or even a truncate?
I do not remember a built-in routine that wipes these tables, but you can give truncate with no problems. 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:
