You might just want to reindex.. it sounds like that having that big a
difference in performance, a dbcc reindex is in your future. I've had tables
that have degraded in performance, and all the dbcc checkdb's or tables's
had shown little in the way of cause, but after a reindex I've seen
performance jump from minutes to milliseconds.
Good Luck!
-----Original Message-----
From: Nam Nguyen
[mailto:mssqldba-ezmlmshield-x72876512.[Email address protected]
Sent: Friday, October 29, 2004 10:28 AM
To: LazyDBA Discussion
Subject: RE: SUSPECT: Union in Query Different execution plans
Server A is more powerful than Server B has more everything (server B is
the back up for A)
I'm not sure about table statistics...
-----Original Message-----
From: Schlieper Paul
[mailto:mssqldba-ezmlmshield-x85874677.[Email address protected]
Sent: Friday, October 29, 2004 7:33 AM
To: LazyDBA Discussion
Subject: RE: SUSPECT: Union in Query Different execution plans
Is the hardware indentical? RAM?
Table statistics?
-----Original Message-----
From: Nam Nguyen
[mailto:mssqldba-ezmlmshield-x34744372.[Email address protected]
Sent: Thursday, October 28, 2004 12:02 PM
To: LazyDBA Discussion
Subject: SUSPECT: Union in Query Different execution plans
Hi,
I have a query which contains a union and it runs incredibly slow on server
A 2-3 minutes,
however when I run it on server B which should be identical it takes only
6-10 seconds
I checked the Execution plan on both servers and the Execution plan for
server B has an addition step which I assume is making it faster
it's an Index Spool/Eager Spool step.
Would like to know how to make server A perform this step.
Thanks a ton
Nam Nguyen
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
MS Sql Server LazyDBA home page