Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Queries(joins?) slow after applying sql2000 SP4. Expand / Collapse
Author
Message
Posted Wednesday, October 17, 2012 7:09 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, September 3, 2014 7:20 AM
Points: 51, Visits: 307
We have a couple servers still running sql2000, we just upgraded one to SP4 from 8.00.2039, a simple query

select * from person_time pt
right join person_time_data ptd on pt.person_time_key=ptd.person_time_key
where pt.person_time_key is null

takes 37 seconds after the patch, we cloned the system to a VM prior to the upgrade and the same query takes 4 seconds there.

Any insight would be helpful. how a server pack can effect joins?..
Post #1373776
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse