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.
- Chrome and Edge are the recommended browsers for using SQL Sentry Portal.
- There may be minor differences in appearance between the SentryOne Monitor product and the SQL Sentry Portal feature for SQL Sentry. These will be noted in the documentation or related to the released version. Hovering over an image in the article will display the version that was used for the image.
Are all target types supported with SQL Sentry Portal?
SQL Sentry Portal currently supports the following target types:
- SQL Server (including Amazon RDS)
- Azure SQL Database
How do I install SQL Sentry Portal?
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.
How do I open SQL Sentry Portal?
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.
You may have a different port to use with your host name. This information can be viewed or changed with the SQL Sentry Portal Configuration Utility. See the SQL Sentry Portal Configuration article for details.
2. Enter your authentication credentials to access the SQL Sentry Portal. Use your DOMAIN\Username if needed.
Note: Accounts logging into the SQL Sentry Portal must have access to the Windows Server hosting SQL Sentry Portal.
3. The browser opens the SQL Sentry Portal. See the Using Monitor article for help navigating SQL Sentry Portal's features.
Which features are available in Portal?
In general, the SQL Sentry Portal offers the same features available in SentryOne Monitor. It 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.
Note: Remember, you still have access to all the additional SQL Sentry features through the SQL Sentry client.
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.
Additional Information: For more information about Health Views in the SQL Sentry Portal, see the Health Views article.
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.
Additional Information: For more information about Top SQL in the SQL Sentry Portal, see the Top SQL article.
The Alerts view displays a list of all the conditions that have evaluated to True.
Additional Information: For more information about Alerts in the SQL Sentry Portal, see the Alerts article.
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.
Additional Information: For more information about Blocking in the SQL Sentry Portal, see the Blocking article.
The Deadlocks view provides details about deadlocks within your monitored environment. Use it to identify and fix deadlock issues on your monitored servers.
Additional Information: For more information about Deadlocks in the SQL Sentry Portal, see the Deadlocks article.
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.
Additional Information: For more information about TempDB in the SQL Sentry Portal, see the TempDB article.
The Dashboard view displays the performance charts for monitored targets.
Additional Information: See the Dashboards article.
Additional Information: For more information about Dashboards in the SQL Sentry Portal, see the Dashboards article.
SQL Sentry Portal offers the ability to create custom dashboards with configurable charts. With custom dashboards, 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.
Additional Information: For more information about Custom Dashboards in the SQL Sentry Portal, see the Custom Dashboards article.
Additional Information: The SQL Sentry Portal feature page contains a feature overview.