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.
  2. hayko98 New Member

    Never Mind
  3. Shehap MVP, MCTS, MCITP SQL Server

    First welcome to Forums,

    Could you elaborate more about your query
  4. Madhivanan Moderator

    Are you running a procedure? Search for parameter sniffing

Share This Page