How to estimate how much time a script will run?

  • I have a script and would like to estimate how much time it will run. How to do it?

    Many thanks in advance.

  • at least viewing the estimated execution plan would give you a ballpark number;

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • Lowell (2/12/2013)


    at least viewing the estimated execution plan would give you a ballpark number;

    Where 'ballpark' is the size of half a continent. 🙂

    Run the script in a test environment with roughly the same amount of data. There's your time estimate.

    Neither the estimated nor actual execution plans contain durations, estimated or actual. They contain estimated costs (which can be so far off as to be useless) and costs are not times.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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