Overview: Performance Diagnostics module

Sitefinity CMS 7.2 comes with a build-in Diagnostics module. The Sitefinity CMS Diagnostics module is designed to support a collection of tools for detecting possible performance issues with your application. The module supports the DataAccessProfiler tool, which has the ability to profile DataAccess queries.

The module collects diagnostics information which is stored in an additional database. The operations that are logged for analysis are the frontend requests and the scheduled tasks and their respective database queries. You can use this diagnostics information to identify the reasons for slow page load or issues with HTTP requests, scheduled tasks, etc.

PREREQUISITES: To install and use the Diagnostics module, you must comply with the following:

• Microsoft SQL Server 2008 R2 or a newer version. 
  
• The user that you use to work with the module must have administrative permissions, otherwise, you cannot use the module and database profiling.
• The user that you use to connect to the database must have create database permissions on the database server in order to create separate database for persisting the tracing results. 
  If the user installing the Diagnostics module does not have database permissions, you can do one of the following:
  • The Administrator can create the database for the tracing information in advance and also create the connection string to the database.
  • The user can use the project's default database to persist tracing information. You must also change the Diagnostics module default database connection string with the project's default database connection string.
    We do not recommend this scenario, since the default database will contain trace information and can get very large.
  • For more information, see Administration: Diagnostics module settings » Database connection string for the Diagnostics module.