Kentico CMS 7.0 Context Help

SQL queries

SQL queries

Previous topic Next topic Mail us feedback on this topic!  

SQL queries

Previous topic Next topic JavaScript is required for the print function Mail us feedback on this topic!  

The Debug -> SQL queries tab is displayed only when SQL query debugging is enabled. This can be achieved either by configuring certain settings in Site Manager -> Settings -> System -> Debug, or by adding specific keys to the appSettings section of your project's web.config file. Both options are described in this context help topic.


On this tab, you can see a log of SQL queries called on loading of particular pages. For each record, there is row with a URL of the loaded page followed by its time of display. Below it, you can find a table listing all SQL queries executed when loading the page.


For each query, there are two lines in the table. The first line contains the exact text of the query, while the second line contains the number of loaded rows, columns in each row and the size of the loaded data. The Context column shows where the query was called from. The last column of the table displays the exact duration of query execution. The last line of the table displays the overall page loading time.


Enabling the Show complete context check-box displays complete context (not only the topmost item) in the Context column. Clicking the Clear SQL log button clears all records in this debug log.


For more information about debugging in Kentico CMS, please refer to Developer's Guide -> Development -> Debugging and system information.