[dba-VB] SQL Server timeouts

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:
http://www.codeproject.com/KB/database/sql-tuning-tutorial-1.aspx

Michael R. Mattys
MapPoint & Access Dev
www.mattysconsulting.com

----- 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