Monitor queries to SQL
It is often necessary to see the queries that are performed by the service data to the repository. Not to connect third-party applications (like SQL profiler), you can use the monitor task Flexberry ASP.NET.
monitor Connection task
To monitor a data warehouse query can
- Write private task monitor
- Attach existing
Read more about the second option:
To connect the monitor task ASPContextBusinessTaskMonitor.ASPContextBusinessTaskMon should:
- To add to the configuration file Web.Config line
<br><appSettings>
<br><add key="BusinessTaskMonitorType" value="ICSSoft.STORMNET.Web.Tools.WebBusinessTaskMon, ICSSoft.STORMNET.Web.Tools" />
<br></appSettings>
<br>
Then when loading any page will appear ErrorBox containing all queries that were executed when loading the page. If requests were few, they will be placed on different “levels”.
For example, when loading the start page 2 request:
When you load list forms will be significantly more requests:
