Odd One

18 Aug 2006 10:59 PM

Chris

sql2000 sp4 std ed

I have a sp call that an asp webpage calls over oledb/ado - database trace
running - duration for completed event takes 15+ seconds.

Run exact same sp call in QA - less than 1 second response. When running in
QA I issue dbcc dropcleanbuffers to make sure it is not the cache that the
data is coming from...

I don't get it. My profiler trace is picking up 15 sec, QA < 1

Any ideas

tia
chris

18 Aug 2006 11:11 PM

Chris Lim

Chris wrote:

> Run exact same sp call in QA - less than 1 second response. When running in
> QA I issue dbcc dropcleanbuffers to make sure it is not the cache that the
> data is coming from...

Is the query plan the same? Is the process being blocked by others?

18 Aug 2006 11:21 PM

Chris

same plan - no blocking. That's what I thought too, has to be blocking ,but
nothing. User runs - 15 seconds, I run - 1 second. We do the same call one
right after the other, before I run mine I clear cache. Makes no sense.

Show quote

"Chris Lim" wrote:

> Chris wrote:
> > Run exact same sp call in QA - less than 1 second response. When running in
> > QA I issue dbcc dropcleanbuffers to make sure it is not the cache that the
> > data is coming from...
>
> Is the query plan the same? Is the process being blocked by others?
>
>

19 Aug 2006 1:44 AM

Dan Guzman

The duration also includes the time it takes the application retrieve the
results. Is the resultset large? Perhaps the app is doing a lot of work
rendering the results.

--
Hope this helps.

Dan Guzman
SQL Server MVP

Show quote

"Chris" <Ch***@discussions.microsoft.com> wrote in message
news:F07CE651-984E-4C3E-998F-B3A75434B931@microsoft.com...
>
> sql2000 sp4 std ed
>
> I have a sp call that an asp webpage calls over oledb/ado - database trace
> running - duration for completed event takes 15+ seconds.
>
> Run exact same sp call in QA - less than 1 second response. When running
> in
> QA I issue dbcc dropcleanbuffers to make sure it is not the cache that the
> data is coming from...
>
> I don't get it. My profiler trace is picking up 15 sec, QA < 1
>
> Any ideas
>
> tia
> chris