We have upgraded a couple of customers from MSDE to SQL-Server 2005 Express.
At the same time we upgraded our app to use .NET Framework 2.0. Our app is
C++ MFC based using ADO.NET with all data access going through stored
procedures. The app is now compiled with VS 2005. Else there is no
significant changes. 1 of the customers is complaining that the data access
is significantly slower than before. As there is no specific changes to the
data access from the prev. version to the new i am asking for some tips what
can be the reason. Is SQL-server 2005 consuming more memory and if he was on
the limit before it may be the reason?

Two things to do for sure. One is to change the compatibility mode from 80
to 90 on any dbs you upgraded. The second is to run sp_updatestats on each
db.

--
Andrew J. Kelly SQL MVP

"Olav" <Olav@discussions.microsoft.com> wrote in message
news:BB907BE3-377A-4BB7-BD77-DF35F52C54B9@microsoft.com...
> We have upgraded a couple of customers from MSDE to SQL-Server 2005
> Express.
> At the same time we upgraded our app to use .NET Framework 2.0. Our app is
> C++ MFC based using ADO.NET with all data access going through stored
> procedures. The app is now compiled with VS 2005. Else there is no
> significant changes. 1 of the customers is complaining that the data
> access
> is significantly slower than before. As there is no specific changes to
> the
> data access from the prev. version to the new i am asking for some tips
> what
> can be the reason. Is SQL-server 2005 consuming more memory and if he was
> on
> the limit before it may be the reason?