What is SQL Sentry Portal?
SQL Sentry Portal is a browser-based option for accessing your SQL Sentry environment data that uses your existing SQL Sentry database. It replaces the previous mobile applications and Cloud Sync options.
SQL Sentry Portal currently supports the following target types:
- SQL Server (including Amazon RDS)
- Azure SQL Database
See the SQL Sentry Portal Configuration article. SQL Sentry Portal may be installed through the classic SQL Sentry Setup Wizard or through EPI commands, as long as the method you choose matches your existing SQL Sentry installation.
Once you've installed SQL Sentry Portal, you can open it by completing the following steps:
1. Enter your domain for the SQL Sentry Portal in your preferred browser.
2. Enter your authentication credentials to access the SQL Sentry Portal. Use your DOMAIN\Username if needed.
3. The browser opens SQL Sentry Portal. See the Using SQL Sentry Portal article for help navigating SQL Sentry Portal's features.
4. Select the permissions button to open the Users and Groups page.
5. Select the applicable permissions that you want to assign to your user. Repeat this step for all of your SQL Sentry Portal users.
Success: The Role assigned successfully prompt displays when you've made changes to the selected user role.
Which features are available in Portal?
The SQL Sentry Portal does not have feature parity with the SQL Sentry client for SQL Sentry. By offering a simpler view, it creates an option that can be more attractive for different stakeholders who don't need the depth of information and functionality offered in the client, or as more of an everyday view for DBAs who may only need to open the client for more advanced troubleshooting.
The Health view is the default view when opening the SQL Sentry Portal. This screen displays wedgets for Alerts by Severity and Alerts by Tag on the default Overview for all servers. You can drill into targets for an individual view.
The Performance tab displays performance charts for the monitored target type. For example, the Performance tab for a SQL Server target displays charts such as Network, CPU, System Memory, SQL Server Activity, SQL Server Waits, SQL Server Memory, Disk, and Database I/O.
The Storage view provides details about the disk space and disk activity in your monitored environment. The Storage is only available on SQL Sentry Portal and acts as a combined view of the Disk Activity and Disk Space tabs in the SQL Sentry Client.
The Top SQL view displays a unified picture of collected SQL statements. It's designed to help you quickly identify queries, applications, logins, and more that are causing the most waits, using the most resources, taking the most time, and putting the most load on your SQL Server.
The AlertsLog displays a list of all the conditions that have evaluated to True.
The Blocking view maps the relationships between all blocking and blocked sessions (SPIDs) in a blocking chain, allowing you to pinpoint the cause and fix the blocking issue.
The Deadlocks view provides details about deadlocks within your monitored environment. Use it to identify and fix deadlock issues on your monitored servers.
The TempDB view displays a wealth of information about what is using your tempdb database and how effectively it is being used. This feature is specific to SQL Sentry Portal and is not available in the SQL Sentry client.
The Dashboard view displays the performance charts for monitored targets.
SQL Sentry Portal offers the ability to create dashboards with configurable custom charts. With custom charts, you can include the performance metric widgets that you want, and you can have custom charts for different targets on the same dashboard. This feature is specific to SQL Sentry Portal and is not available in the SQL Sentry client.