What causes Timeout expired SqlExceptions in LINQ to SQL?

c# sql-server sql-server-2005 linq-to-sql sqlexception
Jason Baker picture Jason Baker · May 8, 2009 · Viewed 14.8k times · Source

My application keeps running into Timeout Expired SqlExceptions. The thing is that this query is one that will simply have to run for a decent amount of time. I'm having trouble figuring out where this exception is occurring though. Is this a timeout that's created at the database server or is it happening in my program? Or if it could be both, how do I figure out which one it is?

And lastly, how do I extend the timeout period?

Answer

KM. picture KM. · May 8, 2009

increase timeout = BAD
fix query = GOOD

I'm not sure of all the details involved, but in general the followng applies:

when a query runs slow do the following in management studio:

  • run SET ShowPlan_All ON
  • run your query
  • look at the output for the word "scan". your problem is there.

"Scan" = touch each row (table or index). Would you like to "scan" a phone book looking for one number or use the index?

Related questions

What represents a double in sql server?

I have a couple of properties in C# which are double and I want to store these in a table in SQL Server, but noticed there is no double type, so what is best to use, decimal or float? This …

Read More
How can I convert ticks to a date format?

I am converting a ticks value to a date like this: Convert(datetime, (MachineGroups.TimeAdded - 599266080000000000)/864000000000); Using this i get: 9/27/2009 10:50:27 PM But I want just the date in this format: October 1, 2009 My sample ticks value is 633896886277130000 What is the best …

Read More
Received an invalid column length from the bcp client for colid 6

I want to bulk upload csv file data to sql server 2005 from c# code but I am encountering the below error - Received an invalid column length from the bcp client for colid 6. when bulk copy write to database server

Read More