SSISDB Maintenance job cleaning data very slow on SQL Server 2014

1 vote

1 answer

2288 views

sql-server sql-server-2014 ssis ssis-2014

                          On SQL Server 2014 Microsoft (12.0.2430) SQL Server Enterprise: Core-based Licensing (64-bit) after changing the retention period from 365 to 90 since last 2 days job clean up about 2 GB of data only. I have rebuild & update all stats on SSISDB database still its slow.

Current Size of database is 344GB approximately. what is the best way to clean old records Quickly, To do that do i need down time ?

I have followed below article  so far :-

Asked by AJ's SQL (103 rep)

Jul 25, 2016, 02:13 PM
Last activity: Mar 25, 2024, 07:51 AM

SSISDB Maintenance job cleaning data very slow on SQL Server 2014

Related Questions