Post reply

Query Execution Time (Trouble Shooting)

  • June 2, 2008 at 1:05 am

    #71424

    Can anyone let me know what are the steps to take or check if the query is taking more time than yesterday in SQL2000 please?

    [font="Comic Sans MS"]Sara[/font]

    A ship in the harbour is safe . . . but that's not what ships were made for. 😀

  • June 2, 2008 at 2:58 am

    #822802

    First you may do the basic checks like...if there are any blocks being created during the procedure execution OR if there is any job running at the same time....

    Renuka__

    [font="Verdana"]Renuka__[/font]

  • June 2, 2008 at 3:47 am

    #822820

    Renuka, Thanks for the information. Is there any other way to check like show / update statistics method to check the query execution?

    Thanks in advance.

    [font="Comic Sans MS"]Sara[/font]

    A ship in the harbour is safe . . . but that's not what ships were made for. 😀

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply