Search
Submit a request
Sign in
How can we help you today?
Categories
Submit a request
Submit a request
Sign in
Support
Community
Redgate Monitor
Performance tip rg_job_history prevents updates with CU 22 for SQl Server 2017
New post
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
bauerju
February 12, 2021 06:46
-
0
+
Add comment
Please
sign in
to leave a comment.
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