#sqlhelp Is it advisable to make changes to the existing indexes or add more indexes on SSISDB in SQL SERVER 2017? #SQLServer #SSIS
3
0
2
0
0
@SQLDBA_ESH In my opinion, yes, because SSISDB is a database, after all. Tune it, then test to make sure you didn't break anything. Keep in mind tuning efforts skew (slightly) towards data egress. SSISDB receives a ton of log messages.
@SQLDBA_ESH I wonder if @AndyLeonard knows the answer to this. #sqlhelp
@SQLDBA_ESH In case helps, I have added multiple indexes to the MSDB database. I don’t think you will get a negative impact it is a database after all :)