Getting Started with SQL Sentry Portal

Introduction

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 shares the same UI experience as the cloud-based SentryOne Monitor product. See the Using SQL Sentry Portal article to familiarize yourself with the overall layout.

Note: 

  • 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
  • Windows

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. 

Note:  In this example, the SQL Sentry Portal is bound to localhost, http://localhost/. The URL to open SQL Sentry Portal includes the port as well: http://localhost:9991/

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.

SQL Sentry Portal enter windows security information

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.

SQL Sentry Portal Dashboard

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.

Health Views

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.

SQL Sentry Portal Health View All Servers

Additional Information: For more information about Health Views in the SQL Sentry Portal, see the Health Views article.

Top SQL

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.

SQL Sentry Portal Top SQL Waits view

Additional Information: For more information about Top SQL in the SQL Sentry Portal, see the Top SQL article.

Alerts

The Alerts view displays a list of all the conditions that have evaluated to True.

SentryOne Monitor Alerts Log

Additional Information: For more information about Alerts in the SQL Sentry Portal, see the Alerts article.

Blocking

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.

SQL Sentry Portal Blocking: Hover for More Details

Additional Information: For more information about Blocking in the SQL Sentry Portal, see the Blocking article.

Deadlocks

The Deadlocks view provides details about deadlocks within your monitored environment. Use it to identify and fix deadlock issues on your monitored servers.

SQL Sentry Portal Deadlock Diagram

Additional Information: For more information about Deadlocks in the SQL Sentry Portal, see the Deadlocks article.

TempDB

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.

SQL Sentry Portal TempDB view

Additional Information: For more information about TempDB in the SQL Sentry Portal, see the TempDB article.

Dashboards

The Dashboard view displays the performance charts for monitored targets.

Additional Information: See the Dashboards article.

SQL Sentry Portal Dashboard view select date range

Additional Information: For more information about Dashboards in the SQL Sentry Portal, see the Dashboards article.

Custom Dashboards

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.