We are experiencing a very strange performance problem. Stored Procs that
are run through ADO are taking 30 seconds to run, while they run in less
than a second when run from query analyzer. This behavior was confirmed
using Profiler. The duration was 30 seconds from ADO, yet I can run the
same stored proc in less than a second from QA or EM.
This started this afternoon and was observed on several different servers.
SQL Server >> Strange Performance Problem
Are you using the exact same parameters? This can often happen due to
"parameter sniffing" and / or a bad query plan stored in the cache, or out
of date statistics.
> We are experiencing a very strange performance problem. Stored Procs that
> are run through ADO are taking 30 seconds to run, while they run in less
> than a second when run from query analyzer. This behavior was confirmed
> using Profiler. The duration was 30 seconds from ADO, yet I can run the
> same stored proc in less than a second from QA or EM.
>
> This started this afternoon and was observed on several different servers.
>
> Any ideas?
>
>
>
SQL Server >> Strange Performance Problem
Use SQL Profiler to trace the actual execution plan that is used for the
stored procedure, from both ADO and QA. Might reveal something.
> We are experiencing a very strange performance problem. Stored Procs that
> are run through ADO are taking 30 seconds to run, while they run in less
> than a second when run from query analyzer. This behavior was confirmed
> using Profiler. The duration was 30 seconds from ADO, yet I can run the
> same stored proc in less than a second from QA or EM.
>
> This started this afternoon and was observed on several different servers.
>
> Any ideas?
>
>
>