SQL Sentry Web Portal
Easily access the information you need to speed database performance
With 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.
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 and view query wait stats
- Easily share monitoring dashboards and alerts with others in your organization
Track your database environment health
Enhanced Environment Health Overview in SQL Sentry Portal provides easy insights to servers experiencing problems in your environment.
Using a 100-point health score, users can see the current health status, as well as the previous score history to understand which performance issues need to be addressed.
The alerts grid provides details on the alert and allows users to assign alerts, leave notes, and close events. You can view alerts by severity, tag to quickly identify conditions slowing database performance, and drill down into individual alerts for more details.
Monitor real-time and historical database performance
View important performance metrics for your monitored targets, including the following:
- 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 most important metrics.
Identify SQL Server query tuning opportunities
Quickly spot queries affecting SQL Server performance with the Top SQL view. Analyze high-impact SQL Server queries, view query plan diagrams, wait stats including trace event waits, 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.
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 and 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
Get More on SQL Sentry Web Portal
What is SQL Sentry Portal?
SQL Sentry® Portal is a web interface designed to show you real-time and historical performance data for your monitored SQL Server, Azure SQL Database, and Windows targets in your web browser.
Can I use SQL Sentry Portal to 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 leading 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 the deadlock
Where is my SQL Sentry monitoring data stored?
SQL Sentry Portal connects to your existing SQL Sentry database, which remains in the location you designated when you configured your setup.
How can I gain insight into tempdb activity and utilization?
Learn More
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.
What types of targets does SQL Sentry Portal support?
SQL Sentry Portal currently supports SQL Server, Azure SQL Database, Windows targets, and VMware targets.
How do I download and install SQL Sentry Portal?
SQL Sentry Portal is installed as a self-hosted HTTP Windows service and can be reverse proxied through IIS (optional). The SQL Sentry Portal comes packaged with the SQL Sentry installer. Download the latest build of SQL Sentry here. Then, follow the SQL Sentry Portal installation instructions.
How do I access SQL Sentry Portal?
Once your SQL Sentry installation has been configured and you’ve installed SQL Sentry Portal, you can use Google Chrome or Microsoft Edge to access the SQL Sentry Portal. See SQL Sentry Portal installation instructions for more details.
- What is SQL Sentry Portal?
- Can I use SQL Sentry Portal to find and diagnose SQL Server deadlocks?
- Where is my SQL Sentry monitoring data stored?
- How can I gain insight into tempdb activity and utilization?
- What types of targets does SQL Sentry Portal support?
- How do I download and install SQL Sentry Portal?
- How do I access SQL Sentry Portal?
What is SQL Sentry Portal?
SQL Sentry® Portal is a web interface designed to show you real-time and historical performance data for your monitored SQL Server, Azure SQL Database, and Windows targets in your web browser.
Get started with SQL Sentry Portal
SolarWinds SQL Sentry
Fast root cause analysis
Visibility across the data estate
Deep, actionable performance metrics with easy deep-dive capabilities
