execution plan

Can hardware-related properties cause an execution plan to change when a
database is copied from one SQL 2000 server to another?
I.e., indexes and statistics should remain same. But I think number of
coprocessors can have impact. What about amout of RAM? Processor speed?
Type of hard drives?
Thanks
Craig
Craig Hessel wrote:
> Can hardware-related properties cause an execution plan to change
> when a database is copied from one SQL 2000 server to another?
> I.e., indexes and statistics should remain same. But I think number
> of coprocessors can have impact. What about amout of RAM? Processor
> speed? Type of hard drives?
> Thanks
> Craig
Yes. Everything can have an effect. Make sure you update all statistics
on the new server.
David Gugick
Imceda Software
www.imceda.com
|||Yes and no. The number of processors will determine the degree to which SQL
Server might be able to run your queries in parallel. However, there must
be idle logical schedulers available at the time the query runs for it to
actually go parallel, assuming its cost is enough to make it eligible for
parallelization. (That is to say, parallelism is an execution-time
decision, and not a compile-time decision.) Memory can have an impact as it
allows the query optimizer to decrease the potential IO cost of a query:
the more memory is available, the less IO is required, and the lower the
cost of the query. Other than that, types of hard drives and processor
speed have no effect on the *generation* of a query plan; only on the
efficiency at which a plan chosen by the QO can execute.
Ryan Stonecipher
Microsoft SQL Server Storage Engine, DBCC
This posting is provided "AS IS" with no warranties, and confers no rights.
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:%23$YHPdWDFHA.1524@.TK2MSFTNGP09.phx.gbl...
> Craig Hessel wrote:
> Yes. Everything can have an effect. Make sure you update all statistics on
> the new server.
> --
> David Gugick
> Imceda Software
> www.imceda.com