Post reply

Query - Execution Time

  • December 11, 2007 at 2:11 am

    #177494

    Hi Experts,

    I have faced the below question in my client interview.

    Question :

    A query has been executed in Production server.You noticed that it tooks more time to execute than yesterday. What is the problem ?

    My Answer:

    1) Due to Network Traffic Problem

    2) Due to Lock Contention ( for ex, if any Insert or update statement executed against that table)

    Apart from this is there any reason which will affect query execution time ?

    karthik

  • December 11, 2007 at 3:31 am

    #758881

    1) Query optimization.

    2) There might be a problem due to index i.e check whether index is used in the correct order(i.e index seek etc.,).

    you can see the performance thr' execution plan.

    3) Table Design (Optional).

  • December 12, 2007 at 11:22 am

    #759521

    Could also be datagrowth

  • December 13, 2007 at 1:52 am

    #759717

    According to me 🙂

    1) Increased data i.e. numerous inserts

    a) Due to increased amount of data processing the query might be taking time

    b) queries used for smaller dataset might be fine but with increased data set they might be giving performance issues

    2) if it is a query which is inserts/ updates data ..... it might be becuase of improper fill factor of the index

    3) Improper cached execution plan

    4) frequent recompiles

    5) improper statistics in case the statistics are not being updated by SQL Server 2005

    Please let me know about your views on the same 🙂

    thanks

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

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