Re: sql2k5 performance

Did you update the statistics after the restore? Is the db in 90 compat
mode? Did you check the query plans of before and after to see what is the
difference?

--
Andrew J. Kelly SQL MVP

"Andre" <nospam@xxxxxxxx> wrote in message
news:%23KHzYDIrHHA.5032@xxxxxxxxxxxxxxxxxxxxxxx
We upgraded a dev server from sql2k to sql2k5 this past weekend. I'm now
seeing some horrible performance degradation in certain areas. For
example, a fairly simple stored proc that consistently executed in <1
second is now consistently running in 1 minute. The same stored proc
still runs in <1 sec in Prod, on SQL 2k. Is there some process I'm
supposed to run post upgrade?

Thanks in advance, Andre



.

Relevant Pages

  • Re: redirect output
    ... Andrew J. Kelly SQL MVP ... Can I do it without prior knowledge of the result set from ... > sp_lock (or other stored proc)? ...
    (microsoft.public.sqlserver.programming)
  • Re: Passing parameters to stored procedure
    ... > Andrew J. Kelly SQL MVP ... >> I have a simple stored proc that I am trying to pass a parameter list. ... >> This doesnt work. ...
    (microsoft.public.sqlserver.programming)