Once you've completed the Onboarding process in the Getting Started section, you're ready to start using SQL Sentry and configure your environment. Some first steps may include adding additional servers (targets) to monitor, organizing your targets, and using the calendar. The following is a review of some common tasks performed using the SQL Sentry client.
Monitoring Targets and Target Groups
See the Monitoring Additional Targets article for detailed information.
Adding a Target
Select Add in the right-click context menu of one of the following nodes to add a target:
- All Targets
- Site
- Group
Deleting a Target
Select Delete Target in the right-click context menu of any target node to delete that target.
Note: Before deleting a target, select Stop Watching to stop watching all of the target's associated instances.
Warning: Delete Target deletes the actual registration for the target from SQL Sentry. This includes the deletion of all historical information for any associated instances belonging to the target from the SQL Sentry database. Delete Target is final and can't be undone. Only use this command to permanently delete information SQL Sentry has stored about the target and its associated instances from the SQL Sentry database.
Adding a Target Group
On any site node or existing group node, right-click and select Add, and then select Group to add a target group.
Deleting a Target Group
On any existing group node, right-click and select Delete Group to delete the selected target group.
Note: You need to remove all targets and sub-groups before deleting a group.
Monitoring Instances
Adding an Instance
Select Add in the right-click context menu of one of the following nodes to add an instance:
- All Targets
- Site
- Target Group Target
For more information about adding an instance, see the Monitoring Additional Targets topic.
Watching an Instance
On any instance node, select Watch to begin watching that instance. For more information about watching an instance, see the Monitoring Additional Targets topic.
SQL Server Registrations
Unsupported: As of June 2020, the SQL Server Registrations feature is deprecated and no longer supported.
Viewing a SQL Server Registration
To view your local SQL Server registrations, select the Show SQL Server Registrations icon located in the Navigator pane.
Creating a SQL Server Registration
Select New SQL Server Registration in the right-click context menu of the Local Server Groups node contained beneath the SQL Server Registrations node to create a new SQL Server Registration.
Deleting a SQL Server Registration
Select Delete Registration in the right-click context menu of any SQL Server registration to delete the selected SQL Server Registration.
Synchronizing SQL Server Groups
On the Local Server Groups node, select Synchronize SQL Server Groups to synchronize the SQL Sentry client groups and servers with SSMS.
Note: You may need to close SSMS prior to synchronization for any changes you make visible.
Event Calendar Related
Jumping to a Particular Time in the Calendar View
On any node above the object level, right-click and select Jump To > Time to open the Select the time window. Select the desired date and time, and then select Ok to open your time selection. To persist the time setting, go to Tools > User Preferences > Navigator, and then select the appropriate parameters. This allows you to jump to the same time for each selected view. For more information about the Event Calendar, see the Calendar and List Views article.
![]() | ![]() |
User and Group Tasks
Adding a User
Double-click or right-click the Users node, and then select New to open the Add a User window. Input the appropriate information in the user window, and then select Save to save your changes. The new user displays under the Users node.
![]() | ![]() |
Editing a User
Double-click or right-click the Users node, and then select Open to open the Edit User window. The user window appears populated with that user's settings. Make any changes, and then select Save to save the changes.
![]() | ![]() |
Deleting a User
On a user node, select the delete key or select Delete User from the context menu to permanently delete the user.
Adding a Group
Double-click or right-click the Groups node, and then select New to open the Add a Group window. Input the appropriate information in the group window, and then select Save to save your changes. The new group displays under the Groups node.
![]() | ![]() |
Editing a Group
Double-click or right-click the Groups node, and then select Open to open the group window populated with the group's settings. Make any changes, and then select Save to save the changes.
![]() | ![]() |
Deleting a Group
On a group node, select the delete key or select Delete Group from the context menu to permanently delete the group.
For more information about users and groups, see the Contact Management topic.
Events
Adding an Event Object
On any event object node, select New > Job... to open SSMS and create a new SQL Server Agent Job.
Deleting an Event Object
On any event objects node, select Delete Job to permanently delete the object.
Note: Not all objects support deletion from the SQL Sentry Client (Reporting Services, etc).
Watching an Event Object
On any event objects node, select Watch Job to sets the object status to Watched and enable conditions and actions for the object, as well as queue chaining and performance monitoring features, if applicable. The instance status will also be set to Watched if it isn't already watched.
Stop Watching an Event Object
On any event objects node, select Stop Watching Job to set the object status to Unwatched, disable conditions and actions for the object, as well as queue chaining and performance monitoring features, if applicable.
Enabling an Event Object
On the event objects node, select Enable to enable the event to run according to the schedules defined for it.
Disabling an Event Object
On the event objects node, select Disable to disable the event from running according to the schedules defined for it.
Viewing an Event Object's Properties
On any event objects node, select Properties to display the object's native properties window.
Note: Not all objects support the properties interface (Reporting Services, etc).
Performance Monitoring
Starting Performance Monitoring
On a watched event objects node, select Monitor Performance to enable monitoring for any performance counters linked to the object. The SQL Sentry monitoring service automatically starts any linked counters immediately prior to an event instance starting and stops the counters shortly after the instance ends, minimizing any associated overhead on the network and monitored instance(s).
Stopping Performance Monitoring
On a watched event objects node, select Stop Monitoring Performance to suspend performance monitoring for the object.
Note: When you select to Stop Monitoring Performance, existing linked counters are not deleted, so monitoring can easily be re-enabled for the object in the future.
Deleting a Performance Counter
On any performance counter node, select Delete to unlink the performance counter from this object.
Note: You can re-link the counter to the object at any point.
Jobs/Tasks
Starting a Job or Task
On any job or task node, select Start Job to start the job.
Note: If the job has more than one step, a window appears allowing you to select the step where you would like the job to start.
Stopping a Job or Task
On any job or task node, select Stop Job to stop the job.
Viewing Job History
On any event objects node, select Jump To > History, and then select the range to view to open the job at the selected time.
Helpful SQL Sentry Client Information
The following is a list of topics that provide detailed information about aspects of the SQL Sentry Client including information on client glyphs, icons, and indicators:
Topic | Links |
---|---|
Client Alerts |
|
Event Calendar |
|
Event Chains |
|
SQL Sentry Client |
|