How do you use cloud databases? Take the survey.
Options

SQL Monitor occasionally experiences blocking

DGWinOKCDGWinOKC Posts: 1 New member
in Redgate Monitor
Every so often the SQL Server instance that hosts the SQL Monitor repository alerts me to some blocking that is occurring. I created a method to track what is happening. Turns out that during the blocking, SQL monitor is rebuilding indexes on the fly. Has anybody seen this? How do I disable the ad-hoc index rebuild? Thanks.

ALTER INDEX [Cluster_SqlServer_Database_ConfigurationOptions_Sightings_Id] ON [data].[Cluster_SqlServer_Database_ConfigurationOptions_Sightings] REBUILD WITH...



· Share on Twitter

Answers

Sign In or Register to comment.