Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The Administration tab gives you easy access to manage SQL BI Manager options such as SQL BI Service instances, Email alerts, and alerts threshold configuration.

Image RemovedImage Added

In the Administration tab you can:

...

To edit an alert threshold, start by selecting the BI instance and the type of alert (Server, SSAS, SSRS, SSIS) from the drop-downs above the list. Then, you can access the Threshold Configuration window by clicking the pencil icon  at the right end of the alerts list.

Image RemovedImage Added

In the Threshold Configuration window, you can specify thresholds for InformationalWarning, and Critical alerts. Once you have configured your alert thresholds you can verify this information in the Administration roll up view.

...

Use the ADD BI SERVICE option to add SQL BI Service Instances for monitoring. For additional information, refer to Adding Business Intelligence Services for monitoring.

 Configure SMTP settings for alerting

Use the CONFIGURE SMTP option to configure Email server settings to be able to send notifications over Email. 

Image RemovedImage Added

Configure the following settings:

...

Use the CONFIGURE EMAIL ALERTS option to subscribe specific users to receive Email alerts on specific events occurring on specific monitored BI servers. SQL BI Manager sends an Email when the severity changes to Critical or Warning (regardless of the originating severity).

Image RemovedImage Added

Follow these steps to Configure Email Alerts:

...

Use the MANAGE MONITORED SERVICES option to have a general overview of all monitored BI instances. This view displays information such as the Component Type, its Status, the Service and Host Name, the Authentication User Name, the Alert Refresh Time, and the Monitoring status (true or false). You can also Export this information to a PDF, XLS, or XML file.

Image RemovedImage Added

You can also perform actions to either single or several BI instances.

...

Additionally, by clicking the gear icon you can also Change Refresh Interval, as well as to Disable Monitoring temporarily (during maintenance operations) and Edit Properties.

Image AddedImage Removed

Perform bulk actions on several BI instances

...

Additionally, you can click the gear icon to access the option to temporarily Disable Monitoring (during maintenance operations), as well as to Edit Credentials.

Image AddedImage Removed

 

SQL Business Intelligence Manager identifies issues within the SQL BI environment to help optimize BI service performance. Learn more >>

...