[dba-VB] SQL Server timeouts

Michael R Mattys mmattys at rochester.rr.com
Sun May 4 07:46:05 CDT 2008

While I was on Amazon a few days ago, the key word "Tuning"
caught my eye - - so I looked it up. This might help, but do Google:

Michael R. Mattys
MapPoint & Access Dev

----- Original Message ----- 
From: "jwcolby" <jwcolby at colbyconsulting.com>
To: "VBA" <dba-vb at databaseadvisors.com>; "Dba-Sqlserver" 
<dba-sqlserver at databaseadvisors.com>
Sent: Sunday, May 04, 2008 8:01 AM
Subject: [dba-VB] SQL Server timeouts

>I am running this process that updates SQL Server from VB.Net.  The
> process runs normally for tens of millions of records, then SQL Server
> "hangs" and stops servicing requests (from this process), either reads
> or writes.  It just times out with error messages "Timeout Expired: The
> timeout period expired prior to completion of the operation or SQL
> Server is not responding".
> This is not a once off occurrence, it happens every time I start the
> process running.  Sometimes I get this and then eventually SQL Server
> will start responding, sometimes it just stops responding.
> How do I troubleshoot this?
> -- 
> John W. Colby
> www.ColbyConsulting.com
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com 

More information about the dba-VB mailing list