Server Job Schedule and Alert Management

SQL Sentry Event Manager® is the ultimate scheduling, alerting and response system for optimizing schedule performance of database servers across your enterprise. Event Manager provides DBAs with "Outlook-style" visibility and functionality for managing SQL Agent jobs, Windows Tasks, and Oracle jobs in increasingly complex cross-platform environments. Unlike most other scheduling products, Event Manager does not require an agent to be installed and managed on each server. It is available in 4 different platforms.

 

Event Manager for SQL Server

  • Visual display of SQL Agent jobs along with other events across the enterprise
  • Alerting and Response System for over 90 conditions including Output Content Matches
  • Advanced Chaining and Queuing features

Event Manager for Windows

  • Unprecedented visibility and manageability for the Windows Event Log and Task Scheduler
  • Alerts and Notifications for events impacting critical services and applications
  • Advanced Chaining and Queuing features

Event Manager for SharePoint

  • Unparalleled visibility into exactly when timer jobs run
  • Tools to easily assess which timer jobs are colliding more frequently
  • Alerts and Notifications for timer job failures, runtime deviations and more

Event Manager for Oracle

  • Calendar view of DBMS Jobs, Manager Jobs, Scheduler and other Events
  • Tools to manage intricate and voluminous job streams
  • Support for geographically distributed deployments and configuration of powerful cross-server event chains

Product Datasheet

The Product Datasheet provides you with all of the features in our tools. You can easily compare our tools and see which ones fit your organization’s needs.

 

 

Overhead Analysis

The SQL Sentry Overhead Analysis provides both qualitative and quantitative information about the overhead impact you should expect from SQL Sentry Event Manager and Performance Advisor.

 

Features

Filter by Platform: ALL SQL WIN SHAREPOINT ORACLE compare

Visual Schedule Management

    Event Manager Visual Schedule Management

Event Manager's Outlook-style calendar view provides a clear picture of your server event schedules - giving you unprecedented visibility and control over scheduling issues that can impact server performance. Quickly view historical and future schedule information at a glance, and easily resolve conflicts using drag-and-drop.

  • See your complex event schedules in a whole new light with Event Manager's robust, Outlook-style visual calendar with drag-and-drop rescheduling.
  • Event Manager highlights schedule overlap and contention issues, long running events, failed events and more using clear visual indicators.
  • The flexible interface allows simultaneous display of multiple calendars and graphs, and supports both full and split screen modes.
  • Slice and dice schedules across servers with the Global Calendar, Group Calendars, and Custom Event Views.
  • Easily assess contention levels across shared resources such as file storage areas, tape libraries, and network segments.
  • You can easily create calendars showing all events or tasks that read or write to a particular SAN or NAS device, or that utilize a certain network segment.
  • Multi-server calendars on Master (MSX) servers enable you to see what's happening across all Target (TSX) servers in one view.
  • Monitor critical events from the Application, System, and Security Logs.*
  • Control exactly which events are collected – by log, source application, severity level, or event text.*
  • Monitor tasks on all versions of Windows from Server 2003 to Server 2012.*
*Requires Event Manager for Windows


The event history view provides flexible sorting and grouping capabilities, color-coded status indicators, and full step-level details for multi-step jobs, DTS packages, and SSIS packages. For any multi-step job, DTS package or SSIS package, you can easily jump back in time to see how the job has performed over a certain time period. If the event fails, then you can easily see the red indicator and drill-down into it and find the reason it failed.

 

 

Alerting and Response System

    Event Manager Alerting and Response

SQL Sentry's Event Manager employs the most comprehensive and reliable cross-platform notification system available today, providing reliable, detailed alerts as well as a variety of other response conditions for various event types. Event Manager is agent-less, fault tolerant, and uses a centralized management system which eliminates the need to touch each server.

  • Provides a wide variety of response actions to any event status, runtime or performance condition.
  • You can even generate notifications for Windows tasks, Reporting Services, and other event sources.
  • For a full-list of every action and condition that are covered in the Event Manager, check out the User Guide.
  • Easily apply special alerting rules to the servers in different locations, with Shared Groups.
  • Configure multiple actions of the same type for the same condition, such as 3 different Send Email actions for the Job Failure condition - each with different alert targets (users or groups), different rulesets, and different alert windows.
  • Set exactly when contacts should be alerted using configurable ranges of time, for example "Business Hours" or "Weekends". You can even create compound windows which combine multiple windows together.
  • Displays exactly where the inherited settings are coming from, and allows you to Disable, Override, or Combine with an inherited condition action.

Event Manager goes beyond the limited alerting capabilities built-in to SQL Server, Oracle, and Windows Task Scheduler with messages that include granular, detail-level information. Event Manager alerts contain more of the information you need to quickly evaluate and resolve any condition, which can dramatically reduce response times.

 

 

History and Alert Filtering

  Event Manager History and Alert Filtering

Many event sources have a configurable history filter which enables control over which events are collected, displayed on the calendar, and available for alerting. Alert filters let you decide exactly which events will generate notifications, based on application, host, user, and other attributes such as only sending an alert for Top SQL failures coming from a specific host machine.

 

SSIS and DTS Support

 Event Manager SSIS and DTS Support

Problems with SSIS and DTS packages can be some of the most difficult to troubleshoot, because there is no easy and unified way to access detailed package log data via the native SQL Server tools. SQL Sentry makes it easy to enable detailed logging for both SSIS and DTS packages with a few clicks, and view the results on the SQL Sentry calendar and history list views alongside any other events on a server. Accessing error details for failed package steps has never been simpler!

 

Job Chaining

   Event Manager Job Chaining

Event Manager's advanced chaining features enable you to quickly and easily define dependencies and workflows involving SQL Agent jobs, Oracle jobs, and/or Windows Tasks. You have ultimate flexibility with regard to how the chains are defined - the chained jobs or tasks can reside anywhere in the enterprise, and you can have unlimited levels per chain, as well as unlimited jobs/tasks per level.

  • Easily enforce dependencies between SQL Server, Oracle and Windows across your environment.
  • First system to enable automation and integration across different scheduling systems, ensuring precise control over which events run and when.
  • Easy configuration of powerful cross-server job chains.
  • Define dependencies between events occurring on disparate systems. For example, run a SQL Server job whenever a Windows task completes successfully.
  • Graphical interface for easy configuration and printing of chain diagrams.
  • No limit to length or complexity of chain.
  • Works with your existing scheduling agents - no new schedulers are installed.
  • For simpler 1-to-1 chaining scenarios, you can utilize the "Execute Job" action to trigger a job on any SQL Server in response to any other event status or performance condition, for any event type.

 

 

Job Queuing

   Event Manager Job Queuing

Event Manager's advanced queuing features make it easy to prevent job conflicts related to occasional runtime deviations, and enforce inter-job dependencies. You can set a job to queue or be queued for a specified time, limit the total number of jobs in the queue at any one time, and control a job's behavior when it pops off the queue.

 

Cross-Platform Support

    Event Manager Cross-Platform Support

Event Manager seamlessly integrates external event data into calendars, and gives you unprecedented visibility and control over all of the events that can impact your server performance. Event Manager supports SQL Agent jobs, Windows tasks, SharePoint timer jobs and Oracle jobs in increasingly complex cross-platform environments.

  • Event Manager doesn't replace your existing schedulers, it makes them work better.
  • Using a plug-in architecture, Event Manager connector modules allow you to easily manage SQL Agent jobs, Windows tasks, SharePoint timer jobs and Oracle jobs.
    • The calendar view automatically brings all of these events together and displays them on its unified calendar, so you get the whole picture.
    • The data collected can then be used to trigger the various actions carried out by Event Manager such as sending email notifications, executing other jobs or tasks.
  • Event Manager manages and automates dependencies between different event types and across multiple servers through chaining.

 

 

Reporting Services Support

 Event Manager Reporting Services

Event Manager provides complete scheduling, monitoring and notification features for SQL Server Reporting Services. It enables you to view all Reporting Services events on the Event Manager calendar, monitor their impact on performance and set notifications to ensure awareness of any issue. You can also map the awkward job GUIDs to friendly report names and link performance counters to any Reporting Services task, including individual subscriptions and report execution snapshots.

 

Schedule Performance Monitoring

   Event Manager Schedule Performance Monitoring

Event Manager makes it simple to link any Windows performance counter directly to any job, task, or report and see exactly what impact it's having on performance throughout its run lifetime. Event Manager automatically enables and disables counters as needed, minimizing server and network overhead. You can easily link performance counters from different servers to a job, which can be extremely valuable for troubleshooting jobs that do work on multiple servers such as for replication, log shipping, DTS, etc.

  • Counters are instantiated as needed for minimal server and network overhead.
  • Efficiently manage complex schedules.
    • Minimize schedule contention, resource battles and other performance problems caused by “un-optimized” schedules.
    • Scheduling issues are often one of the biggest “hidden” contributors to performance degradation.
  • Event Manager continuously monitors job and task runtimes and generates alerts based on defined minimum or maximum runtime thresholds, which can be set at the global, server, or job-level.
  • You can easily be alerted whenever any job, task, report, or DTS package in your enterprise runs above or below a certain percentage of its "average" runtime, as well as an explicit threshold.
  • Whenever a SQL Agent job is involved in a blocking condition (blocked or blocking), you will be alerted with the full SQL statements, host names, and application names in the blocking chain.

 

 

Schedule Reporting

    Event Manager Schedule Reporting

Event Manager offers many different reports to help manage your servers' job schedules. The event runtime graphs allow you to quickly visualize long-term trends on your jobs. The Gantt-style performance graphs highlight the events competing for resources and causing end-user performance problems. You can also export your event history and other list views to .HTML, .XML, or .CSV format so you can easily share them with other people in your organization.

  • Performance data will be automatically collected whenever the scheduled event runs.
  • Any Windows performance counters, including any SQL Server counters, can easily be "linked" to a SQL Agent job, Windows task or Reporting Services report.
  • A combination of Gantt and Bar graphs are used to visually correlate schedule activity and performance data in an easy to read format.
  • Event performance graphs clearly illustrate how schedule collisions may be impacting server and database performance.

Event runtime graphs provide both historical and aggregate views, making it easy to spot runtime trends that can be an indicator of underlying scheduling and/or resource contention issues. For example, you can see how your nightly backups are trending over the past 3 months to determine if and when they'll fall outside of your desired backup window.

The conflicts viewer shows all scheduled events on a server with overlapping runtimes, sorted descending by “Total Conflict Time” by default (the total time one event overlaps with all other events). This measure is extremely valuable in determining which events may be causing the most resource contention. You simply double-click any conflict instance to immediately jump to that spot on the calendar, and then quickly resolve the conflict using drag-and-drop.

 

 

View   Reports   in   Client   and   Cloud

Reports

 

Event Manager

  • Global Server Performance
  • Performance Counter History
  • Performance Counter Date Range Comparison
  • SQL Server Performance

General

  • Action Counts
  • Active Settings List
  • Configured Actions List
  • Configured Notifications List

Benefits

Performance Improvement

Make smarter scheduling decisions by seeing and understanding the impact that events have on production resources, and easily eliminate schedule contention via drag-and-drop to ensure applications run at optimal levels.

 

Continual Innovation

While other SQL Server monitoring tools have stagnated, SQL Sentry has continued to push the envelope, introducing several industry firsts such as our patent-pending SQL Server disk analysis, unrestricted historical performance reporting, comprehensive deadlock analysis, performance event calendars, intelligent wait analysis, and many more cutting edge features.

 

Lower Overhead

SQL Sentry’s tools are built to be minimally invasive and incur the lowest possible hit on monitored servers via our agent-less architecture... while other SQL Server monitoring tools incur far more load than they will ever help you to resolve. Some even filter out all of their own query activity so you never see it! Don’t be fooled by misleading claims of lower overhead – install SQL Sentry alongside other tools to see exactly how much of a performance hit they incur. Download our Overhead Analysis.

 

Lower Cost

SQL Sentry software continually delivers more features, functionality and utility than other SQL Server software tools, at a lower price point. With subscription-based and site licensing options, the relative savings can grow even further.

 

Higher Quality

SQL Sentry software undergoes intensive regression, scalability and overhead testing in our internal test lab of over 100 SQL Servers. It is then real-world tested in one of the largest SQL Server hosting environments in the U.S., until it is deemed stable enough to release to the public... no matter how long it takes. After release, our integrated, automated exception reporter gives us a perpetual feedback loop with our customers, who are continually surprised to receive a response from a real human usually within hours of submitting an exception.

 

Lower Database Administration Costs

Event Manager greatly reduces the amount of manual labor required to perform mundane schedule management and troubleshoot performance problems, allowing DBA's to spend more time proactively managing their servers.

 

Scalability

SQL Sentry software is installed in some of the largest SQL Server environments in the world. Our low overhead, agent-less, site-based approach provides almost linear scalability. We have yet to meet a SQL Server environment that the SQL Sentry architecture can’t handle.

 

World-class Support

SQL Sentry provides the highest level of support services you will find in the SQL Server software world. Our clients continually rave about the responsiveness and technical competence of our support team. You will never speak to a non-technical front-line person that doesn’t understand SQL Server or SQL Sentry software. To the contrary, you will often be speaking directly to a development team member.

 

Credibility

We've been a Microsoft Gold Certified Partner for many years, and our customer survey results say it better than we ever could. Our marks across the board are consistently higher than other Microsoft partners. All customers fell into the "Champion" quadrant, ranking us amongst the top Microsoft ISVs in the world. Survey results.

 

Articles

August 2011

Why I Went With SQL Sentry

In my SQL Saturday #80 Session I spoke about how to get started as a DBA. One of the greatest advantages you can have as a DBA is setting up a fully featured monitoring solution.

July 2011

An in-depth analysis of SQL Sentry's overhead

One of my first major projects at SQL Sentry was framed shortly after I joined the company: to publish an analysis of the overhead that Performance Advisor and Event Manager place on both the server(s) being monitored and on the server(s) doing the monitoring. Every vendor wants to sell you on the "zero impact" and "no footprint" lines, but we all know that it is not possible for you to accurately measure performance on a server without also causing at least some performance degradation by virtue of performing said monitoring. So what does "zero impact" really mean in those cases?

April 2011

SQL Sentry v6.1: Something Old, Several Things New

Since releasing v6 a couple of months ago, we've been hard at work on some cool new features for v6.1. Our x.1 releases are usually comprised mostly of fixes for bugs not caught during the major release (x.0) beta, and a few new features. This x.1 release is different in that contains many exciting and high impact new features, and a higher feature:fix ratio than normal. This is likely due to the lengthy v6 beta, as well as some new QA processes we've put in place.

Videos

SQL Sentry - New in Version 7

SQL Sentry - New in Version 7

SQL Sentry Version 7 offers significant new features including integrated index analysis and defrag, mirroring monitoring and much more. We’ve also completely re-architected our alerting and notification functionality.

Event Manager Overview

Event Manager Overview

This video provides an overview of Event Manager, including the shared groups’ global calendar view. Calendar views are available for any server or group of servers, and can be easily customized to fit your organization’s needs.

Power Suite Overview

The SQL Sentry Power Suite provides a complete performance monitoring and optimization solution for Microsoft SQL Server by combining both Performance Advisor for SQL Server and Event Manager.

Introduction to Notifications

Event Manager employs the most comprehensive and reliable notification system available for SQL Server, providing a wide variety of response actions to any job status, runtime or performance condition.

Watch more Event Manager videos at: SQLSentry.TV

Pricing

SQL Sentry Event Manager is licensed per individual monitored instance. First year annual software maintenance is required and provides technical support via e-mail and phone, fixes and updates and free version upgrades.

For a complete listing, view the product price list and online store.

  License Maintenance
