slowing/halting stored procedure from ado.net

Hi,
I've strange problem with an application developed with VB.NET 2008/ADO.NET
framework target 2.0 and SQL Server 2005.
Sometimes a certain stored procedure wich normally executes in seconds,
suddenly takes forever (15minutes plus).
When I execute the stored procedure from within SQL Server Management Studio
it always executes fast (42000+ records in 1 second), even when from ADO.NET
it takes forever.
When the slowdown appears, restarting the application does not help.
When I do modify/execute in man.studio, the slowdown goes away, and
application does it normal quick response.
Activity monitor show no blocking other queries.

The stored procedure is called with a command object and an dataadapter
filling a dataset. When I break the application in visual studio, it breaks
on the da.fill(ds) line.
I cannot find any pattern in when the slowdown starts, sometime once a
week, once a day or 3 weeks without a problem.
Records added to the table are about 45 records per day (mean).

Can anyone shed some light on this problem??

.

Relevant Pages

  • Re: Tracing user & permissions (triggers and stored p)
    ... To solve my problem I chosed to configure the SQL ... > from xp_cmdshell executes under the security context of the SQL Server ... >> sql Trigger executes a Stored Procedure passing it some variables. ...
    (microsoft.public.sqlserver.security)
  • RE: slowing/halting stored procedure from ado.net
    ... running the stored procedure from within SQL Management Studio always ... When I execute the stored procedure from within SQL Server Management Studio ... it always executes fast, ... When the slowdown appears, restarting the application does not help. ...
    (microsoft.public.dotnet.framework.adonet)
  • SQL SERVER
    ... I have a scheduled job in sql server. ... This job is a executes a stored procedure. ...
    (microsoft.public.sqlserver.programming)
  • Setting size for a parameter for a varchar(max) field
    ... I am writing an application using VS2008 and SQL Server 2005. ... code that executes a stored procedure for a table that has a field ...
    (microsoft.public.vb.database.ado)
  • Re: SQL server 2005 Express - Vista - Invalid object name #spdbdesc
    ... If you need to post the same question to multiple groups, post the message once to all groups in order to avoid duplication of effort. ... me with SQL Server Developer Edition under Vista. ... my application executes the stored procedure "sp_helpdb" ...
    (comp.databases.ms-sqlserver)