Event Manager for SQL Server
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.
Event Manager for SQL Server does not replace SQL Server Agent scheduler. In fact, that is a key differentiation between Event Manager and most other scheduling products. With Event Manager there are no agents to install and manage on each server. Event Manager for SQL Server provides a visual display of SQL Agent jobs along with other events across the enterprise so that the DBA can “see” how they relate to one another and optimize the schedules more efficiently.
If one finds they do not require the advanced features of Event Manager EE, then the Standard Edition is an excellent starting point. The Standard Edition can be easily upgraded to the Enterprise Edition if the needs of the organization change. For more detail, view the comparison matrix.
Key Features
| Visual Schedule Management |
- See your complex event schedules in a whole new light with Event Manager's robust, Outlook-style visual calendar with drag-and-drop rescheduling.
- 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, network segments, etc.
- Event Manager employs the most comprehensive and reliable notification system available today for SQL Server and Oracle.
- Provides a wide variety of response actions to any event status, runtime or performance condition.
- You can even generate notifications for Windows Task Scheduler, Reporting Services, and other event sources.
- Enable detailed logging for both SSIS and DTS packages with a few clicks.
- 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!
- Using a plug-in architecture, Event Manager EE seamlessly integrates event data from SQL Server, Oracle, Windows Scheduler and others together in one console, so you get the full picture.
- Event Manager doesn't replace your existing schedulers, it makes them work better.
- Easily enforce dependencies between SQL Server, Oracle and Windows Scheduler across your environment.
- Event Manager is the first system enabling automation and integration across different scheduling systems, ensuring precise control over which events run and when.
- Link any Windows performance counter directly to an event or custom view and see the impact any combination of events is having on Windows servers or shared resources.
- Counters are instantiated as needed for minimal server and network overhead.
- Event runtime graphs enable quick trend analysis
- Gantt-style performance graphs highlight the events competing for resources and causing end user performance problems.
- Event history and other list views can be easily exported to .HTML, .XML, or .CSV format.
- Provides complete scheduling, monitoring and notification features for SQL Server Reporting Services.
- Enables a DBA to view all Reporting Services events on the Event Manager calendar, monitor their impact on performance and set notifications ensuring awareness of any issue.
- Maps the awkward job GUIDs to friendly report names, and performance counters can be linked to any Reporting Services task, including individual subscriptions and report execution snapshots.
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.
Down Time Reduction
SQL Sentry Event Manager delivers better information about event performance and runtime statistics which enables DBAs to easily "level" event schedules, eliminate costly failures, and minimize resource contention and downtime caused by schedule conflicts and overruns.
Lower Database Administration Cost
By using SQL Sentry Event Manager the amount of manual labor typically required to perform mundane schedule management and troubleshooting tasks is greatly reduced, allowing DBA's to spend more time proactively managing their servers.
Ease of Use
SQL Sentry Event Manager mirrors your existing SQL Server Enterprise Manager or Management Studio configuration, so you don't have to redefine all of your servers and groups -- just open the SQL Sentry Console and you are ready to go.
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. If you’d like to see SQL Sentry’s overhead in a 100-server environment, let us know and we will send you the results of our latest comprehensive benchmark tests.
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.
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 are now in our 6th year as a Microsoft Gold Certified Partner, 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.
