Re: Strange SQL Server Timeout Problem
From: Joseph Geretz (jgeretz_at_nospam.com)
Date: 06/24/04
- Next message: DeeJay Puar: "Reduce MDF file for SQL"
- Previous message: Martin: "Reduce MDF file for SQL"
- In reply to: Joseph Geretz: "Strange SQL Server Timeout Problem"
- Next in thread: Jaxon: "Re: Strange SQL Server Timeout Problem"
- Reply: Jaxon: "Re: Strange SQL Server Timeout Problem"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 24 Jun 2004 11:31:38 -0400
Sorry, I should have mentioned:
Windows 2003 Server - Enterprise
SQL Server 2000
- Joe Geretz -
"Joseph Geretz" <jgeretz@nospam.com> wrote in message
news:ujCPf9fWEHA.4064@TK2MSFTNGP11.phx.gbl...
> We're seeing a very strange SQL Server access problem. At intermittent
> times, all users are unable to log into our software. We've traced the
> problem to the following query:
>
> INSERT INTO WORKSTATIONS SELECT MAX(WORKSTATIONID)+1, 'VMSRSSERVER1',
> GETDATE(), 0 FROM WORKSTATIONS
>
> Here's the error information returned:
>
> PROVIDER ERROR
> Error: -2147217871
> Description: Timeout expired
> Source: Microsoft OLE DB Provider for SQL Server
>
> What's strange about this is that, in order to reach this point, the
> software must have already successfully issued a SELECT statement from the
> USERS table in order to to validate credentials. It seems, that in this
> scenario, SELECT statements are successfully processed, but the first
INSERT
> statement will hang. When this happens to one user, it happens to all
users
> and no one can log into our software.
>
> Evan stranger, the situation can be corrected by simply accessing the
> database in Enterprise Manager. In this scenario, I notice that accessing
> the database takes much longer than usual, approximately 30 seconds. But
> once Enterprise Manager accesses the database, suddenly all users are able
> to log in again. Also, this seems to happen only in the morning. Once we
use
> the Enterprise Manager trick, all users can once again log in and we're
good
> until tomorrow...
>
> Has anyone seen this problem? Or if you can suggest an approach for me to
> investigate this, that would be extremely helpful as well.
>
> Thanks very much for your help!
>
> - Joe Geretz -
>
>
- Next message: DeeJay Puar: "Reduce MDF file for SQL"
- Previous message: Martin: "Reduce MDF file for SQL"
- In reply to: Joseph Geretz: "Strange SQL Server Timeout Problem"
- Next in thread: Jaxon: "Re: Strange SQL Server Timeout Problem"
- Reply: Jaxon: "Re: Strange SQL Server Timeout Problem"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
