In-depth guides for all the event and calendar types, objects, sources, views, and event architecture in SQL Sentry.
SQL Sentry Calendar & List Views
The SQL Sentry event calendar combines historical and future event data to present an accurate visual representation of your schedule.
SQL Sentry Custom Event Views
SQL Sentry custom event views tailor views to monitor specific activity across the SQL Server and enterprise.
SQL Sentry Event Architecture
Earlier versions of SQL Sentry focused on agent jobs; however, this is no longer the case. SQL Sentry's current architecture enables monitoring and management of jobs, tasks, and status events.
SQL Sentry Event Objects
An event object is any job, task, or event type that can be managed using SQL Sentry. There are two general types of event objects, including active and status event objects.
SQL Sentry Event Sources
A SQL Sentry event source represents a unique instance of an event provider operating over a single event store connection.
SQL Sentry Event Chains
SQL Sentry event chains are a series of dependencies between events running on the same server or different servers.
SQL Sentry Filtering Events
The history filter allows you to define rules that control what types of events the monitoring service writes into event history concerning the monitored servers.
SQL Sentry Job Queuing
SQL Sentry job queuing allows a resource intensive job to delay other jobs from executing until the job completes.
SQL Sentry Sample Views & Shared Resources
Sample views are modified to restrict event instances to utilize the same shared resources, such as a Network Attached Storage (NAS), Storage Area Network (SAN) device, or even a network segment.
SQL Sentry Job Step / SSIS Logging
The SQL Sentry Event Calendar is capable of collecting and displaying extended step log data for SQL server agent job steps on the SQL server 2005 and above.
SQL Sentry Runtime Stats
The Runtime Stats node displays an active event object's historical runtime information. The Runtime Stats graphs make it easy to identify runtime trends that can be indicators of or eventually lead to performance issues with the event or server.
SQL Sentry Failed Instances
When a certain event has failed, there are several ways the SQL Sentry client signals you to that fact.
SQL Sentry Conflict Viewer
Event conflicts often contribute to performance problems on a SQL server. The Conflict Viewer provides valuable insight into how event schedulers are contending with each other.