Re: Slower dataaccess after upgrading from MSDE to SQL-Server 2005
- From: "Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx>
- Date: Mon, 6 Nov 2006 10:21:04 -0500
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BB907BE3-377A-4BB7-BD77-DF35F52C54B9@xxxxxxxxxxxxxxxx
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?
.
- Prev by Date: Re: Upgrading from sql 7 to sql 2000 problems vswitch.exe
- Next by Date: Re: SQL Express Fails with Hardware Error
- Previous by thread: Upgrading from sql 7 to sql 2000 problems vswitch.exe
- Next by thread: Re: How to setup SQL Server 2000 Unicode Database
- Index(es):
Relevant Pages
|
