I have two 4 way server( production and test)
The only difference being IO layout and production has more RAM than the
test box
Same database on both ( did a backup and restore so as to be identical in
schema,etc)
but the query plans are different. it runs in like 1 sec in test and over a
min in production.
How do i go about getting the same query plan from test over to production ?Hassan,
Check to make sure the statistics are current and up-to-date. Out-of-date
statistics can cause the optimizer to choose a different access method.
HTH
Jerry
"Hassan" <hassanboy@.hotmail.com> wrote in message
news:OjHNVyA1FHA.3892@.TK2MSFTNGP12.phx.gbl...
>I have two 4 way server( production and test)
> The only difference being IO layout and production has more RAM than the
> test box
> Same database on both ( did a backup and restore so as to be identical in
> schema,etc)
> but the query plans are different. it runs in like 1 sec in test and over
> a min in production.
> How do i go about getting the same query plan from test over to production
> ?
>
Showing posts with label layout. Show all posts
Showing posts with label layout. Show all posts
Friday, March 23, 2012
query plans different
I have two 4 way server( production and test)
The only difference being IO layout and production has more RAM than the
test box
Same database on both ( did a backup and restore so as to be identical in
schema,etc)
but the query plans are different. it runs in like 1 sec in test and over a
min in production.
How do i go about getting the same query plan from test over to production ?Hassan,
Check to make sure the statistics are current and up-to-date. Out-of-date
statistics can cause the optimizer to choose a different access method.
HTH
Jerry
"Hassan" <hassanboy@.hotmail.com> wrote in message
news:OjHNVyA1FHA.3892@.TK2MSFTNGP12.phx.gbl...
>I have two 4 way server( production and test)
> The only difference being IO layout and production has more RAM than the
> test box
> Same database on both ( did a backup and restore so as to be identical in
> schema,etc)
> but the query plans are different. it runs in like 1 sec in test and over
> a min in production.
> How do i go about getting the same query plan from test over to production
> ?
>
The only difference being IO layout and production has more RAM than the
test box
Same database on both ( did a backup and restore so as to be identical in
schema,etc)
but the query plans are different. it runs in like 1 sec in test and over a
min in production.
How do i go about getting the same query plan from test over to production ?Hassan,
Check to make sure the statistics are current and up-to-date. Out-of-date
statistics can cause the optimizer to choose a different access method.
HTH
Jerry
"Hassan" <hassanboy@.hotmail.com> wrote in message
news:OjHNVyA1FHA.3892@.TK2MSFTNGP12.phx.gbl...
>I have two 4 way server( production and test)
> The only difference being IO layout and production has more RAM than the
> test box
> Same database on both ( did a backup and restore so as to be identical in
> schema,etc)
> but the query plans are different. it runs in like 1 sec in test and over
> a min in production.
> How do i go about getting the same query plan from test over to production
> ?
>
query plans different
I have two 4 way server( production and test)
The only difference being IO layout and production has more RAM than the
test box
Same database on both ( did a backup and restore so as to be identical in
schema,etc)
but the query plans are different. it runs in like 1 sec in test and over a
min in production.
How do i go about getting the same query plan from test over to production ?
Hassan,
Check to make sure the statistics are current and up-to-date. Out-of-date
statistics can cause the optimizer to choose a different access method.
HTH
Jerry
"Hassan" <hassanboy@.hotmail.com> wrote in message
news:OjHNVyA1FHA.3892@.TK2MSFTNGP12.phx.gbl...
>I have two 4 way server( production and test)
> The only difference being IO layout and production has more RAM than the
> test box
> Same database on both ( did a backup and restore so as to be identical in
> schema,etc)
> but the query plans are different. it runs in like 1 sec in test and over
> a min in production.
> How do i go about getting the same query plan from test over to production
> ?
>
The only difference being IO layout and production has more RAM than the
test box
Same database on both ( did a backup and restore so as to be identical in
schema,etc)
but the query plans are different. it runs in like 1 sec in test and over a
min in production.
How do i go about getting the same query plan from test over to production ?
Hassan,
Check to make sure the statistics are current and up-to-date. Out-of-date
statistics can cause the optimizer to choose a different access method.
HTH
Jerry
"Hassan" <hassanboy@.hotmail.com> wrote in message
news:OjHNVyA1FHA.3892@.TK2MSFTNGP12.phx.gbl...
>I have two 4 way server( production and test)
> The only difference being IO layout and production has more RAM than the
> test box
> Same database on both ( did a backup and restore so as to be identical in
> schema,etc)
> but the query plans are different. it runs in like 1 sec in test and over
> a min in production.
> How do i go about getting the same query plan from test over to production
> ?
>
Query plan
I have 2 SQL Servers with same hardware, configuration and database layout,
but the query plans are different on each server. I tried to look on BOL and
websites and have not find an aswer to why they are different even though
they have same data set. If you have experience this situation before or
know the answer, please help. Thanks!If the data is really the same, as well as the rest of the things you
mention, then I would look at updating statistics on both systems and
see if that brings them closer to using the same plans.
Roy Harvey
Beacon Falls, CT
On Wed, 5 Jul 2006 17:08:02 -0700, KTN <KTN@.discussions.microsoft.com>
wrote:
>I have 2 SQL Servers with same hardware, configuration and database layout,
>but the query plans are different on each server. I tried to look on BOL and
>websites and have not find an aswer to why they are different even though
>they have same data set. If you have experience this situation before or
>know the answer, please help. Thanks!
but the query plans are different on each server. I tried to look on BOL and
websites and have not find an aswer to why they are different even though
they have same data set. If you have experience this situation before or
know the answer, please help. Thanks!If the data is really the same, as well as the rest of the things you
mention, then I would look at updating statistics on both systems and
see if that brings them closer to using the same plans.
Roy Harvey
Beacon Falls, CT
On Wed, 5 Jul 2006 17:08:02 -0700, KTN <KTN@.discussions.microsoft.com>
wrote:
>I have 2 SQL Servers with same hardware, configuration and database layout,
>but the query plans are different on each server. I tried to look on BOL and
>websites and have not find an aswer to why they are different even though
>they have same data set. If you have experience this situation before or
>know the answer, please help. Thanks!
Query plan
I have 2 SQL Servers with same hardware, configuration and database layout,
but the query plans are different on each server. I tried to look on BOL an
d
websites and have not find an aswer to why they are different even though
they have same data set. If you have experience this situation before or
know the answer, please help. Thanks!If the data is really the same, as well as the rest of the things you
mention, then I would look at updating statistics on both systems and
see if that brings them closer to using the same plans.
Roy Harvey
Beacon Falls, CT
On Wed, 5 Jul 2006 17:08:02 -0700, KTN <KTN@.discussions.microsoft.com>
wrote:
>I have 2 SQL Servers with same hardware, configuration and database layout,
>but the query plans are different on each server. I tried to look on BOL a
nd
>websites and have not find an aswer to why they are different even though
>they have same data set. If you have experience this situation before or
>know the answer, please help. Thanks!
but the query plans are different on each server. I tried to look on BOL an
d
websites and have not find an aswer to why they are different even though
they have same data set. If you have experience this situation before or
know the answer, please help. Thanks!If the data is really the same, as well as the rest of the things you
mention, then I would look at updating statistics on both systems and
see if that brings them closer to using the same plans.
Roy Harvey
Beacon Falls, CT
On Wed, 5 Jul 2006 17:08:02 -0700, KTN <KTN@.discussions.microsoft.com>
wrote:
>I have 2 SQL Servers with same hardware, configuration and database layout,
>but the query plans are different on each server. I tried to look on BOL a
nd
>websites and have not find an aswer to why they are different even though
>they have same data set. If you have experience this situation before or
>know the answer, please help. Thanks!
Subscribe to:
Posts (Atom)