Timeout

[BrassicaNigra]

I have a GridView that uses a SqlDataSource.Select command to fill with data
(asp.net 2.0). The user can specify a date range for the select statement
and when the query returns a very large number of rows, I receive the
following error
message after about 30 seconds;

'The timeout period elapsed prior to completion of the operation or the
server is not responding.'

I have tried increasing the Connection Timeout in the SQL Connection String,
but
that did not make any difference.

Again, this works fine if the number of rows is smaller.

What do I need to do to correct this?

Thanks,

Dale Hoffman

 

[Gregory A. Beamer]

What do I need to do to correct this?

One easy thing is increasing the timeout for BOTH the connection and the
command. But this is not necessarily the best option.

Reducing the amount of data is another option, if possible.

You might also look at the protocols installed on SQL Server and make
sure you have the proper one installed for your app. While named pipes
may work in many instances, it can take longer in others. The same is
true for other protocols. Play around with this a bit and you might find
this is all that is the issue.

I would also recommend profiling SQL Server as it can give you some
information on where the failure is actually occuring. Is the command
being run and timing out or is only the connection being established.
Understanding the true problem will reduce time to solution.

Peace and Grace,

--
Gregory A. Beamer (MVP)

Twitter: @gbworld
Blog: http://gregorybeamer.spaces.live.com

*******************************************
| Think outside the box! |
*******************************************

 

[Vince Xu [MSFT]]

Hello Dale,

This timeout error is associated with CommadTimeOut rather than
ConnectTimeOut. So you need change the CommandTimeOut property of your
SqlCommand object.
The ConnectTimeout Property of a connection string determines how long a
SqlConnection Object runs before it stops attempting to connect to a server.


--
Sincerely,

Vince Xu

Microsoft Online Support


==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/en-us/subscriptions/aa948868.aspx#notifications.

MSDN Managed Newsgroup support offering is for non-urgent issues where an
initial response from the community or a Microsoft Support Engineer within
2 business day is acceptable. Please note that each follow up response may
take approximately 2 business days as the support professional working with
you may need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations that require urgent,
real-time or phone-based interactions. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx
==================================================



--------------------
| I have a GridView that uses a SqlDataSource.Select command to fill with
data
| (asp.net 2.0). The user can specify a date range for the select
statement
| and when the query returns a very large number of rows, I receive the
| following error
| message after about 30 seconds;
|
| 'The timeout period elapsed prior to completion of the operation or the
| server is not responding.'
|
| I have tried increasing the Connection Timeout in the SQL Connection
String,
| but
| that did not make any difference.
|
| Again, this works fine if the number of rows is smaller.
|
| What do I need to do to correct this?
|
| Thanks,
|
| Dale Hoffman
|

 

[BrassicaNigra]

How do I set the Command Timeout for aSqlDataSource.Select?

 

[Vince Xu [MSFT]]

Hello,

You can do it like this way. You can set it in Selecting event of
SqlDataSource.

protected void SqlDataSource1_Selecting(object sender,
SqlDataSourceSelectingEventArgs e)
{
e.Command.CommandTimeout = 30;
}

--------------------
| Thread-Topic: Timeout
| thread-index: Acp5vN237LSypexBRhCi4wq4sKIIPQ==
| X-WBNR-Posting-Host: 74.95.112.177
| From: BrassicaNigra <[email protected]>
| References: <[email protected]>
<[email protected]>
| Subject: RE: Timeout
| Date: Thu, 10 Dec 2009 09:19:01 -0800
| Lines: 67
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.4325
| Newsgroups: microsoft.public.dotnet.framework.aspnet
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl
microsoft.public.dotnet.framework.aspnet:94988
| NNTP-Posting-Host: tk2msftibfm01.phx.gbl 10.40.244.149
| X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
|
| How do I set the Command Timeout for aSqlDataSource.Select?
|
| "Vince Xu [MSFT]" wrote:
|
| > Hello Dale,
| >
| > This timeout error is associated with CommadTimeOut rather than
| > ConnectTimeOut. So you need change the CommandTimeOut property of your
| > SqlCommand object.
| > The ConnectTimeout Property of a connection string determines how long
a
| > SqlConnection Object runs before it stops attempting to connect to a
server.
| >
| >
| > --
| > Sincerely,
| >
| > Vince Xu
| >
| > Microsoft Online Support
| >
| >
| > ==================================================
| > Get notification to my posts through email? Please refer to
| >
http://msdn.microsoft.com/en-us/subscriptions/aa948868.aspx#notifications.
| >
| > MSDN Managed Newsgroup support offering is for non-urgent issues where
an
| > initial response from the community or a Microsoft Support Engineer
within
| > 2 business day is acceptable. Please note that each follow up response
may
| > take approximately 2 business days as the support professional working
with
| > you may need further investigation to reach the most efficient
resolution.
| > The offering is not appropriate for situations that require urgent,
| > real-time or phone-based interactions. Issues of this nature are best
| > handled working with a dedicated Microsoft Support Engineer by
contacting
| > Microsoft Customer Support Services (CSS) at
| > http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx
| > ==================================================
| >
| >
| >
| > --------------------
| > | I have a GridView that uses a SqlDataSource.Select command to fill
with
| > data
| > | (asp.net 2.0). The user can specify a date range for the select
| > statement
| > | and when the query returns a very large number of rows, I receive the
| > | following error
| > | message after about 30 seconds;
| > |
| > | 'The timeout period elapsed prior to completion of the operation or
the
| > | server is not responding.'
| > |
| > | I have tried increasing the Connection Timeout in the SQL Connection
| > String,
| > | but
| > | that did not make any difference.
| > |
| > | Again, this works fine if the number of rows is smaller.
| > |
| > | What do I need to do to correct this?
| > |
| > | Thanks,
| > |
| > | Dale Hoffman
| > |
| >
| > .
| >
|

 

