I’ve grown up reading Tom Clancy and probably most of you have at least seen Red October, so this book caught my eye when browsing used books for a recent trip. It’s a fairly human look at what’s involved in sailing on a Trident missile submarine…
If you have SQL Server Integration Services installed on your server, and you left the default configurations a table named sysssislog is created on MSDB database, it contains logging entries for packages executed on that instance.
If you are not careful enough, this table can grow uncontrollably over time and can make subsequent insertions very slow.
A proper deletion process must be put in place, so you not get into situations like this one in your msdb database:
If you are already on this situation, you can the following T-SQL Script to delete records by batches:
After that you can implement the same query to your msdb maintenance job to have all in one place.