The Administration tab gives you easy access to manage SQL BI Manager options such as users, SQL BI Service instances, alert emails, and alert's threshold configuration. Click image to view full size.
In the Administration tab you can:
In SQL BI Manager you can set alert thresholds as to keep informed of only relevant information about your SQL Server BI environment. Click image to view full size.
You can access this option at the right side of the Administration view. To edit an alert threshold, click the pencil icon and the Threshold Configuration window displays.
In the Threshold Configuration window, you can specify thresholds for Informational, Warning, and Critical alerts. Once you have configured your alert thresholds you can verify this information in the Administration's roll up view.
SQL BI Manager allows you to enable or disable the generation of alerts and collection of some performance metrics. You can disable alerts when not necessary, to save system resources, or perform maintenance.
You can access this option at the right side of the Administration view. Click on the check box under the Enable/Disable column.
In the Administration view you can add SQL BI Service Instances for monitoring with the ADD BI SERVICE option at the top left of the view.
For additional information, refer to Adding Business Intelligence Services for monitoring.
In the Administration view, click CONFIGURE SMTP and the Email Settings dialog box displays with three main sections:
Enter the email address that SQL BI Manager will use as the sender of the emails notifications.
You must specify a reply-to email address to receive replies from emails.
Enter the text that you want to appear in the footer of notifications.
In order to send email notifications, you must specify the settings of an email server you want to use. You need to provide the following information:
Enter the name or Internet Protocol (IP) address of your SMTP mail server.
Enter the IP port that the SMTP mail server uses. The default SMTP port is 25.
Select this check box to use an SSL encrypted connection to connect to the email server.
Select this check box if your SMTP server requires authentication, specify then a valid user name and password to access the email server.
You can use this section to test your email settings. For this purpose, enter the Recipient of the test email and click SEND TEST EMAIL. SQL BI Manager sends a test email to the recipient you specify. You can verify this test email in the respective recipient account.
After you configure your email settings, you can subscribe to alerts. For more information on how to subscribe to alerts, see Configuring email alerts (below).
In the Administration view, click Configure Email Alerts and a new dialog box displays.
In the Configure Email Alerts dialog box, you can subscribe to receive alerts for individual SQL servers or all.
Steps to subscribe to alerts
In the Administration view, click ADD USER and a new dialog box displays.
To add users and give them access to SQL BI Manager follow these steps:
You should provide the new user with the following URL: http://<ServerName>:9278 (where ServerName is the name of the machine on which you installed the SQL BI Manager services). |
| IDERA Website | Products | Purchase | Support | Community | About Us | Resources | Legal |
|---|