Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning Reason behind, if same query run several times the results are comming in less time RE: Reason behind, if same query run several times the results are comming in less time

  • January 22, 2014 at 5:34 am

    #1682353

    kbhanu15 (1/22/2014)

    HI All,

    TO avoid this issue any database setting to be change ?

    i mean ( if we run the query 1st or 2nd time or 3rd time it should show the same time)

    after that we apply our performance tips and improve .

    thanks

    Bhanu

    This isn't an issue, it is desired behaviour.

    Typically you want queries to perform faster if they are used more, right?

    If you want to do some performance testing, you need to clear the cache yourself:

    Clearing Cache for SQL Server Performance Testing[/url]

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP