SQL Sentry 2024.4 System Requirements
SolarWinds strongly recommends that you install SQL Sentry on a server that is protected from unauthorized access by the public. If your use of SQL Sentry does not need to be public or internet-facing, install it on a server that is neither public, nor internet-facing. To learn about best practices for configuring your SQL Sentry installation securely, see Best practices to secure SolarWinds Products.
SQL Sentry Components
For information about the SQL Sentry components, see the SQL Sentry Components and Architecture article. The Installation Recommendations article provides details on where to install each component, as well as detailed implementation examples for installations of various sizes.
Important: For performance reasons, it's not recommended that the SQL Sentry client, monitoring service, or SQL Server (including the instance housing the SQL Sentry database) run simultaneously on the same computer.
SQL Sentry Client Machine
- Windows version from supported list below
- Microsoft .NET 4.8 (included in the setup package)
- Minimum single 1.6 GHz CPU, 1 GB RAM
SQL Sentry Monitoring Service Machine
- Windows version from supported list below
- Microsoft .NET 4.8 (included in the setup package)
- Minimum 4 cores 2.0+ GHz and 12 GB RAM
- Important: These are the minimum requirements for a standard 5 target installation. Review the Installation Recommendations article for detailed guidance on requirements.
Note: The Microsoft .NET 4.8 (included in the setup package) involves a system restart.
SQL Sentry Database Machine
- SQL Server 2014 (Standard, BI, and Enterprise)
- SQL Server 2016 (Standard, BI, and Enterprise)
- SQL Server 2017 (Standard, Linux OS, and Enterprise)
- SQL Server 2019 (Standard, Linux OS, and Enterprise)
- SQL Server 2022 (CU1 and above versions)
- Azure SQL Managed Instance
- Supported versions of SQL Server running on AWS RDS for SQL Server
- Minimum 4 cores 1.6 GHz, 8 GB RAM, and 10 GB storage
- Important: These are the minimum requirements for a standard 5 target installation. Review the Installation Recommendations article for detailed guidance on requirements.
Note: Azure SQL Database isn't currently supported as a host for the SQL Sentry database.
Note: SQL Server Express Edition may be used to host the SQL Sentry database. The scale limits placed on this edition make it suitable for smaller environments where only a few targets are being monitored. Having an unusually high number of databases or disks to monitor on your targets may mean reaching these limitations with only a few targets.
SQL Sentry Portal Service Machine
Installing the SQL Sentry Portal is optional, but we highly recommend that you install the SQL Sentry Portal and see everything it has to offer. Review the SQL Sentry Portal Configuration article for additional requirements, including security.
- 64-bit Microsoft Windows Server 2016 or greater
- Microsoft .NET Framework 4.8 Runtime
-
The Microsoft .NET Runtime prerequisite needs to be installed on the Windows Server that will host SQL Sentry Portal.
-
The ASP .NET Core Runtime 8.0 hosting bundle needs to be installed on the server if you choose to host SQL Sentry Portal in IIS.
Supported Operating Systems (SQL Sentry Components)
Supported Operating Systems (x64)
- Windows Server 2016
- Windows Server 2019
- Windows Server 2022
- Windows 10 (Anniversary update, Creators update, or Fall creators update)
Note: For more information, see .NET Framework system requirements for additional details on 4.8 requirements. Windows server 2008 and Windows 8.1 are no longer supported.
Watched Targets and Instances
Watched (monitored) Windows Targets
- Windows Server 2016
- Windows Server 2019*
- Windows Server 2022
- Windows 10
Important: *Windows Server 2019 may have some issues honoring firewall rules. You may need to explicitly enable a Remote Event Log Management rule in the firewall to watch a Windows Server 2019 target.
Watched Data Warehouse Targets
- Microsoft analytics platform system (AU3)
- Azure SQL Data Warehouse
Watched (monitored) SQL Server Instances
- SQL Server 2014
- SQL Server 2016
- SQL Server 2017
- SQL Server 2019
- SQL Server 2022
Watched (monitored) SQL Server Analysis Services, Tabular and Multi-dimensional Modes
- SQL Server 2014
- SQL Server 2016
- SQL Server 2017
- SQL Server 2019
- SQL Server 2022
Watched (monitored) Azure SQL Server Instances
- Azure SQL Database V12 or higher
- All service tiers
- Azure SQL Managed Instance
Note: When monitoring a Windows cluster with Performance Analysis for Windows, it's recommended to monitor cluster nodes individually.
Watched (monitored) Amazon Web Services (AWS) Instances
- Amazon Relational Database Service (RDS) for SQL Server Instance
- Amazon Elastic Compute Cloud (Amazon EC2) Instance
Features with Additional Requirements
- SQL Sentry Portal has additional requirements as outlined in the SQL Sentry Portal Configuration article.
- Storage Forecasting requires a SQL Sentry database on SQL Server 2016 or later with R/ML Services in-Database enabled for Advanced Disk Forecasting. There are no additional requirements for Standard Disk Forecasting.
- Important: For Advanced Disk Forecasting, you must turn on the external scripts enabled option in SQL Server for the instance hosting the SQL Sentry database. See the External Scripts Enabled server configuration option article in Microsoft Docs for instructions on setting that option. The SQL Server Launchpad service must also be running before using Advanced Disk Forecasting. See the SQL Server Launchpad service configuration article from Microsoft Docs for more information. If these were not in place, you should restart the SQL Sentry client after setting them and then select the Advanced Disk Forecasting mode.
- Deadlock tab and associated data in Performance Analysis for SQL Server is available on SQL 2005 and higher.
- Execution plan collection requires SQL 2005 SP2 or higher.
- Monitoring analysis services with Performance Analysis requires SQL Server 2005 or higher.
- Indexes tab and Fragmentation manager require SQL Server 2005 or higher.
- Monitoring the Windows event log with Performance Analysis for Windows is only supported for Windows vista or higher.
- Hyper-V virtualization is supported for Hyper-V v2 (included with Windows Server 2012 and greater).
- Monitoring VMware hosts requires vCenter 5.5, vCenter 6, vCenter 6.5, vCenter 6.7, and vCenter 7.0 to get vCenter-related metrics.
- vCenter 6.5 is only supported by SQL Sentry in version 11.2 or higher.
- vCenter 6.7 is only supported by SQL Sentry in version 19.0 or higher.
- vCenter 7.0 is only supported by SQL Sentry in version 2022.4 or higher.
- Monitoring Azure SQL database targets requires access to the SQL endpoint (over outbound port 1433) with the appropriate Azure SQL firewall rules created.
Warning: We do not support Synchronous-commit mode for the Availability Group hosting the SQL Sentry database in large or high latency network environments.