Re: MSSQL7 and WinXP

From: Jim Young (thorium48_at_hotmail.com)
Date: 06/18/04 

Date: Fri, 18 Jun 2004 09:44:47 -0700

See the BOL for information concerning the AUTO_CLOSE option. It appears to
me that you have that enabled (the default for MSDE) and the database server
is closing the database after all connected clients are disconnected.

Jim

"Stefan M. Huber" <looseleaf@gmx.net> wrote in message
news:opr9qpvxj0s9ddfw@news.individual.de...
> Hi!
>
> We're closer to a solution to our problem with slow machines on a MSDE
> database (two weeks ago).
> We now have one standalone machine that runs MSSQL7, SP4 (SP4 was
> installed after it did not work without it).
> The computer has been freshly set up with WinXPPro, MSSQL7 and our
> application. All current Windowsupdates applied afterwards.
>
> OK, what we have now:
> 1) Extremely quick resutls when using osql
> 2) Extremely slow startup time of our application. (Delphi, using ADO as
> connection)
>
> The reason for 2) is (or rather one effect of it) can be seen in the error
> log:
> --------8<---------
> 2004-06-17 15:14:19.43 spid5 Startet Datenbank 'Patient'.
> 2004-06-17 15:14:19.43 spid5 Opening file C:\MSSQL7\data\Patient.mdf.
> 2004-06-17 15:14:19.43 spid5 Opening file
> C:\MSSQL7\data\Patient_log.LDF.
> 2004-06-17 15:14:20.01 spid14 Closing file
C:\MSSQL7\data\Stammdaten.mdf.
> 2004-06-17 15:14:20.01 spid14 Closing file
> C:\MSSQL7\data\Stammdaten_log.LDF.
> --------8<---------
>
> Sections like this one are repeated *quite* often, read: immediately
> afterwards. Several times. For approx.10 seconds per database. (which
> makes about 10-20 retries).
>
> We then noticed that this machine has hyperthreading enabled, which we
> disabled. The entries in the log file were reduced to a more sensible
> amount, still it happens more often than on other machines with our
> software and MSSQL7 or MSDE.
>
> Question: What else can we do? Is there something with respect to
> hyperthreading that can still interfere? Have others also seen multiple
> repeating entries in the log files and have a clue as to where they come
> from?
>
> Thanks for reading,
> Stefan
>

Relevant Pages

  • Exception: System resource exceeded, ODBC, MS ACCESS
    ... I get the above exception while generating the database. ... Only on some machines the above exception occurs(randomly, ... So I generated a log file using ODBC tracing on ODBC driver. ...
    (microsoft.public.data.odbc)
  • MSSQL7 and WinXP
    ... We're closer to a solution to our problem with slow machines on a MSDE ... The computer has been freshly set up with WinXPPro, MSSQL7 and our ... For approx.10 seconds per database. ... The entries in the log file were reduced to a more sensible ...
    (microsoft.public.sqlserver.msde)
  • ISV using SQL Authentication and a small concern
    ... all 3 users running my app on their individual machines and talking to db. ... my concern is, will this scenario work, I mean no matter who the user is, my app logs into msde using sa and "myPassword$2", so will MSDE allow 3 users with same logins to access database at the same time. ...
    (microsoft.public.sqlserver.msde)
  • ISV Using SQL Authentication - a login concern
    ... all 3 users running my app on their individual machines and talking to db. ... my concern is, will this scenario work, I mean no matter who the user is, my app logs into msde using sa and "myPassword$2", so will MSDE allow 3 users with same logins to access database at the same time. ...
    (microsoft.public.sqlserver.security)
  • Large Log File
    ... Have a log file that seems to be growing out of all proportion to the ... Have tried SHRINKDATABASE and SHRINKFILE ... As all transactions completed ages ago, am puzzled as to why MSDE seems to ... How can I get MSDE to clear all the transactions, to the database, so can ...
    (microsoft.public.sqlserver.msde)