How can we help you today? How can we help you today?

SQL Monitor occasionally experiences blocking

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...



DGWinOKC
0

Comments

1 comment

Sort by
  • ThomasBE
    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?
    ThomasBE
    0

Add comment

Please sign in to leave a comment.