Re: Curious performance experiment

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: JXStern (JXSternChangeX2R_at_gte.net)
Date: 11/04/04 

Date: Thu, 04 Nov 2004 00:29:32 -0800

On Wed, 3 Nov 2004 19:47:13 -0500, "David Gugick"
<davidg-nospam@imceda.com> wrote:
>What are these"reads"? Are you using STATISTS IO for the information?

Yes, statistics io, and I'm looking at just the logical reads.

> If
>so, how many logical vs physical?

Lots of logical, very few physical.

>You might consider using Profiler to
>see the reads, CPU, and duration.

I've been running the profiler also, but didn't use it on these cases.

> Don't be alarmed that the reads in
>Profiler do not match that of STATISTICS IO. They are reading different
>structures and the SQL Trace API will normally report reads that are not
>tracked by STATISTICS IO.

I'm just comparing runs via statistics io at this point.

Interesting if profiler shows a different pattern, I'll try to post if
I get the chance to try it.

So, nobody is quite going with my theory that the logical reads aren't
purely logical??

J.

Relevant Pages

  • Re: statistical vs deterministic profilers
    ... Lispworks has a statistical profiler, I don't know about Allegro ... statistics on individual functions, ... "sampling profiler", because instead of the profiler being forced by ...
    (comp.lang.lisp)
  • [ANN] yappi v0.2
    ... yappi(Yet Another Python Profiler) v0.2 released. ... helps to assist the programmer finding deadlock situations. ... ability to get statistics without stopping the profiler on the ...
    (comp.lang.python.announce)
  • Code Profiler
    ... A few years ago I used a Profiler on my Delphi code at the time and got fantastic results showing both: ... lines of code that took the longest to execute and b) lines of code that allocated the most unreleased memory. ... I have looked around and am unable to find a good tool to easily achieve these statistics for my C# Winforms application. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Curious performance experiment
    ... > I then added the proper index. ... > clock-time idea of execution (but got the statistics IO from single ... Profiler do not match that of STATISTICS IO. ...
    (microsoft.public.sqlserver.server)
  • Re: Statistical Pattern Recognition
    ... the way pattern recognition works in humans which concludes that it is ... the product of unconscious statistical analysis. ... behind pattern recognition. ... Statistics are not involved in all of the ...
    (talk.origins)