Fragmented indexes

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

Fragmented indexes

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

Hi,

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)

thanks,

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

Postby priyasinha » Tue Apr 30, 2013 2: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.

Thanks,
Priya
priyasinha
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm

Postby Lee Mellor » Wed May 01, 2013 12:01 pm

Hi Priya,

Thanks for the reponse. explains everything :-)

Regards,

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

Postby JoeGT » Thu May 02, 2013 2: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.
JoeGT
 
Posts: 40
Joined: Wed Jun 13, 2012 3:37 am


Return to SQL Monitor 3

Who is online

Users browsing this forum: No registered users and 0 guests