Monitoring index usage
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Monitoring index usage

  1. #1
    Join Date
    Mar 2005
    Posts
    143

    Monitoring index usage

    I was wondering if there is a way to see when an index was used with out having altered the index to monitor it's useage? while I am on the monitoring useage topic, is there a way to monitor when an SQL profile was used? Thanks for any help you can give

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    no - that's what index monitoring is there for

  3. #3
    Join Date
    Mar 2005
    Posts
    143
    davey23uk,
    thanks for the responce. I was affraid of that. Do you know if I can monitor the use of a SQL profile like an index?

  4. #4
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    just curious to know why do you afraid of using index monitoring. Any specific reason or any bad experience??

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  5. #5
    Join Date
    Mar 2005
    Posts
    143
    haha, I am not affraid to use monitoring. I was affaid that there was no way to see if an index was being used without index monitoring. I just started here and wanted to know if some indexes were being used and the previous DBA did not enable the indexes to be monitored.

  6. #6
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    I would enable index monitoring for a month - or whatever your IS processing cycle is, then check for unused indexes.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  7. #7
    Join Date
    Mar 2005
    Posts
    143
    thanks, that is what I am going to end up doing. Does anyone know if I can do the same for SQL profiles that I created. I had created a couple of profiles and was wondering if there is a way if to see if they are getting used.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width