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 Overview

The Product Overview 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 patented 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

April 2015

Saving settings for SQL Sentry

A common question that comes into our support team is “How can I save my settings for SQL Sentry?” One of the members of our support team, Jim Holden (@SQLJim) answers that question in this blog post. He shows one approach to saving your settings for SQL Sentry – separating them from all the other data collected in the SQL Sentry database.

February 2015

SQL Sentry v8.3 Rundown

In version 8.3, we have pushed the envelope again, enhancing both features to make them even more useful. Arguably the most exciting enhancements in v8.3 are found in Custom Conditions, where three important new features make their appearance. Additionally, the Show Totals feature in Performance Advisor's Top SQL module has been extended to the Procedure Stats and Query Stats tabs. We'll touch on each of these features in this post and, as always, more in-depth information is available in the User Guide.

February 2015

Performance Baselines and Benchmarks for Microsoft SQL Server

The ability to conduct a database performance test to establish baseline measurements and workload performance benchmarks is one of the skills that strongly distinguishes the senior DBAs from the junior DBAs. The challenges in collecting the baselines and benchmarks can be daunting, but the benefits of having them are worth the time and energy.

December 2014

I Didn’t Know It Could Do That! – Using Notes

Justin Randall (@jh_randall) shows how to use the Notes feature in SQL Sentry software to help document issues and streamline troubleshooting efforts. There are three key advantages to including notes in your monitoring solution. First, the information is readily available in the same product/interface you are using to troubleshoot and resolve issues. Second, all users have access to that information and third, the information can be automatically included in notifications when an alert is fired.

December 2014

Proactive SQL Server Health Checks, Part 2: Maintenance

Erin Stellato (@erinstellato) of SQLskills.com continues her series on proactive SQL Server health checks, this time focusing on mastering maintenance tasks. She looks at the maintenance tasks that need to be run regularly such as backups, integrity checks, index maintenance and statistics updates.

More News

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

VERSION8.4

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 architecture diagram and 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 our Team Blog for the latest version info.

* First Name:

* Last Name:

Phone:

* Company Name:

* Email Address:

* Country:

How did you hear about SQL Sentry?


If you arrived here looking for SQL Sentry Plan Explorer, please click here.

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

LOOKS LIKE YOUR BROWSER IS OUT OF DATE

For your convenience here are links to supported browsers:

Your browser could be incompatible with this website.
If you close this window and continue you may experience less than optimal behavior.

Don't show this again