You can find the details of report execution and SQL in the SQL view. Starting from version 9.2.1 you can see the below information.
Total Duration in Query Engine - This gives you the total time the system took in the data query phase. Its is a sum of all the below four.
SQL Generation - The first step is to generate an SQL that needs to be run against the WH. This show the time taken by the engine to generate the SQL.
SQL Execution - This is the time the SQL query took to run against the WH.
Total Data Fetch Duration - Once the SQL is run, the data needs to be send back to the Iserver. This show the time it takes for the data to reach Iserver from the WH. If you see huge delay here, check your network
Other Processing Duration in Query Engine - The results that come from the WH needs to be loaded into the Iserver memory, and in a format that Analytical engine can process if needed. This also includes the time needed for Analytical Engine calculations.
Total Duration in Query Engine - This gives you the total time the system took in the data query phase. Its is a sum of all the below four.
SQL Generation - The first step is to generate an SQL that needs to be run against the WH. This show the time taken by the engine to generate the SQL.
SQL Execution - This is the time the SQL query took to run against the WH.
Total Data Fetch Duration - Once the SQL is run, the data needs to be send back to the Iserver. This show the time it takes for the data to reach Iserver from the WH. If you see huge delay here, check your network
Other Processing Duration in Query Engine - The results that come from the WH needs to be loaded into the Iserver memory, and in a format that Analytical engine can process if needed. This also includes the time needed for Analytical Engine calculations.
Thanks for the post. But one question Anand. Shall we log this information using SDK. We have some Interfaces in MicroStrategy "com.microstrategy.web.objects.admin.monitors.QueryPass". By this interface we can get duration of query, No of rows processed, start time, end time, pass table count etc. I don't know how to use this as a Java program. Can you help me on this. Please
ReplyDeleteThanks for your information. very good article.
ReplyDeleteMicro Strategy Training
Online Micro Strategy Training