Advanced

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.

Articles

System Parameters
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.
Performance Analysis Required Ports
In order for Performance Analysis to properly monitor a target on the network, ports on the monitored target must be accessible to the SentryOne Server machine(s).
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.
sp_sentry_dbmail_20
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.
sp_sentry_mail_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.