Re: Speed of SQLExpress vs SQL2005

Do take note of Rogers suggestion as well. It is good to know that behavior
exists with Express.

--
Andrew J. Kelly SQL MVP

"Brad Carroll" <BradCarroll@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E04C8B49-2220-4CB9-BAFC-8B2AE0BB320E@xxxxxxxxxxxxxxxx
Running SP_UpdateStats fixed the issue. thanks for the quick turn around
on
this.

"Roger Wolter[MSFT]" wrote:

If this is the first transaction you run and if you're the only one
logging
on, then it's probably an autoclose issue. By default, SQL Express
databases are autoclose to minimize resource usage. That means the first
query you run after login on will take much longer because the database
has
to be started. Try measuring the second query or turning off autoclose
on
the database.

--
This posting is provided "AS IS" with no warranties, and confers no
rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

"Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx> wrote in message
news:OehYuISnGHA.1044@xxxxxxxxxxxxxxxxxxxxxxx
Did you update the statistics after you restored the db? If not try
running sp_updatestats. Also make sure you run it multiple times to
remove
any caching issues.

--
Andrew J. Kelly SQL MVP

"Brad Carroll" <BradCarroll@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9CAE113A-521E-456E-A45B-6763798F0CE7@xxxxxxxxxxxxxxxx
I have been tasked with testing SQLExpress with my companys software
and I
am
running into a speed issue with SQLExpress. I have ran our
applications
with
no problems on SQL2005 developers edition but once I uninstall it and
reinstall SQLExpress the performance problems are back. I have ran a
trace on
both versions and I am seeing vast differances in the times for the
same
exact querry.
0 ms on 2005 and 550 ms on SQL express. I am running both tests on a 1
Ghz
machine with 512 MB of memory. Both tests are using TCP/IP protocol
Anyone have any ideas?







.

Relevant Pages

  • Re: Performance really poor if calling data from sql clients
    ... Andrew J. Kelly SQL MVP ... The TCP connection is running from the client ... On a computer running the test which is not the database hosting ...
    (microsoft.public.sqlserver.clients)
  • Re: Performance really poor if calling data from sql clients
    ... Andrew J. Kelly SQL MVP ... The TCP connection is running from the client ... On a computer running the test which is not the database hosting ...
    (microsoft.public.sqlserver.clients)
  • Re: Fill Factor
    ... Well the only way it would go back to 90 is if someone or something is reindexing with a different fill factor. ... Andrew J. Kelly SQL MVP ... > database, i deployed a database to a client and sit the Fill Factor for ...
    (microsoft.public.sqlserver.setup)
  • Re: DataBase
    ... Andrew J. Kelly SQL MVP "Andrew J. Kelly" wrote in message ... Sorry I don't know anything about> dbase being supported with windows other than there are odbc and possibly> oledb drivers for it now, ... What I actually need to>> know>>>> is it posible to create this as a database and create tables in it, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: different environment fails to fill a dataset
    ... Are you sure that the login on the Test system has the database Planit as ... Andrew J. Kelly SQL MVP ... on the test workstation but not my development station. ...
    (microsoft.public.sqlserver.clients)