ThreadAbortException from DbDataAdapter.Fill

Hello,

recently I have encountered with the strange issue concerning ThreadAbortException that throws DbDataAdapter.Fill (see below the stacktrace [1]). At the first time I suppose that this problem due to Command.Timeout property that was set too small, but to tell the truth it has the maximum value - 65534 and this exception throws after 10-15 minutes of execution of Stored Procedure.

Also I've noticed that the problem completely relates to SQL server when it was really loaded (about 99% of processor usage). So my question is how can I detect what causes this exception (and how to prevent it) - if it is SQL server, is it possible to modify properties of SP execution timeout or something?

All kind of information would be really helpful.

Thanks!

[1] Stacktrace:
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean
returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable,
IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
.

Relevant Pages

  • Re: Cannot define the DataMember in code
    ... Private WithEvents cmInsertAuthor As New SqlCommand ... Int32 startRecord, Int32 maxRecords, String ... srcTable, IDbCommand command, CommandBehavior behavior) ...
    (microsoft.public.dotnet.framework.adonet)
  • Error Trying to Launch Project
    ... startRecord, Int32 maxRecords, String srcTable, IDbCommand command, ... CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet ... dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand ...
    (microsoft.public.dotnet.distributed_apps)
  • Re: Data access error
    ... DataTabledatatables, Int32 startRecord, Int32 maxRecords, String ... srcTable, IDbCommand command, CommandBehavior behavior) ... startRecord, Int32 maxRecords, String srcTable, IDbCommand command, ...
    (microsoft.public.dotnet.framework.aspnet)
  • ThreadAbortException at System.Data.SqlClient.SqlCommand.ExecuteRe (BIS)
    ... startRecord, Int32 maxRecords, String srcTable, IDbCommand command, ... CommandBehavior behavior) ...
    (microsoft.public.dotnet.framework.adonet)
  • datagrid error
    ... Server]Line 1: Incorrect syntax near '.'.] ... startRecord, Int32 maxRecords, String srcTable, IDbCommand command, ... CommandBehavior behavior) +77 ...
    (microsoft.public.dotnet.framework.aspnet)