Server Job Schedule and Alert Management

Ultimate scheduling, alerting and response system for optimizing schedule performance of database servers

With specific products for SQL Server, Windows, SharePoint and Oracle, 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.

 

Event Manager for SQL Server

Visual display of SQL Server jobs along with other SQL Server events across the enterprise

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 for the Windows Event Log and Windows Task Scheduler

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 SharePoint timer jobs run

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

Visual display of Oracle DBMS Jobs, Oracle Enterprise Manager Jobs and Oracle Scheduler

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

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

 

 

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.

 

 

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.

 

Tired of alerts based on static, outdated, or misguided thresholds?

Read our white paper on the most intelligent alerting in the industry

Articles

July 2014

I Didn't Know It Could Do That

Justin Randall begins a blog series aimed at showing our customers things they might not know about Performance Advisor and Event Manager. In this first post, Justin discusses the “Jump To” Menu, which is a context menu command that allows you to navigate from one element of the client to another while maintaining the time range of the jump off point.

June 2014

SQL Server, SharePoint & Windows Alerts: A New Take on Alerting

In this white paper, SQL Server MVP Kevin Kline discusses how the basic alerting system included with SQL Server behaves. He also shows how SQL Sentry's alerting functionality overcomes many of these limitations and those of many other alerting systems. Whether you're currently using a Windows, SharePoint, or SQL Server alerting system that you're very happy with or you're considering acquiring one, it's important to be aware of the potential limitations of that alerting system and then develop strategies to shore up those weaknesses.

October 2012

SQL Sentry v7.2 does Windows (and a whole lot more)

Since releasing SQL Sentry v7 with Fragmentation Manager in May, we've been hard at work on v7.2. Development ran concurrently with Plan Explorer PRO, which was released last week. v7.2 includes two exciting new products: Performance Advisor for Windows and Event Manager for Windows. The release candidate was recently published, and you can download it from our customer portal.

August 2011

Why I Went With SQL Sentry

"One of the greatest advantages you can have as a DBA is setting up a fully featured monitoring solution...Each one of these products (Performance Advisor, Event Manager, and Plan Explorer) on its own are great, but when you put them all together, it’s beyond awesome. It let’s you do more than just react to problems on your SQL Server, it let’s you get ahead of them" says Shannon Lowder, Database Engineer

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