ADODB vs ADO.Net or protocol difference.

Hi,
I have 2 apps doing the same job, one is older and using adodb to query sql
server 2005, another is using ado.net. Something has happened and now app
using ado.net execution time of some stored procedures has increased about
~20 times from <1s to 20s in comparison with older app.
The older app is working fast as usual. By using SQL Profiler the only
difference between adodb app and ado.net app is a Sort Warning for ado.net.
The stored procedure is quite complex, but is fast enough using adodb or SQL
Management Studio. Database is for development purpose, takes ~10GB but is
not growing and does not have many operations. I know that restarting SQL
Server would help (because it helped before). But I want to know why such
problems occur or how to solve it without restarting server?

Thanks for any answer.


.

Relevant Pages

  • Re: SQL Server Dual Processors INSERTS take long time
    ... Just because a server ... all you might try adding a clustered index on the table. ... Andrew J. Kelly SQL MVP ... > for other parts of the app, that need to be done in real time. ...
    (microsoft.public.sqlserver.server)
  • Re: version & instances
    ... SQL 2000 SP3a for Antivirus app ... that same server, to avoid breaking any of those apps. ... MSDE has a limited database size ...
    (microsoft.public.sqlserver.msde)
  • Re: Accessing SQL Server w/ Forms on Intranet
    ... on to the SQL server." ... launched the application from a shared drive really shouldn't affect SQL ... Sam Santiago ... > which Forms process information much better then an ASP app communicating ...
    (microsoft.public.dotnet.distributed_apps)
  • ?? unable to access SQL Server w/ sa account unless user is Administrator on local machine
    ... can tell it to pickup our SQL server using SQL ... app and SQL Server. ... >user belongs to the local Administrators group, ...
    (microsoft.public.sqlserver.security)
  • Re: Invalid Seek Offset continued...
    ... Well shifting to MS SQL will be a very very big step. ... > As Aashish mentioned, network cards drivers may be causing this problem, I ... > also see this error a lot at one customer where the server RAID Controller ... >>> We are deploying a VFP8 app to several beta sites to replace an FPW ...
    (microsoft.public.fox.programmer.exchange)
Loading