Performance tip rg_job_history prevents updates with CU 22 for SQl Server 2017
bauerju
Posts: 33 Bronze 3
Hi all
at https://documentation.red-gate.com/sm/troubleshooting/improving-performance-of-sql-agent-job-history-sampling is a performace tip of creating an filtered index on table msdb.dbo.sysjobhistory.
This tipp works fine, unless you want to update your servers :-(
This index prevents updating with error 1934 at msdb110_upgrade.sql.
So If anybody has problems here, just dop the index. and recreate it.
Searching for this failure took me some time ...
Could anybody of the red-gate team add some information to the tip please? Thanks.
Jürgen
at https://documentation.red-gate.com/sm/troubleshooting/improving-performance-of-sql-agent-job-history-sampling is a performace tip of creating an filtered index on table msdb.dbo.sysjobhistory.
This tipp works fine, unless you want to update your servers :-(
This index prevents updating with error 1934 at msdb110_upgrade.sql.
So If anybody has problems here, just dop the index. and recreate it.
Searching for this failure took me some time ...
Could anybody of the red-gate team add some information to the tip please? Thanks.
Jürgen
