Results 1 to 10 of 10

Thread: Slowdown with sql 2000 SP4

  1. 04-30-2007, 09:57 AM #1
    timc
    timc is offline Registered User
    Join Date
    Nov 2002
    Posts
    261

    Slowdown with sql 2000 SP4

    I have a production sql 2000 box with 24 gig of memory running 3rd part app. There is a posting process (takes all the orders and does the math). Before we did the upgrade it was a 15-20 minute process. Nothing has changed, but in the last month it has gone 60-75 minutes. There were also some windows updates applied (win 2003 adv server). I realize looking for the needle in the haystack, but has anyone seen this issue with either the sql sp4 or windows SP for 2003?
    Reply With Quote Reply With Quote
  2. 04-30-2007, 10:03 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    With 24 GB of memory you must be using AWE option. SP4 had a problem with AWE, there is a patch available at Microsoft.
    Reply With Quote Reply With Quote
  3. 04-30-2007, 10:15 AM #3
    timc
    timc is offline Registered User
    Join Date
    Nov 2002
    Posts
    261
    Done that, memory is fine
    Reply With Quote Reply With Quote
  4. 04-30-2007, 11:26 AM #4
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Did you rebuild index or update statistics after applying sp4?
    Reply With Quote Reply With Quote
  6. 04-30-2007, 11:32 AM #5
    timc
    timc is offline Registered User
    Join Date
    Nov 2002
    Posts
    261
    Yes, both are done on weekend
    Reply With Quote Reply With Quote
  7. 04-30-2007, 03:15 PM #6
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Possible to recompile sps?
    Reply With Quote Reply With Quote
  8. 04-30-2007, 03:16 PM #7
    timc
    timc is offline Registered User
    Join Date
    Nov 2002
    Posts
    261
    Yes is there an issue with this?
    Reply With Quote Reply With Quote
  9. 05-01-2007, 08:29 AM #8
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    To get better plan with up to date statistics.
    Reply With Quote Reply With Quote
  11. 05-01-2007, 02:29 PM #9
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Do you have any other server on Sp3?. You may want to compare query plan for the task on SP3 and Sp4.
    Reply With Quote Reply With Quote
  12. 05-02-2007, 09:28 AM #10
    timc
    timc is offline Registered User
    Join Date
    Nov 2002
    Posts
    261
    Problem solved, related to indexes. I have a small maintnenance window and had been rebuilding groups of indexes since applying sp4. I finished my last group Sunday, and now the psoting time is back to normal.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules