Select Page

SolarWinds SQL Sentry (SentryOne)

Complete management across your Microsoft Database Environment

SolarWinds® SQL Sentry is a powerful database performance monitoring solution designed to help you find and fix performance problems within SQL Server, Microsoft® Azure SQL Database and Microsoft Data Platform. SQL Sentry helps you get out of fire-fighting mode so you can keep your databases running continuously at peak performance.

Use Case Scenarios

Resolve SQL Server Deadlocks

Tasks contending for resources cause SQL deadlocks. Identifying these can be time consuming and frustrating for the data platform team. SolarWinds SQL Sentry Deadlock Analysis identifies the root-cause of server deadlocks by using intuitive deadlock diagrams and playback functionalit so you can quickly estore peak performance to the business.

Reduced Incidents & Outages
Proactively monitor SQL to reduce potential database issues that can affect application performance and customer experiance.

Lower Infrastructure Costs
Makeinformed decisions on when to upgrade cloud services or hardware confidently, ensuring that you avoid wasteful costs.

Database Memory Dashboard

Database Performance Analysis Dashboard

Baselining SQL Performance

Not having a recent baseline makes it very difficult to know what abnormal behavior looks like. SolarWinds SQL Sentry and allow you to easily create different baselines; normal baseline, month end, quarter end for metrics including page life expectancy, cpu utilisation, database file sizes, wait stats and many more, so you know what normal looks like.

Manage Downtime Risk
Keep your data platforms running smoothly with continuously SQL performance monitoring, to avoid costly application downtime.

Free Up DBA Resources
Proactive SQL Sentry monitoring uncovers demand peaks, allowing DBAs to resolve issues quickly. Freeing them up for other tasks.

Key Product Features

SolarWinds SQL Sentry at a glance.

Blocking Analysis

Analyze blocking details to quickly identify the root cause of database performance issues, and understand the full impact of a block on application performance.

High-Impact Query Analysis

See long-running and high-impact queries in the Top SQL view, which helps you
easily identify and fix query database performance bottlenecks.

Proactive Alerting & Response System

With customizable Advisory Conditions, you can set relevant, actionable alerts and
automate responses to specific conditions to prevent alert fatigue.

Comprehensive Query Optimization

Analyse query statistics, plan recosting, and indexes and view query plan diagrams
with built-in tool – SolarWinds Plan Explorer.

Tempdb Analysis

Easily analyze file space usage across your tempdb data files, tempdb objects,
activity, and session usage for SQL Server and Microsoft Azure SQL Database.

Deadlock Analysis

Quickly determine the root-cause of database deadlocks, so you can effectively restore your database to optimal performance levels.

Useful Resources

Datasheet

 

Case Study

 

Deployment

 

Customisation

 

Training

 

Integration

 

Prosperon Networks are the UK’s leading provider of SolarWinds IT management solutions and services. We have been an Authorised SolarWinds Partner for over 14 years, and all of our Engineers are SolarWinds Certified Professionals (SCP). Over this time we have provided consulting, support, and training services to hundreds of SolarWinds customers across the UK and Europe.

Frequently Asked Questions

Can’t find the answer to your questions? Why don’t you give us a call and our helpful Account Managers will answer any question you have.

How is SolarWinds PDA licensed?

Database Performance Analyzer is licensed per monitored database instance, with specific license categories depending on which database(s) you want to monitor.

What databases does DPA supprt?

Database Performance Analyzer is agentless. It can monitor Oracle, SQL Server, MySQl, DB2, and SAP ASE running on-premise or in the cloud, with a single installation.

Can you help me with SolarWinds?

Our Professional Services team can help deploy SolarWinds according to best practices, Customise SolarWinds to your needs, and Integrate SolarWinds with your IT systems.

Is there any training available?

We offer a range of Training Courses to meet your individual requirements. All courses are led by experienced trainers and can be delivered on-site or at our training facility.

Related Insights From The Prosperon Blog

Share This