Chat now with support
Chat with Support

Foglight for SQL Server (Cartridge) 5.7.5.30 - User Guide

Managing SQL Server Database Systems Introduction to this Guide Using Foglight for SQL Server Monitoring Business Intelligence Services Administering Foglight for SQL Server Glossary Reference

Terminology

Standard score - is used to compare the duration of a specific execution in compare to the normal execution.
Standard score is calculated as the current execution minus the average while the result is divided by the standard deviation. This score gives the result while considering the tendency of the execution duration fluctuation.
Step - is used to describe tasks, data flows and other package components. Steps are used to discover which part of the package has failed or exceeded their normal duration.

Monitoring Reporting Services

Configuring Reporting Services Monitoring
 
* 
IMPORTANT: A new agent can only be created when the SQL Server instance is already monitored.
To configure RS monitoring:
1
Click Monitor.
2
Select the instance from the list of monitored instances.
3
Select whether you want to generate the name automatically. The default name of a Reporting Service agent is <Instance name>_<Report_DB>.
4
To enable monitoring the Reporting Service, provide:
a
the OS relevant credentials under Reporting Service Account, which is the name of the underlined host on which the service runs.
b
The username and password allowed to view the service activity and performance counters. Stored credentials can be used instead of entering the username and password manually.
5
Click Monitor.

Configuring Reporting Services Monitoring

 
* 
IMPORTANT: A new agent can only be created when the SQL Server instance is already monitored.
To configure RS monitoring:
1
Click Monitor.
2
Select the instance from the list of monitored instances.
3
Select whether you want to generate the name automatically. The default name of a Reporting Service agent is <Instance name>_<Report_DB>.
4
To enable monitoring the Reporting Service, provide:
a
the OS relevant credentials under Reporting Service Account, which is the name of the underlined host on which the service runs.
b
The username and password allowed to view the service activity and performance counters. Stored credentials can be used instead of entering the username and password manually.
5
Click Monitor.

Monitoring Reports using the Reporting Services Panel

The metadata of the reporting services is stored in the SQL Server instance. Foglight for SQL Server offers the capability of analyzing the metadata and produces detailed reports of the user's activity.
This panel contains the following components:
•
Reporting Services Databases — allows selecting which metadata database is to be used.
•
Reporting Services Configuration — allows reviewing the configuration of the metadata databases selected in the Reporting Services Databases section. The settings displayed in this section are read-only and cannot be modified.
•
Distribution of Reported Runs — a pie chart displaying the distribution of the report runs between successful and failed runs.
•
Top Users — displays the users who generated the highest number of reports.
•
The Reporting Services Execution Summary table — displays a row for each report, and includes the following columns:
•
Path — the path where the report resides.
•
Report Name — the name of the report.
•
Status — the report’s status, that is: the result of the report’s running; either Failed or Success.
•
Total Time Retrieving Data — the total time required for collecting the report’s data.
•
Total Time Processing — the total time required for processing the data retrieved for the report.
•
Total Time Rendering — the total time required for rendering the data for UI display.
•
Total No. of Rows — the total number of rows displayed in the report.
•
No. of Executions — the total number of times the report was executed.
•
Explore — allows reviewing in-depth data about the report.
Reporting Services Execution
The Reporting Services Executions pop-up displays a different row for each run, each row showing the following columns:
•
User Name — the name of the user who ran the report
•
Start Time — the time that the report run’s started
•
End Time — the time that the report run’s ended
•
Data Retrieval Time — the total time required for collecting the report’s data
•
Processing Time — the total time required for processing the data retrieved for the report
•
Rendering Time — the total time required for rendering the data for UI display
•
Status — the report’s status, that is: the result of the report’s running; either Failed or Success
•
No. of Rows — the number of rows displayed in the report
•
Format — the report’s format
•
Parameters — displays the parameters that were included during the report’s run
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating