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

Exclude re-indexing

is there any way we can exclude re-indexing operations? We do these weekly and aren't bothered by the changes they generate
RichardGardner
0

Comments

2 comments

Sort by
  • Eddie D
    Hi, thank you for forum post.

    Sadly I am confused by your post. To my knowledge, DLM Dashboard does not create a re-indexing task. Do you have a SQL Agent job or Maintenance Plan performing the re-indexing operation?
    Eddie D
    0
  • RichardGardner
    Hi Eddie
    Yes we have a maintenance plan that runs every saturday night. As this rebuilds indexes across all our tables we then get a drift in the database schema which I clear on a Monday morning. As this is just maintenance and not (in our eyes) true drift, I wanted to exclude this so a'll im really bothered about is changes to the actual table structure
    Rich
    RichardGardner
    0

Add comment

Please sign in to leave a comment.