December 1, 2003 at 4:55 pm
Hello.
I am purplexed with the SQL Server's behavior where it creates different execution plan (one really worse than the other) on different servers for the same query. Databases are same, row count is same, table fragmentaion is same.
Only major difference between the two servers in memory usage. One with bad plan has its memory pegged to max.
Note that this is a query and not a proc.
Is this a valid reason for SQL server to generate different exec plan?
December 1, 2003 at 7:35 pm
I think it is related to the maxed out memory as SQL may be trying to compensate as best as possible. However can you post the text version of both so we can see if anything specific may be otherwise?
December 1, 2003 at 11:24 pm
Hi there
Did you check for any table statistic differences? and the age of them? also, how are you testing? if using query-analyser I gather all is identicle in approach. Ive had similar senarios and is very hard to explain, if you get a chance consider flushing the caches and try again...
Cheers
Ck
Chris Kempster
Author of "SQL Server 2k for the Oracle DBA"
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply