RE: sql server 2005 OleDbException timeout

[Database Administrator]

Yes - identical problem



"pbx" wrote:

>
> Every once in a while I will get an exception like this in my .NET
> app:
>
> System.Data.OleDb.OleDbException: Timeout expired at
> System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior
> behavior, String method) at
> System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at ...
>
> At first I figured it was a simple timeout problem. The default is 30
> seconds and the query was just taking longer. Then I found that the
> query in question executes very fast (under 2 seconds) relative to the
> timeout of 30. So I figured my problem might be a concurrency issue,
> where another connection was busy on the table in question. But on
> further review that didn't seem to be the case.
>
> It turns out that SQL Server is slowing down at unpredictable times...
> causing all queries to take 10x or more time than normal. It will go
> into "slow" mode for a period of time (maybe 10 minutes) and then come
> out of it. I have seen this a couple of times. One way to "fix" it
> (stop it from continuing to be slow) is to restart the server. When
> it is slow there is nothing else on the system that might interfere,
> plenty of memory, nominal CPU use, etc.
>
> Has anyone else seen this?
>
>

[spikeinin]

I have never been experience that sql server 2005 OleDbException timeout, maybe the hard ware compatibility?