Red Gate forums :: View topic - Fragmented indexes
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 3
SQL Monitor 3 forum

Fragmented indexes

Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Lee Mellor



Joined: 26 Oct 2009
Posts: 11

PostPosted: Mon Apr 29, 2013 5:57 pm    Post subject: Fragmented indexes Reply with quote

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.
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 530

PostPosted: Tue Apr 30, 2013 2:29 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Lee Mellor



Joined: 26 Oct 2009
Posts: 11

PostPosted: Wed May 01, 2013 12:01 pm    Post subject: Reply with quote

Hi Priya,

Thanks for the reponse. explains everything Smile

Regards,

Lee
Back to top
View user's profile Send private message
JoeGT



Joined: 13 Jun 2012
Posts: 40

PostPosted: Thu May 02, 2013 2:37 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group