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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-08-25 : 08:57:14
|
| PM@SDT writes "Hi Guys I run a simple but clumsily written select on a rather simple join of three tables. The query will return up to 10 000 records.On any sql 2000 box this query performs adequately and after adding two indexes it performed above expectations.However on any sql 7 sp3 box it does not even finish execution. For some reason the Tempdb grows huge wile executing this query. With huge I mean until all available hd space has been taken used.The execution plans on the different boxes also differ considerably. An item I do not fully understand (Lazy spool)seems to use the most resources on the sql 7 box. It does not even feature in the execution plan on the sql 2000 box.Only by adding numerous indexes could I get this query to execute on the sql 7 box, and then only sometimes...Unfortunately optimizing the query is the last option as it is embedded in vb code.Any help with this issue will be mucy appreciated.PM@SDTP.s. Window XP pro on all boxes." |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2003-08-25 : 13:06:12
|
| What's the query?Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
 |
|
|
|
|
|
SQL 7.0 sp 3 bad query performance - TempDB grows huge but not on SQL 2000?