Hello,
ca you please explain me what does this fields exactly mean in client diagnostic.
Also, the networkTransporttime increases each time we call one specific function … in the begining it is very low and after it becomes huge (only for this function). just to be sure the NetworkTransportTime is the time of communication between the client and the serverapp ?
Thanks
As far as I am aware:
QueriesExecuted - the total number of SQL Queries the process executed.
CacheHits - the number of those which were in the AppServer’s cache, and didn’t require querying the SQL Server.
SQL Hits - the number of queries not in cache which the appserver had to execute on the SQL Server.
(CacheHits + SQL Hits = Queries Executed)
Query Type Count. The number of distinct Queries executed (i.e. if the BO executed Select * from ERP.PartTran twice and it never got cached, you would have 0 cachehits, 2 SQL Hits, 2 Queries Executed, but only 1 QueryType).
And on NetworkTransport time - not sure it really is what it claims to be. I think it is actually (Execution Time) - (Server Execution Time).
Looking at raw log data I can see entries for one call where it shows for the client side of life.
And on the server trace element <Op Utc = “…” act = “…” … dur=“4.1325” … >
.
As you can see there is no NetworkTransportTime. However, my PDT analysis gives Execution Time 46ms, Sever Execution 4ms and Network Transport Time 42ms.
Of course this does beg the question, what is round trip and other?
As for the function getting slower and slower… Initial thoughts are something not being disposed correctly in the function. I presume the packet size stays the same each time the function is called (the amount of data being sent back to the client).