Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    1

    Unanswered: Index usage mystery!!

    I am using SQL profiler WIN2K , to find out which indexes are not used. I am using security events, audit object permisssion event, but never get any index id or object type of indexes, I know that some indexes are being used, anyone know of a way of seeing this information,.

    Help would be appreciated we have spent 2 days bashing this ..

    Mark

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    I am afraid you cannot find any info about index usage in Profiler.

    http://www.sql-server-performance.co...izard_tips.asp

Posting Permissions

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