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.
SentryOne Troubleshooting Updated
Guide to changing logging levels and using SentryOne 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 SentryOne 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 process...
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.