Post reply

Print query duration/run time in results

  • July 12, 2005 at 8:01 am

    #67214

    I am looking for a way to add the query execution time to the result of the query. This is not a big deal, but if anyone knows of a setting in query analyzer or an SP or routine for adding this, I would greatly appreciate it. Thanks in advance.

    Jeff

  • July 12, 2005 at 8:15 am

    #573385

    Is this for the final application or for query optimization??

    SET STATISTICS TIME ON

    Select * from dbo.SysObjects

    SET STATISTICS TIME OFF

    check the message window.

  • July 12, 2005 at 10:38 am

    #573541

    Thank you. This was exactly what I needed.

    Jeff

  • July 12, 2005 at 10:45 am

    #573552

    HTH.

    check out SET STATISTICS IO too .

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

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