Slowness after Sql 7 SP 3 install

  • I installed Sql 7 Sp3 on a production server over the weekend. Users report very sluggish performance today. I see a lot of Page locks on a select database (GRANT). Any ideas?

  • Check your statistics, maybe rebuild them?

    Andy

  • Also if this is a fairly large dataabse that has been running for a while the stop and restart would have cleared the query cache and query plans of eveything except Stored Procedures. How long was it been up since last stop/start?

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply