Re: Slow initial record write

From: joeblues (joeblues_at_discussions.microsoft.com)
Date: 12/02/04 

Date: Wed, 1 Dec 2004 16:53:01 -0800

Keith,

I ran the specified query and found that the current state is for
'autoclose' as 'off' so I guess this isn't the issue.

The application software that we are using is made by Exact Software and it
is their product Alliance Manufacturing. The software works with either
Access databases or SQL ones.

I have asked the application software people and they don't have a clue.
They feel that it is a SQL configuration question (naturally) and sort of
pass the buck on it.

We have also had a few instances lately where the software has stalled out
during the day. After a wait it eventually goes through, but it is
aggravating when it happens.

When it happened today, I went to the fileserver Event Viewer and looked to
see if there were any related errors. There was one message that referred
directly to the SQL server and it was as follows:

Error: 15457, Severity: 0, State: 1
Configuration option 'show advanced options' changed from 1 to 1. Run
the RECONFIGURE statement to install.

Is this meaningful to you at all?

Thanks for the help so far.

Joe

"Keith Kratochvil" wrote:

> Perhaps Autoclose is set "on"
>
> To find out execute the following within Query Analyzer:
> exec sp_dboption 'YourDatabaseNameGoesHere', 'autoclose'
>
> If the CurrentSetting is "on" that means that autoclose is set on. You can
> read about autoclose within Books Online, but generally you want to leave it
> off.
>
> To turn autoclose off:
> exec sp_dboption 'YourDatabaseNameGoesHere', 'autoclose', 'off'
>
> How do you insert, update, or delete? Stored procedures? Is the problem
> repeatable within Query Analyzer? Before you insert, update, or delete data
> does your application retrieve data first? If autoclose is set on and you
> don't retrieve data (and open the database) the time you have to wait could
> be due to the database starting up. What database access method are you
> using? What type of application are you using to access/modify data within
> SQL Server?
>
> --
> Keith
>
>
> "joeblues" <joeblues@discussions.microsoft.com> wrote in message
> news:C31E1A4B-F68F-4E25-BD8D-E48782E56BF4@microsoft.com...
> > Using SQL server 2000 with third party application software. If database
> has
> > no activity for a period of time (maybe a few hours or so), the first time
> we
> > try to change, delete or write a record to the database it takes four to
> > seven minutes to accept the record write.
> >
> > You can browse records at a normal pace, but any kind of activity that
> > requires a change to a record in the database experiences this delay.
> After
> > this initial record is handled, activity is just fine and the very next
> > record will go through nice and quick.
> >
> > Is there any kind of standby or idle state that the SQL server might go
> > through if it is inactive for a period of time? Can this be adjusted or
> > changed?
>
>

Relevant Pages

  • RE: full-text search failed with one million of key words (Sqlserv
    ... Research with "toto" was just a test. ... In real life, my database contains ... for only one book) And the table i want to query looks like this: ... I have to make big tests with sql server 2005 express (i'm waiting credits ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Error 25081: Incorrectly generating identities after a merge
    ... database similarly to SQL Server CE Replication. ... On the SQL Server 2000 database with replicated tables from the original ... The I synchronized that database and ran the same query: ... >> synchronization. ...
    (microsoft.public.sqlserver.ce)
  • Re: Looking for a professional SQL programmer for a small job
    ... Pro SQL Server 2000 Database Design - ... I have two queries to build and while I know my way around SQL, ... >> One is a seach query that pull rental properties from a database based on ...
    (microsoft.public.sqlserver.programming)
  • Re: Using a worksheet as a table in an SQL query
    ... I'll probably just dump the SQL Server data to a spreadsheet and join the two spreadsheets. ... You could use Access to link to both sources and create a crosstab query. ... There are ways to enter the data into their database via the application, but it would require them to go to many different windows instead of being able to enter the data all on one screen. ... There is not a great deal of data they would enter on the spreadsheet, but I'm not sure how slow that would make the query. ...
    (microsoft.public.excel.programming)
  • Re: Slow initial record write
    ... > 'autoclose' as 'off' so I guess this isn't the issue. ... > directly to the SQL server and it was as follows: ... >> To find out execute the following within Query Analyzer: ... >> be due to the database starting up. ...
    (microsoft.public.sqlserver.setup)