SQL 2005 takes much longer time to execute a store procedure

Hi

I got a Problem with a SP procedure execution which runs perfectly
fine in SQL 2000 within 1 sec and same query when i run on SQL 2005
it takes 3 min 45 sec +- 2 seconds

I got SQL 2000 std and SQL 2005 std RTM running on same machine on
a Windows server 2003 std editon ,
I have a staging envirnoment and its the same there takes much
longer time in SQL 2005

I have couple of more queries which takes longer in SQL 2005 than
SQL 2000

all SPs are taking parameters and executes a select statement


Did the following :

Update stats,rebuilded index ,CL level changed to 80/90 ,did index
defrag but no luck

ANy help is highly appreciated

Thanks
Shree

.

Relevant Pages

  • Re: SQL 2005 takes much longer time to execute a store procedure
    ... Can you compare the execution plans in both versions and see if there is any ... fine in SQL 2000 within 1 sec and same query when i run on SQL 2005 ... I got SQL 2000 std and SQL 2005 std RTM running on same machine on ... longer time in SQL 2005 ...
    (microsoft.public.sqlserver.security)
  • Re: Enterprise Library - DataAccessApplicationBlock - MySql/DB2
    ... lot longer time to get it to that point. ... to address in ADO.NET is a standard way of setting the parameters in the SQL ... The ApplicationBlock isn't ADO so it's portability limitations don't reflect ... ADO will be like JDBC where it is truly portable... ...
    (microsoft.public.dotnet.framework.adonet)
  • Share Point - SBS - moving from one drive to another
    ... We are running SBS 2003 STD - no SQL and this is Dell OEm preinstall. ... are reaching capacity of the C drive. ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 2003 Standart Server und eigener SQL Server
    ... spricht etwas dagegn auf einen SBS2003 Server ... > einen SQL Server zu installieren? ... Premium Edition oder Std. ...
    (microsoft.public.de.german.backoffice.smallbiz)
  • Win 2003/SQL 2000 MDAC 2.8RTM db repair
    ... I had an app install that screwed the MDAC install on a Win2003 Std Ed ... I found a security patch for sql 2000, ...
    (microsoft.public.sqlserver.odbc)