Post reply

Execution plan

  • September 10, 2012 at 4:09 pm

    #261714

    Hi All,

    I have 2 sql sevr 2005 instances with same build no,same edition.

    I restored the database from one insatnce to another instance. But when i execute the same query in the second instance , it poduces are different plan and my query performance is slow now on one instance.

    Just wanted to understand how sql server or on what factors/basis sql servr produces are different plans if my stats are same ?

    Thanks in Advance.

  • September 10, 2012 at 4:14 pm

    #1535945

    Oracle_91 (9/10/2012)

    Hi All,

    I have 2 sql sevr 2005 instances with same build no,same edition.

    I restored the database from one insatnce to another instance. But when i execute the same query in the second instance , it poduces are different plan and my query performance is slow now on one instance.

    Just wanted to understand how sql server or on what factors/basis sql servr produces are different plans if my stats are same ?

    Thanks in Advance.

    Are there any differences in how the instances are configured? Are the instances on the same server or different servers? If different servers, how are these servers configured?

  • September 10, 2012 at 10:02 pm

    #1536000

    Both are two different server with configuration. But on the second servers there are 2 instances.

    One more thing, the second is not at all running on the second box.

  • September 12, 2012 at 6:34 am

    #1536682

    Did you rebuild statistics?

    I do believe that even though the servers may be configured the same/same hardware, when you restore a database the stats get "out of whack".

    I may be wrong, and if I am someone will most likely point it out here. :w00t:

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg

  • September 19, 2012 at 3:19 pm

    #1539816

    Jason Selburg (9/12/2012)

    Did you rebuild statistics?

    I do believe that even though the servers may be configured the same/same hardware, when you restore a database the stats get "out of whack".

    I may be wrong, and if I am someone will most likely point it out here. :w00t:

    A restore will not affect the statistics. A restore gives us an exact page-for-page database as existed when the database was backed up.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • September 19, 2012 at 3:20 pm

    #1539818

    Oracle_91 (9/10/2012)

    Hi All,

    I have 2 sql sevr 2005 instances with same build no,same edition.

    I restored the database from one insatnce to another instance. But when i execute the same query in the second instance , it poduces are different plan and my query performance is slow now on one instance.

    Just wanted to understand how sql server or on what factors/basis sql servr produces are different plans if my stats are same ?

    Thanks in Advance.

    If the optimizer chooses a parallel plan that could account for a difference. Can you please post both execution plans attached to this thread as .sqlplan files?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • October 11, 2012 at 1:46 am

    #1547915

    there could be some hardware allocation differnce like memory or cpu OR sme diiferent setting like maxdop etc

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

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

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