Fragmented indexes

Monitor, diagnose and receive alerts to problems across your SQL Servers.

Fragmented indexes

Postby Lee Mellor » Mon Apr 29, 2013 4:57 pm


is there a particular event or time that could trigger a fragmented index alert? i have an index that triggered an alert at what would appear to be a pretty random time. there were no dbcc checks or show contigs going on. also shouldnt the alert become inactive if the condition no longer applies (ie, the index has been rebuilt)


Lee Mellor
Posts: 11
Joined: Mon Oct 26, 2009 1:33 pm

Postby priyasinha » Tue Apr 30, 2013 1:29 pm

Hi Lee,

SQL Monitor checks for fragmented index at Sunday 01:00 hrs (local time of machine on which you have installed Base Monitor). This is only checked once a week because this is a very expensive operation on Monitored entity.

Yes, the alert will be ended when the check runs next time i.e. on Sunday.

Posts: 549
Joined: Wed Jan 03, 2007 4:02 pm

Postby Lee Mellor » Wed May 01, 2013 11:01 am

Hi Priya,

Thanks for the reponse. explains everything :-)


Lee Mellor
Posts: 11
Joined: Mon Oct 26, 2009 1:33 pm

Postby JoeGT » Thu May 02, 2013 1:37 am

Ahh... Thanks for this bit of information.. I did wonder why, after I had manually resolved some alerts for fragmentation on some of my MSDB that even a few days later the alert had not ended.

Agree with the once a week scanning on this due to the relative expensiveness of running the query to get these results.
Posts: 47
Joined: Wed Jun 13, 2012 2:37 am

Return to SQL Monitor Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests