Event Store Connections

An event store connection (usually referred to simply as a connection) is used by event sources to access data in event stores via some network transport mechanism.

In the SQL Sentry Client, each SQL Server and Task Scheduler instance node represents a single connection as shown below.  In the future, other connection types will be supported.

For example, the Jobs event source above utilizes the "SQL Server Agent Job" event provider over an ADO.NET connection to the SQL Server to access event data stored in the MSDB database.

For maximum efficiency and performance, SQL Sentry allows a connection to be shared by multiple event sources simultaneously - all event sources under the SQL Server connection node above (Jobs, Maintenance Plans, Alerts, DTS Packages, Reporting Services, and SQL Agent Log) utilize the same physical network connection.  This concept is illustrated in more detail in the Enterprise Architecture Diagram.

Configuring Connection-level Settings

Whenever you single-click on a connection node in the Navigator, the Actions and Settings pane will automatically refresh to display all conditions, actions and settings for the selected connection.  Any changes made here will apply to the selected connection only, overriding any globally configured settings.  Likewise, connection-level settings can be overridden at the object level by selecting an object node in the Navigator.