SQL Server Performance

hi

Discussion in 'Getting Started' started by lara99, Nov 14, 2007.

  1. lara99 New Member

    Hi/All
    I am running a verly long query it is taking hours. I just wanted to know is there a way to know while a query is executing to know how much is has been executed, i wanna ask like the percentage. Any help will b greatly appreciated. Thank You.
  2. Luis Martin Moderator

    You can use sp_who to know query status. Not in %, but cpu, etc.
    Or you can take a look of execution plan to find if any optimization is possible.
  3. satya Moderator

    Not very easy, you should or can have such information by enabling logging for that query such as error handling.
    is this for SQL 2000 or 2005?
  4. lara99 New Member

    it is sql 2000
    Thanks
  5. satya Moderator

    As referred there isn't any counters you could get and rather you should control such actions without your code by stating so and so percentage of work is finished.
    As usual you could see the execution plan for that query and if it is taking beyond suggested time then something is wrong. May be in 2005 DMVs would help and in your case you have no choice. Only execution plan is better way to go forwar.

Share This Page