SSISDB 2012 – Catalog Indexing Recommendations

Hi there!

Noticed that you’re SSISDB reports are starting to get really slow and thus annoying?
Well…it’s time to fix that! Found this post by Phil Brammer that fixes that by creating new indexes:
http://www.ssistalk.com/2013/01/31/ssis-2012-catalog-indexing-recommendations/



ssisdb-reports-slow


More info by Microsoft on this issue:
http://support.microsoft.com/kb/2829948

Also…on my server the total execution time of the SQL Agent Job ‘[SSIS Server Maintenance Job]‘ (by ##MS_SSISServerCleanupJobLogin##) went from 125 to 22 minutes! Make sure to reorganize/rebuild the newly created indexes.

Data Compression
Don’t forget to apply data compression (which will save you storage and decrease your I/O thus increase performance)!
https://clinthuijbers.wordpress.com/2014/08/01/ssisdb-2012-data-compression/








Advertisements

One thought on “SSISDB 2012 – Catalog Indexing Recommendations

  1. Pingback: SSISDB 2012 – Data Compression | Clint Huijbers' Blog

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s