SQL Server 2005 Express slow comapared to MSDE?

The more important factor that makes SQL Server faster is RAM. SQL Express
is larger (takes more RAM). Vista is larger (takes more RAM). QED:: max out
your RAM (32-bit 3.5GB, 64-bit 4-6GB). Of course, moving the SQL Express
instance to a dedicated server that does not have to contend with
user-friendly UI junk, toys, apps and other overhead would further improve
performance. That said, most performance problems are caused by inefficient
database designs and implementations. See the early chapters of my book for
more info.

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________



"Andrea Montanari" wrote in message

> hi Nick,
> Nickeluring wrote:
>> Greetings,
>> We have an application developed in .NET 1.1 (Visual Studio 2003).
>> The application has been using MSDE as the database engine until now.
>> Since MSDE won't be supported on Vista we've tried SQL Server 2005
>> Express instead. But the performance of 2005 Express is way slower
>> than when using MSDE.
>> What causes this? Is there a way to configure 2005 Express to
>> increase the performance?
>> I'd appreciate any help and suggestions.
>> Cheers,
>> Nick
>
> SQLExpress 2005 is "way larger" as MSDE, in the architectural point of
> view.. so SQLExpress will run "slower" compared to MSDE on the very same
> machine..
> but, dealing with "upgrades", you can try verifying the database's
> statistics are up to date as SQL Server/MSDE 2000 upgraded database are
> yes upgraded in the internal metadata but not in the statistic population,
> so that query plans could not be executed in the best possible "way".. try
> thus an UPDATE STATISTICS ... WITH FULLSCAN; for each and every table in
> your db(s)..
> regards
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://www.hotelsole.com
> DbaMgr2k ver 0.21.1 - DbaMgr ver 0.65.1 and further SQL Tools
> --------- remove DMO to reply
>
 >> Stay informed about: SQL Server 2005 Express slow comapared to MSDE? 

Thank you for your replies. I appreciate your help.

I have tried to update the statistics with no change in the performance.

The machine I've been tested on has more RAM than will be used when running
the application, so I don't think adding more RAM will improve the
performance either.
The database deisgn might not be the best, but in this case it's a matter of
a small amount of data. We have a master-grid / details-grid relation. When
moving around in the master-grid, it's the update of the details-grid that is
time consuming when using SQL Server 2005 Express.

The application is a stand-alone desktop application that any user should be
able to install on his/her computer so a server solution won't work either.

Thanks,
Nick
 >> Stay informed about: SQL Server 2005 Express slow comapared to MSDE?