Guides for advanced topics with SentryOne software (SQL Sentry) such as using system parameters, applying data compression, using extended events, removing watched objects, using mail, and more.
SQL Sentry Troubleshooting
Guide to changing logging levels and using SQL Sentry log files to troubleshoot issues and steps to fix some issues.
Execute SQL and Execute process actions allow for the passing of parameters in the command text. There are nine system parameters available in the SentryOne client.
Apply SQL Server Data Compression
SQL Server data compression is used to save space on disk storage, as well as in memory.
Enabling Extended Events
SQL Trace and Extended Events SQL Sentry XE Trace ensures that Top SQL uses the current SQL trace mechanism. It's also used to collect data while minimizing the overhead and effectively using Extended Events. There is a different proces...
Multi-Server Administration (MSX/TSX)
SentryOne provides additional functionality for multi-server administration. Any server designated as a master server includes the MSX feature.
When a SQL Server 2005 and above instance is set to watched status with SQL Sentry, SentryOne auto-installs a stored procedure in the MSDB database named sp_sentry_dbmail_20.
When a SQL Server Instance is set to a watched status with SQL Sentry, SentryOne auto-installs a stored procedure in the MSDB database.
Removing Watched Server Objects
Enable watching and stop watching the targets within your server environment.
Adding the SQL Sentry Database to an Availability Group
To add an existing SQL Sentry Database to an Availability Group in your environment, complete the following steps: Registering your Listener Connection 1. Complete the following for your installation type: EPI Installation Open Windows Powe...