InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 17 Jun 2013 22:42:56 GMT20http://www.sqlservercentral.com/Forums/Topic1357043-360-1.aspxthere could be some hardware allocation differnce like memory or cpu OR sme diiferent setting like maxdop etcThu, 11 Oct 2012 01:46:29 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1357043-360-1.aspx[quote][b]Oracle_91 (9/10/2012)[/b][hr]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.[/quote]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?Wed, 19 Sep 2012 15:20:05 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1357043-360-1.aspx[quote][b]Jason Selburg (9/12/2012)[/b][hr]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".[b]I may be wrong, and if I am someone will most likely point it out here[/b]. :w00t:[/quote]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.Wed, 19 Sep 2012 15:19:04 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1357043-360-1.aspxDid 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".[b]I may be wrong, and if I am someone will most likely point it out here[/b]. :w00t:Wed, 12 Sep 2012 06:34:10 GMTJason Selburghttp://www.sqlservercentral.com/Forums/Topic1357043-360-1.aspxBoth 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.Mon, 10 Sep 2012 22:02:24 GMTOracle_91http://www.sqlservercentral.com/Forums/Topic1357043-360-1.aspx[quote][b]Oracle_91 (9/10/2012)[/b][hr]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.[/quote]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?Mon, 10 Sep 2012 16:14:58 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic1357043-360-1.aspxHi 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.Mon, 10 Sep 2012 16:09:41 GMTOracle_91