NETWORKIO?!?!

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jason McClellan (jason_mcc_at_obsfucated.myrealbox.com)
Date: 04/06/04 

Date: Tue, 6 Apr 2004 12:49:51 -0400

Hello.. I have a database here which is used for purchasing/stock etc. It
is an Access front end, a very simple MDE with a few queries that people
run. Backend is SQL, access utilizes linked tables. The queries return all
records by default.

Recently, two events occurred; the server which SQL lives on was
re-installed with Windows 2003 server (SQL is version 2000 standard) and the
database exceeded 32,768 records.

Previously, everything worked fine. But now, I am seeing alot of lock
contention, PID's will have 'runnable' status, with command 'SELECT', Wait
Type 'NETWORKIO' and an ever-increasing Wait Time. This occurs only in a
certain condition; if a query is run, this lock is exhibited. The lock is
released as soon as they do something with the query, filter, edit
something, or even just go to the last record (with the > button). But
until something is done with it, this lock is held on the entire table, and
nobody else can edit/add etc anything. This occurs even if the person
running the query has read-only access.

My only/best guess is that for whatever reason, there is some kind of pause,
or timeout, or something occuring when access gets to the 32k records point,
and this puts a kaibosh on the query until the user forces it to do
something. I can't be 100% sure, but there was a time after the server was
reinstalled during which it did not do this, so I am more inclined to lean
towards the 32k theory, but I can't find any info on any possible causes..
in fact I can find extremely little info even on the NETWORKIO wait type.

I would appreciate any help/ideas/info anyone might have.
Thanks
Jason

Relevant Pages

  • Re: access 2003
    ... I removed the parameters from the form query source. ... boxes from the form header, events, code, etc and ran the form query source ... forms queries and the SQL because syntax of the SQL will change randomly. ... the Access 97 database, I wouldn't have thought any expressions would be ...
    (microsoft.public.access.conversion)
  • Re: access 2003
    ... I removed the parameters from the form query source. ... synchronize combo boxes to the detail section or the parameter form query ... forms queries and the SQL because syntax of the SQL will change randomly. ... the Access 97 database, I wouldn't have thought any expressions would ...
    (microsoft.public.access.conversion)
  • Re: Query In BE database
    ... that would give the users "live" access to the underlying queries. ... When selected from the drop-down list box, I what the the query that is ... What Is A Remote Query? ... point your local query to a query that was in another Access database. ...
    (microsoft.public.access.queries)
  • Re: merge multiple databases
    ... You need to create a new Access datafile (mdb) to store all in. ... Open the newly created Access database. ... Click on the Queries icon. ... "Create new query", then select lnkDrive as the table to ...
    (microsoft.public.vb.general.discussion)
  • Re: merge multiple databases
    ... You need to create a new Access datafile (mdb) to store all in. ... Open the newly created Access database. ... Click on the Queries icon. ... "Create new query", then select lnkDrive as the table to ...
    (microsoft.public.access.queries)