Re: Any thoughts?

Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl> wrote in message news:<lgl2905b70gv9bh695ot1vj6k63vnra7iu_at_4ax.com>...
> On 29 Apr 2004 04:14:53 -0700, orclwzrd_at_yahoo.com (john) wrote:
>
> >Anybody have any insight into the difference between the statistics
> >'session logical reads' and 'consistent gets' + 'db block gets' at
> >both the session and system level. Usually the logical reads is
> >determined by consistent gets + db block gets, session logical reads
> >does not always equal this value. I'm just wondering why and if
> >there's any reason to use one over the other. I've seen it both ways
> >but not really any explanation. Seems that both should be correct.
> >
> >Of course, if I've missed the answer already posted sometime before,
> >that would be nice to know too.
> >
> >Thanks for any feedback
> >
> >John
>
> Please ask your friends at Tusc
> They are theself-proclaimed gurus, aren't they?

Sybrand, I'm not looking for a fight here, I'm seeking information. If you have something to share, please do. We all have to work for somebody. I'm a senior DBA just like you. I'm seeing some strange results from my performance monitoring and I'm trying to track done the issue. The reason you've seen this twice is that I got nothing but flames the first time. I don't need flames, I'd like to discuss the technical issue at hand. I've always managed to get good answers here before I took the job and I hope to continue to get good answers here.

John Received on Thu Apr 29 2004 - 20:10:23 CDT