Event Manager for Windows
$295.00 $59.00
Event Manager for SQL Server
$995.00 $199.00
SAVE 50% / $2,975 Event Manager for SQL Server Quick Start 5-Pack
$2,495.00 included
Event Manager for SharePoint
$995.00 $199.00
Event Manager for Oracle
$995.00 $199.00
SAVE 20% / $1,188.00 BI Suite
(1) Performance Advisor for Analysis Services
(1) Performance Advisor for SQL Server
(1) Event Manager for SQL Server
$3,995.00 $799.00
SAVE 20% / $594.00 Power Suite for SQL Server
(1) Performance Advisor for SQL Server
(1) Event Manager for SQL Server
$1,995.00 $399.00
SAVE 42% / $4,975.00 Power Suite for SQL Server Quick Start 5-Pack
(5) Performance Advisor for SQL Server
(5) Event Manager for SQL Server
$6,995.00 included
SAVE 16% / $114.00 Power Suite for Windows
(1) Performance Advisor for Windows
(1) Event Manager for Windows
$495.00 $99.00
SAVE 40% / $1,175.00 Power Suite for Windows Quick Start 5-Pack
(5) Performance Advisor for Windows
(5) Event Manager for Windows
$1,795.00 included
SAVE 23% / $880.00 Power Suite PLUS
(1) Performance Advisor for SQL Server
(1) Event Manager for SQL Server
(1) Performance Advisor for Windows
(1) Event Manager for Windows
(1) Fragmentation Manager
$2,995.00 $599.00
SAVE 44% / $7,975.00 Power Suite PLUS Quick Start 5-Pack
(5) Performance Advisor for SQL Server
(5) Event Manager for SQL Server
(5) Performance Advisor for Windows
(5) Event Manager for Windows
(5) Fragmentation Manager
$9,995.00 included

SQL Sentry Power Suites include licenses for Event Manager and Performance Advisor.
Quick Start 5-Packs are only available to new customers with a limit of 1 per company. The first year annual software maintenance is included in all Quick Start 5-Packs. Subsequent years will be billed at the standard maintenance rate.
The first year annual software maintenance is required with license purchase.

BUY NOW

Download Evaluation

Register for a 15 Day Evaluation

For instant access to your trial of SQL Sentry Performance Advisor, Event Manager, and Fragmentation Manager for all supported platforms, please complete and submit the form below. You will receive instructions for gaining access to the unified setup package. The required license key will be sent via email, and will enable you to manage 5 Windows systems, 5 SQL Server instances, 2 Analysis Services instances, 2 SharePoint installations, and 5 Oracle databases. Please review the SQL Sentry system requirements prior to installation. For a larger trial, please contact us. If you have already registered through a previous download, you may go directly to My Account.

Check out Greg's blog for the latest on version 8.

* First Name:

* Last Name:

Phone:

* Company Name:

* Email Address:

* Country:

How did you hear about SQL Sentry?


Answer a few questions and extend your trial period:

Add 15 Days?

 

Answer a few questions and get 15 Days added to your evaluation!



Number of servers to monitor:
Number of people managing
your SQL Server environment?
Number of instances to monitor:
SQL Server Analysis Services
Oracle Windows

Which of your tasks are the most challenging?

What other software tools are you considering?

Do any of the following interest you?

(choose all that apply)

Solutions for SQL Server

SQL Server performance dashboard and multi-server monitoring
Real-time & historical troubleshooting and performance analysis
Storage system monitoring for activity, latency, & capacity
Index monitoring and management
High-availability monitoring for AlwaysOn, Mirroring, and Clustering
Top SQL tracking and analysis
Visualizing Top SQL, deadlocks, jobs failures, and other important events over time
Advanced job management, chaining, and queuing
Sophisticated alerting & conditional response for SQL Server conditions
Deep SQL tuning and performance analysis

Solutions for Business Intelligence

SSAS Performance dashboard and monitoring
Workload and Bottleneck Profiling
Capturing heavy MDX, XMLA, and DMX activity
Sophisticated alerting system for SSAS commands and runtime deviations
Monitoring SSAS Cache and storage systems
Visualizing SSAS, SQL Server, SSIS, SSRS, and SharePoint events over time
Sophisticated monitoring of SSIS data warehousing jobs and SSRS reports

Solutions for Windows Servers

Windows Performance Dashboard and Multi-server monitoring
Real-Time & Historical Troubleshooting and Performance Analysis
Sophisticated alerting & conditional response for Windows Tasks
Granular Windows process monitoring and analysis

Professional Services

Training for SQL Sentry products and best practices
Training for SQL Server / Windows technologies
Installation, configuration, and setup services
Troubleshooting, performance tuning, and optimization services
;