View Server Resource Contention Across the Entire Enterprise
customer portal        

Shared Resource Views


Event Manager provides you with the power and productivity to optimize even the largest SQL Server enterprises quickly and easily. When nightly backup jobs contend for SAN, NAS or other network resources, causing IO performance problems or errors, grab the visual power of the Event Manager "shared resource view".

For example, you can easily create a custom calendar listing all of your server backup jobs across the entire enterprise that write to the same SAN or NAS, and eliminate any contention you see with just a few clicks! Event Manager even ships with several pre-configured sample views for various compressed backup systems to make getting started a breeze, including Quest LiteSpeed, Idera SQLsafe, and Red-Gate SQL Backup.

For more information see Better Server Backups and Eliminating Backup Contention.

How Does the Shared Resource View Work?
The events which have scheduling conflicts will automatically show up on the shared resource calendar view with an orange background. From here, you simply drag-and-drop future event instances within the calendar to eliminate the scheduling conflicts and reduce or eliminate any associated contention. As you drag-and-drop event instances to open slots on the calendar, Event Manager changes the backgrounds to white, denoting “no conflicts”.

When all events in your Event Manager shared resource view have a white background, you know you have a “leveled” schedule. A leveled schedule ensures that any bottlenecks and associated errors are minimized.

For a look at the real-world impact of your SQL Server Agent jobs subsystem and the not-so-obvious loads it can place on your systems read Hidden Jobs, Hidden Schedules and the Impact on your Server—By Stephen Wynkoop—SSWUG.ORG Founder

 

 
Product Evaluation
 

Download Performance Advisor and Event Manager Enterprise Edition


Enterprise Edition
SQL Server
Oracle
Windows Task Scheduler

Standard Edition
SQL Server
Windows Task Scheduler

Event Manager Features
Visual Schedule Management
Alerting and Response
SSIS and DTS Support
Cross-platform Support
Chaining and Queuing
Schedule Performance Monitoring
Graphical Reporting
Enterprise vs. Standard Edition

White Papers
Monitoring Disk Contention
Global Event Actions
Eliminating Backup Contention
SQL Server 2005 Migration
Log Shipping and Replication
Job Queuing
Job Automation
SQL Server Virtualization

More About Event Manager
Video Tutorials
System Architecture
Awards and Reviews
Price List/Online Store
ROI Calculator
Product Datasheet

performance advisor | event manager | site map | privacy | contact us | about us | sales@sqlsentry.net | 704.895.6241
© 2009 SQL Sentry, Inc. All rights reserved.