SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
SQLTrace

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
SQLTrace
Author Message
Anthony Millard



Joined: 17 Jan 2002
Posts: 1

Post SQLTrace Reply with quote

Hello, we are evaluating the trail version of DBTools 4 and trying to see if it will help us speed us some SQL Statements.
Changing the statement around I am able to effect the values in the Trace window, however, I'm not sure about what some of the values mean.

1.
In particular the 'Gets', I can get this very low (89K to < 120), what does this represent and am I correct in trying to get this as low as possible.

2.
Do you have any other documentation on what you should hope to get the other columns (Memory (K), Physical I/O etc.) to be for a full optermised statement.
I know this is outside the scope of your product, but any links you have that could help would be great.

Thanks in advance
Tony.

Thu Jan 17, 2002 8:36 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Re: SQLTrace Reply with quote

Please see answers for your questions below

: Hello, we are evaluating the trail version of DBTools 4 and trying to see if
: it will help us speed us some SQL Statements.
: Changing the statement around I am able to effect the values in the Trace
: window, however, I'm not sure about what some of the values mean.

: 1.
: In particular the 'Gets', I can get this very low (89K to < 120), what
: does this represent and am I correct in trying to get this as low as
: possible.

Gets is the total number of 'gets' including 'db block gets' and 'consistent gets', which equals number of all logical reads. In general, less reads is better

: 2.
: Do you have any other documentation on what you should hope to get the other
: columns (Memory (K), Physical I/O etc.) to be for a full optermised
: statement.
: I know this is outside the scope of your product, but any links you have that
: could help would be great.

The answer depends on what your tuning goal is. there is no such thing exists as an fully optimized database forever and for all cases. Tuning requires a balancing approach. If your main goal is to reduce memory usage by various SQLs and applications so that more simultaneous sessions can run at the same time without causing memory swapping you would care about reducing memory usage first, but if you want your application to run as fast as possible by reducing the disk system and getting more data from the cache you may come up with a more memory, less disk solution.

: Thanks in advance
: Tony.

Thu Jan 17, 2002 12:47 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.