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.
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.
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.