Post reply

Same Databases in different server I run same queries but execution plans are different

  • July 10, 2012 at 6:34 am

    #258808

    Hi All,

    I have 2 same queries in same databases but in different servers. I run same queries, bu execution plans are different. one took 10 seconds the other is over 5 minutes.

    I updated statistics but result did not change.

    What will cause this situation?

    Regards,

  • July 10, 2012 at 6:49 am

    #1510881

    A number of things could cause this.

    1. SQL Version Number

    2. Differences in data and data distribution in the required tables

    3. Index differences

    4. Schema differences

    5. Database configuration options

    6. Server configuration options

    What have you compared so far?

  • July 10, 2012 at 7:12 am

    #1510893

    Slower queries' server has the newest SQL Server version number. And all other factors are the same.

  • July 10, 2012 at 7:13 am

    This was removed by the editor as SPAM

  • July 10, 2012 at 7:14 am

    #1510895

    This is a DWH system. There are only clustered indexes.

  • July 10, 2012 at 7:19 am

    This was removed by the editor as SPAM

  • July 10, 2012 at 7:20 am

    #1510900

    Stewart "Arturius" Campbell (7/10/2012)

    Therein lies the issue.

    There is a good chance that, with only clustered indexes, Clustered Index Scans are being performed on the table(s).

    Seeks are much more efficient.

    Is it possible to attach the two execution plans for review?

    & DDL

  • July 10, 2012 at 7:50 am

    #1510923

    Now, I opened a case to microsoft.

Viewing 8 posts - 1 through 7 (of 7 total)

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