Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2004
    Posts
    3

    Unanswered: Statistics for index usage and user's load?

    Hello!

    Is there any way to determine index usage statistics for a given table?
    For examle, I have a table, with three indices. I need to know how many times each index was used. Is it possible?

    And second part of question: I need to know, which user overloads my base with their giantic queries. Is there any way to determine, how many system resources each of user's sessions uses?

    MS SQL Server 2000 Enterprise Edition.

    Thank you!
    Last edited by Sanvean; 09-07-04 at 16:44.

  2. #2
    Join Date
    Sep 2003
    Posts
    364
    Check out this for article for your first issue, http://www.sql-server-performance.co...on_english.asp

    You can setup a trace in Profiler for your second issue too.

  3. #3
    Join Date
    Feb 2004
    Posts
    492
    It's a nice article peter, I've been following it to see what it came up with. Unfortunately, according to the article I may want to import a text file (Index Usage Report) into this Analysis-table, but I don't have a datetime field in the text-file so the import-fails. Same goes for a 'base' column. I'm probably doing something wrong here, hoping you've followed the article as well, any suggestions?

  4. #4
    Join Date
    Sep 2003
    Posts
    364
    Sorry, I've only read the article. Unfortunately, I haven't had any time to do any testing.

Posting Permissions

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