SP4 performance Woes.

From: "Marcelo" <marcelo.no@xxxxxxxxxxxx>
Date: Thu, 11 Aug 2005 13:59:45 -0400

Hello,
This SQL Statement which takes 1 second on a server with SP3 takes 24
MINUTES after I upgrade to SP4.

SELECT
MDL1.[id_entity]
FROM Entity E
INNER JOIN Module_1133821_0 MOD0 ON E.id_entity=MOD0.id_entity
LEFT JOIN Module_1133821_2959 MOD2959 ON E.id_entity=MOD2959.id_entity
LEFT JOIN MEMBER_ENTITY_1133821 ME1 ON MOD2959 .[Motivo]=ME1.ID_COUNTER
LEFT JOIN Module_1133821_2995 MDL1 ON MDL1.ID_ENTITY =
ME1.ID_MEMBER_ENTITY
LEFT JOIN MEMBER_ENTITY_1133821 ME2 ON MOD2959
..[AsignadoAtClientes]=ME2.ID_COUNTER
LEFT JOIN Module_1133821_2998 MDL2 ON MDL2.ID_ENTITY =
ME2.ID_MEMBER_ENTITY
WHERE E.TYPE_ENTITY=1125851

If I select ANY field from ANY table which is being LEFT JOINED, the query
takes 24 minutes.

For now, I have downgraded to SP3.

Thanks for your help.

.

Follow-Ups:
- Re: SP4 performance Woes.
  - From: Mike Epprecht \(SQL MVP\)

Prev by Date: Re: how to shrink the .LDF ? -- spanish subtitled
Next by Date: Re: how to shrink the .LDF ? -- spanish subtitled
Previous by thread: Login failed for user 'sa'
Next by thread: Re: SP4 performance Woes.
Index(es):
- Date
- Thread

Relevant Pages

Re: How can I improve the capacity of Software Registery by W2K pro ?
... I will try to upgrade my Sp3 to Sp4. ... There zit some registry limitation. ...
(microsoft.public.win2000.registry)
Re: SQL 2000 and SP4 performance issue
... but why it was on SP3 better ... then in SP4? ... Ales ... Prev by Date: ...
(microsoft.public.sqlserver.setup)
update.exe has generated errors
... The above message comes up if I try to upgrade to sp3, sp4 ... Any advice is appreciated. ...
(microsoft.public.win2000.windows_update)
SP4
... Server with SP3. ... I try to upgrade to SP4 ...
(microsoft.public.win2000.advanced_server)
SP4 and Delphi 5
... reason to upgrade to SP4? ... Prev by Date: ...
(borland.public.delphi.non-technical)