Post reply

How calucalate T-SQL query performance

  • October 13, 2004 at 9:10 am

    #63452

    How calucalate T-SQL query performance

  • October 13, 2004 at 10:44 am

    #526541

    What do you mean calculate performance?

  • October 14, 2004 at 1:02 am

    #526655

    use SET STATISTICS IO to see if it uses too much IO resources

    use SET STATISTICS TIME to see the time usage

    use SET PLAN ALL to see the IO, Time and Sub tree costs for each part of your batch query. Further you can get a sum of the TotalSubtreeCost to get a base figure for you query performance.

     

     

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

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