15. Performance Advisor and Event Manager Integration

SQL Sentry Performance Advisor integrates with Event Manager through a single console to provide functionality that simply is not available in other software applications. You can see Top SQL, Top Analysis Service Queries (MDX, DMX, and XMLA), Blocking, and Deadlocks on the Outlook-style SQL Sentry calendar, alongside SQL Agent jobs and other events. Chronological display of these types of events provides unparalleled insight into how they impact each other which simply can't be ascertained from a grid. In the Microsoft BI environment this allows you to easily visualize relationships between SSIS packages, Reporting Services Reports, and associated high impact queries on your Analysis Services Server.

Double click on the event to jump directly into an in-depth analysis within the corresponding Performance Advisor view.

You can also generate email and pager alerts whenever a:

• query exceeds a specific duration, or contains specific text.
• block occurs with full block chain details, when a block exceeds a specific duration, or when a blocking query contain specific text.
• deadlock occurs including the deadlock victim SQL, or when the victim query contains specific text.