將週期天數從預設的 365 天改到 30 天或其他更小的數字。
將 delete_batch_size 設定為 1000，預設為 10。
1
| Alter procedure SSISDB.[internal].[cleanup_server_retention_window] SET @delete_batch_size = 1000
|
- 把以下 4 張 Table 做 Page 壓縮
1
2
3
4
5
6
7
8
| USE [SSISDB]
ALTER TABLE [internal].[event_messages] REBUILD PARTITION = ALL WITH (DATA_COMPRESSION = PAGE)
ALTER TABLE [internal].[operation_messages] REBUILD PARTITION = ALL WITH (DATA_COMPRESSION = PAGE)
ALTER TABLE [internal].[execution_component_phases] REBUILD PARTITION = ALL WITH (DATA_COMPRESSION = PAGE)
ALTER TABLE [internal].[execution_data_statistics] REBUILD PARTITION = ALL WITH (DATA_COMPRESSION = PAGE)
|
- Shrink the db
1
2
3
4
5
| USE [SSISDB]
GO
DBCC SHRINKDATABASE(N'SSISDB')
GO
|
參考資料
How to Reduce SSISDB Size