-
Hello, in my Client Monitor result i have some lines with column SQL Status filled with "Cached". What does this mean? Some "cached" lines have an elapsed time > 15ms. Is there a configuration parameter to optimize this? Perhaps DBMS Cache (actual it is 100.000 KB)! Thanks for...
-
Hi DynamicUsers, I work with the client monitor on a dynamics NAV 5.1 sql database. The result list shows me some lines on which elapsed time > 0. Can you tell me your expierience with the elapsed time ? Should i check every "Elapsed Time Line" which is more than 10|20|30|40ms ? In my list...
-
The Function <<pubPriceListDescription>> is in a CU, you will see the code below: pubPriceListDescription CLEAR(defvsDescription); WITH lrPricelist DO BEGIN IF GET(defsCode) THEN BEGIN lsDescription := Description; CLEAR(lrCodValTransl); lrCodValTransl."Table ID" := DATABASE::Pricelist;...
-
Hi, i have one server with two databases installed on. One Dynamics 5.1 SQL and one Dynamics 5.1 Native. I run the Client Monitor to make Performance Checks. In the result list on the SQL Server i have 9 times the line with the function name COUNT RANGE with Elapsed Time > 0. In the same Check on...
-
Hello, in my Client Monitor result i have some lines with column SQL Status filled with "Cached". What does this mean? Some "cached" lines have an elapsed time > 15ms. Is there a configuration parameter to optimize this? Perhaps DBMS Cache (actual it is 100.000 KB)! Thanks for...
-
Hi DynamicUsers, I work with the client monitor on a dynamics NAV 5.1 sql database. The result list shows me some lines on which elapsed time > 0. Can you tell me your expierience with the elapsed time ? Should i check every "Elapsed Time Line" which is more than 10|20|30|40ms ? In my list...
-
The Function <<pubPriceListDescription>> is in a CU, you will see the code below: pubPriceListDescription CLEAR(defvsDescription); WITH lrPricelist DO BEGIN IF GET(defsCode) THEN BEGIN lsDescription := Description; CLEAR(lrCodValTransl); lrCodValTransl."Table ID" := DATABASE::Pricelist;...
-
Hi, i have one server with two databases installed on. One Dynamics 5.1 SQL and one Dynamics 5.1 Native. I run the Client Monitor to make Performance Checks. In the result list on the SQL Server i have 9 times the line with the function name COUNT RANGE with Elapsed Time > 0. In the same Check on...