How do you use cloud databases? Take the survey.
High Fragmentation on SQL Monitor Repository Tables
The SQL Monitor Repository/DB is on one of the servers being monitored by SQL Monitor. Some the indexes on the repository tables are generating fragmentation alerts. The offending indexes are almost always on the various data.Cluster_SqlServer_* tables. Index maintenance is performed early Saturday mornings. but by Monday morning (48 hrs) these indexes are fragmented over 90% with the number of pages exceeding way over 1000.
- Is it normal for this much activity to happen on these tables so that they generate this much fragmentation in a relatively short period of time - especially since we don't even have a clustered environment but all this activity is happening against tables presumably used for monitoring a cluster?
- Are there any tuning/performance/index maintenance recommendations for the repository DB?
0 · Share on Twitter