Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
srad
Starting Member
39 Posts |
 Posted - 2002-04-29 : 05:12:02
|
A query running our on development db takes about 0.5 secs to retrieve data, the same query on our live db takes 20 secs. I have compared the execution plans on both and the live db is using a lazy spool that costs 47% of the query time whereas the development plan is using a sort costing 4%.The indexes on the queried tables are identical but the fill factor is different (development 0%, Live 70%) Would this be a cause  Why is the live db choosing a slower plan and can i force it to use a sort instead of a lazy spool . |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2002-04-29 : 07:00:44
|
| While differring database structures is one reason to give you different performance results....so too can 2 servers with different specs and/or 2 databases that are not even close in terms of database size and activity, and thus some of the difference in actual response may be apportioned there.Eliminating the differences is key to identifying the bottleneck. And once the main influencing factor is identified, you can then make an informed judgement as to what value it should really have.Remember too that it is advisable to maintain up-to-date statistics for all tables....they influence the Query plans. |
 |
|
|
|
|
|
Query execution plan