Diagnostics module reports

Diagnostics reports synthesize and summarize data collected by the profiling tools. On the Diagnostics page, under Reports, you can select any report and view detailed information.

You can also edit report properties, such as:

  • Time period
  • For what type of pages to run the report, for example, only frontend pages
  • Set a threshold that sets a benchmark that defines whether task execution is within the expected performance range
  • If you are working in multisite environment, choose whether to run the report for all sites or just for a specific one

NOTE: Properties differ among the different types of reports.

The following table summarizes Diagnostics module reports.

Diagnostics report  Description
HTTP requests 

Provides summarized information about the Http requests that occurred in the Sitefinity web application for all sites. You can filter it to show only selected sites, and only frontend or backend pages. You can also set the alert threshold.

The body of the report lists each request with its request URL, machine name, site name, elapsed time between start and end time, status code, response type, and number of queries. You can expand each Request URL to see the complete request.

Each line offers a View Details link that provides Request Details for that line plus its page compilations, SQL queries, SQL queries list, and graphic representation of Execution details that contrast SQL queries with processing.  There is also tabbed Inner Performance section that lists each method's action in its controller as well as access to performance logs that show the SQL queries executed inside the method. The tabs let you look at only the Widgets, only the Razor compilations, or All.

Use this report to analyze HTTP requests of pages both on the frontend and backend, as well as services called, scripts loaded per page, requests duration, status, and others. 
Background tasks 

Provides summarized information about the background tasks executed in the context of the Sitefinity web application. The report shows the period analyzed and defaults to all sites. You can choose specific sites and then rerun the report.

The body of the report lists each task with its task name, machine name, site name, elapsed time between start and end time, status (succeeded/failed), task type, and number of queries.

Each line offers a View Details link that provides the data for that line plus its related SQL queries and SQL queries list. There is also an Inner Performance section that provides a hierarchical view of the methods performed in the task together with the performance data and the SQL queries executed inside each method.

Use this report to analyze the various types of background tasks executed in your web application, as well as task duration and number of queries per task.  
SQL Queries 

The SQL Queries report lists all the SQL queries on all sites in the specified time period. The performance threshold compared to the duration time will mark the compilation as slow or fast.

You can adjust the alert threshold, and you can specify only selected sites.

For each SQL query, the report lists the complete query, its rated performance, elapsed time between start and end time, batched statements count, the connection ID, number of affected records, the event type, and the provider name.

Use this report to analyze SQL queries performance, such as number and duration of queries. 
Page compilations 

Provides summarized information about the page compilations that occurred in the Sitefinity web application for all sites. You can filter it to show compilations within the specified time frame.

The body of the report lists each page that has been compiled with its page title, page type (Frontend or Backend), site name, last compilation time, compilations count for the page, and total time elapsed for all of the compilations that occurred for this particular page.

Each line offers an All compilations link that provides details for each of the compilations, including the machine name, start and end time of each compilation, and its overall duration. For each separate compilation you can find Details link that opens a page of information about the request that triggered the compilation, along with a list of the SQL queries triggered during the request, and graphic representation that contrasts SQL queries and processing with page compilation.

Each listed compilation line offers a View Details link that provides its details for each of the compilations,

Each line offers a View Details link that provides Request Details for that line plus its page compilations, Razor view compilations, SQL queries, and graphic representation of Execution details that contrasts SQL queries with processing, and processing.  There is also tabbed Inner Performance section that lists each method's action in its controller as well as access to performance logs that show the SQL queries executed inside the method. The tabs let you look at only the Widgets, only the Razor compilations, or All.

NOTE: By default, compilations are logged only for frontend pages. If you want to observe reports for compilations that occurred for backend pages, change the settings that will enable logging of backend compilations as well. For more information about modifying settings, see Administration: Modify Diagnostics module settings.

Razor View compilations 

Provides summarized information about the Razor view compilations that occurred in the Sitefinity web application for all sites. You can filter it to show compilations within the specified time frame.

The body of the report lists each page that has been compiled with its page title, page type (Frontend or Backend), site name, last compilation time, compilations count for the page, and total time elapsed for all of the compilations that occurred for this particular page.

Each line offers an All compilations link that provides details for each of the compilations, including the machine name, start and end time of each compilation, and its overall duration. For each separate compilation you can find Details link that opens a page of information about the request that triggered the compilation, along with a list of the SQL queries triggered during the request, and graphic representation that contrasts SQL queries and processing with page compilation.

Each listed compilation line offers a View Details link that provides its details for each of the compilations,

Each line offers a View Details link that provides Request Details for that line plus its page compilations, Razor view compilations, SQL queries, and graphic representation of Execution details that contrasts SQL queries with processing, and processing.  There is also tabbed Inner Performance section that lists each method's action in its controller as well as access to performance logs that show the SQL queries executed inside the method. The tabs let you look at only the Widgets, only the Razor compilations, or All.

NOTE: By default, compilations are logged only for frontend pages. If you want to observe reports for compilations that occurred for backend pages, change the settings that will enable logging of backend compilations as well. For more information about modifying settings, see Administration: Modify Diagnostics module settings.

Use this report to analyze Razor view compilations of MVC widgets on pages, as well as the number of compilations per widget and compilation duration. 
Site initializations 

Provides summarized information about the Site initializations of the Sitefinity web application.

The body of the report lists each instance's start time and reason.

Use this report to analyze the number of site restarts, as well as when and why site initializations occurred. 
N+1 Query Problems  Provides summarized information about the N+1 query problems of the Sitefinity web application. Shows the time period of the report and some basic problems.  The alert threshold can be adjusted to your preference.

The body of the report lists each query with query content, repetition count, the operation that was initiated, the operation type, and the provider name.

For details, see Detect and Solve N+1 Problems
Custom 

The built-in custom reports are the following:

    • RunBigResultSetAnalysis
      This is a report of all operations that generated significant amount of records.
      For more information, see Telerik Data Access documentation » Detect Too Many Records Fetched Problems.
    • RunLongQueryAnalysis
      This is a report of all operations that took significant amount of time to run.
      For more information, see Telerik Data Access documentation » Detect Long Running Queries.

You can also add a custom report according to your requirements. For more information, see For developers: Add your custom report.

Was this article helpful?