SolarWinds SQL Sentry Portal

Monitor your SQL Server environment from your web browser



 

 

Easily access the information you need to speed database performance

 

Want a convenient way to access your performance data?

With the SQL Sentry Portal, you can view detailed, actionable information on the performance of your monitored SQL Server, Azure SQL Database, and Windows targets from your web browser.

The SQL Sentry Portal connects to your SQL Sentry database and displays important performance information in an easy-to-use web interface.

  • Reference the health score for your database environment

  • View alerts and important performance metrics

  • Create custom dashboards

  • Analyze SQL Server queries

  • Easily share monitoring dashboards and alerts with others in your organization

SQL Sentry Portal FAQ

Proactively monitor SQL Server performance with the SQL Sentry Portal

Track your database environment health

See the health status for all your monitored targets and the most recent alerts in the Health view. You can view alerts by severity and tag to quickly identify conditions that are slowing database performance, and drill down into individual alerts for more details.

sql-sentry-portal-health-overview
sql-sentry-portal-dashboard-view

Monitor real-time and historical database performance

View important performance metrics for your monitored targets, including:

  • SQL Server activity, waits, I/O, and memory

  • Windows OS network utilization, CPU usage, I/O, and system memory

You can see real-time data or data for a specific time period using the default Dashboard view or by creating custom charts and dashboards to display the metrics that are most important to you.

Identify SQL Server query tuning opportunities

Quickly spot queries that are affecting SQL Server performance with the Top SQL view. Analyze high-impact SQL Server queries, view query plan diagrams, and drill down into the query history for details about the execution plan, such as query duration, CPU consumption, and number of reads and writes performed.

sql-sentry-portal-top-sql
sql-sentry-portal-blocking

Analyze SQL Server blocking

Quickly identify the root cause of SQL Server blocking in the Blocking view. With an intuitive graphical representation of a blocking chain, you can easily analyze blocking details and view the relationships between blocking and blocked sessions.

  • View blocking by application, wait resource, or wait type

  • Expand a blocking chain to view blocked sessions to understand the full impact of a block

  • Switch between versions of a blocking chain to see if blocked SPIDs were added or removed

  • View query text with syntax highlighting for any session within a blocking chain

Find and diagnose SQL Server deadlocks

Efficiently troubleshoot deadlocks that have occurred on your monitored targets in the Deadlocks view. The simple, intuitive deadlocks diagram makes it easy to analyze the events that led to the SQL Server deadlock.

  • Select a node in the deadlock diagram to view detailed information about the process or resource

  • View the raw XML file for a selected deadlock

  • Drag and drop saved deadlock files into the Deadlock Diagram pane to see a diagram and additional information about that deadlock

sql-sentry-portal-deadlocks
sql-sentry-portal-tempdb

Gain insight into tempdb activity and utilization

With the TempDB view, you get enhanced visibility into the health and performance of tempdb. Easily analyze file space usage across your tempdb data files, and tempdb objects, activity, and session usage for SQL Server and Azure SQL Database.

SQL Sentry Portal FAQ

What is the SQL Sentry Portal?

The SQL Sentry Portal is a web interface that shows you real-time and historical performance data for your monitored SQL Server, Azure SQL Database, and Windows targets in your web browser.

 

Where is my SentryOne monitoring data stored?

The SQL Sentry Portal connects to your existing SentryOne database, which remains in the location you designated when you configured your setup.

 

What types of targets does the SQL Sentry Portal support?

The SQL Sentry Portal currently supports SQL Server, Azure SQL Database, Windows targets, and VMware targets.

 

Where can the SQL Sentry Portal be installed?

The SQL Sentry Portal is installed as a self-hosted HTTP Windows service and can be reverse proxied through IIS (optional).

 

How do I download and install the SQL Sentry Portal?

The SQL Sentry Portal comes packaged with the SentryOne Unified Installer. Download the latest build of SentryOne from my.sentryone.com. Then, follow the SQL Sentry Portal installation instructions.

 

How do I access the SQL Sentry Portal?

Once your SentryOne installation has been configured and you’ve installed the SQL Sentry Portal, you can use Chrome or Edge to access the SQL Sentry Portal. See the SQL Sentry Portal installation instructions for more details.

 

What if I need help with the SQL Sentry Portal?

You can send feedback and questions to the our Support team by visiting our Support Community.