[Vince Xu [MSFT]]

Hi,

Did you resolve this issue?

--

Sincerely,

Vince Xu

Microsoft Online Support

--------------------
| X-Tomcat-ID: 53877879
| References: <[email protected]>
<[email protected]>
<[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From: (e-mail address removed) (Vince Xu [MSFT])
| Organization: Microsoft
| Date: Mon, 14 Dec 2009 10:00:17 GMT
| Subject: RE: Timeout
| X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
| Message-ID: <[email protected]>
| Newsgroups: microsoft.public.dotnet.framework.aspnet
| Lines: 93
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl
microsoft.public.dotnet.framework.aspnet:95047
| NNTP-Posting-Host: tk2tomimport1.phx.gbl 10.230.18.247
|
| Hello,
|
| You can do it like this way. You can set it in Selecting event of
| SqlDataSource.
|
| protected void SqlDataSource1_Selecting(object sender,
| SqlDataSourceSelectingEventArgs e)
| {
| e.Command.CommandTimeout = 30;
| }
|
| --------------------
| | Thread-Topic: Timeout
| | thread-index: Acp5vN237LSypexBRhCi4wq4sKIIPQ==
| | X-WBNR-Posting-Host: 74.95.112.177
| | From: BrassicaNigra <[email protected]>
| | References: <[email protected]>
| <[email protected]>
| | Subject: RE: Timeout
| | Date: Thu, 10 Dec 2009 09:19:01 -0800
| | Lines: 67
| | Message-ID: <[email protected]>
| | MIME-Version: 1.0
| | Content-Type: text/plain;
| | charset="Utf-8"
| | Content-Transfer-Encoding: 7bit
| | X-Newsreader: Microsoft CDO for Windows 2000
| | Content-Class: urn:content-classes:message
| | Importance: normal
| | Priority: normal
| | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.4325
| | Newsgroups: microsoft.public.dotnet.framework.aspnet
| | Path: TK2MSFTNGHUB02.phx.gbl
| | Xref: TK2MSFTNGHUB02.phx.gbl
| microsoft.public.dotnet.framework.aspnet:94988
| | NNTP-Posting-Host: tk2msftibfm01.phx.gbl 10.40.244.149
| | X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
| |
| | How do I set the Command Timeout for aSqlDataSource.Select?
| |
| | "Vince Xu [MSFT]" wrote:
| |
| | > Hello Dale,
| | >
| | > This timeout error is associated with CommadTimeOut rather than
| | > ConnectTimeOut. So you need change the CommandTimeOut property of
your
| | > SqlCommand object.
| | > The ConnectTimeout Property of a connection string determines how
long
| a
| | > SqlConnection Object runs before it stops attempting to connect to a
| server.
| | >
| | >
| | > --
| | > Sincerely,
| | >
| | > Vince Xu
| | >
| | > Microsoft Online Support
| | >
| | >
| | > ==================================================
| | > Get notification to my posts through email? Please refer to
| | >
| http://msdn.microsoft.com/en-us/subscriptions/aa948868.aspx#notifications.
| | >
| | > MSDN Managed Newsgroup support offering is for non-urgent issues
where
| an
| | > initial response from the community or a Microsoft Support Engineer
| within
| | > 2 business day is acceptable. Please note that each follow up
response
| may
| | > take approximately 2 business days as the support professional
working
| with
| | > you may need further investigation to reach the most efficient
| resolution.
| | > The offering is not appropriate for situations that require urgent,
| | > real-time or phone-based interactions. Issues of this nature are best
| | > handled working with a dedicated Microsoft Support Engineer by
| contacting
| | > Microsoft Customer Support Services (CSS) at
| | > http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx
| | > ==================================================
| | >
| | >
| | >
| | > --------------------
| | > | I have a GridView that uses a SqlDataSource.Select command to fill
| with
| | > data
| | > | (asp.net 2.0). The user can specify a date range for the select
| | > statement
| | > | and when the query returns a very large number of rows, I receive
the
| | > | following error
| | > | message after about 30 seconds;
| | > |
| | > | 'The timeout period elapsed prior to completion of the operation or
| the
| | > | server is not responding.'
| | > |
| | > | I have tried increasing the Connection Timeout in the SQL
Connection
| | > String,
| | > | but
| | > | that did not make any difference.
| | > |
| | > | Again, this works fine if the number of rows is smaller.
| | > |
| | > | What do I need to do to correct this?
| | > |
| | > | Thanks,
| | > |
| | > | Dale Hoffman
| | > |
| | >
| | > .
| | >
| |
|
|