SQL Server Performance

Execution Time

Discussion in 'ALL SQL SERVER QUESTIONS' started by hayko98, Mar 15, 2012.

  1. hayko98 New Member

    Hi All
    I run a query that runs 54 sec.If i run it again (without changing anything) it runs 94 sec.Then 54 sec,then 420 sec,then 52 sec......Any idea what can cause this.It is on test server.
    hayko98, Mar 15, 2012
    #1

  2. hayko98 New Member

    Never Mind
    hayko98, Mar 15, 2012
    #2

  3. Shehap Moderator

    First welcome to Forums,

    Could you elaborate more about your query
    Shehap, Mar 22, 2012
    #3

  4. Madhivanan Moderator

    Are you running a procedure? Search for parameter sniffing
    Madhivanan, Apr 18, 2012
    #4

Share This Page