The MSSQL Report Service Layer

Use the tests mapped to this layer to measure user experience with the report server, in terms of:

  • The execution time of the reports per user; this points you to slow reports per user and the reason for the slowness;
  • The availability and responsiveness of the report server database

Additionally, the layer also sheds light on errors that occur during HTTP request processing, monitors the usage of the session cache, captures failed login attempts via RSWindows authentication, and also alerts you to frequent request failures and rejections.

Figure 1 : The tests mapped to the MSSQL Report Service layer