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

  • Options
    ThomasBEThomasBE Posts: 14 Bronze 2
    Could you perhaps shed some more insight into your environment?
    What build version does your SQL server and SQL Monitor have?
    What kind of HW are you hosting the database on?
    · Share on Twitter
Sign In or Register to comment.