With SQL Sentry collect and present the most actionable performance metrics and alerts, see important events and cross-reference them using an Outlook-style calendar. Quickly resolve issues by doing detailed analysis in the same tool you use for monitoring and alerting.
- High-impact query analysis: Quickly identify the highest-impact queries and target them for tuning.
- Integrated query tuning with Plan Explorer: Tune high-impact queries and plan a successful indexing strategy using the query plan captured at the time of execution.
- 100+ built-in alerrting condtitions: Learn about potential problems before users do by using dozens of built-in alerting conditions that cover everything from server outages to long-running jobs and queries.
- Real-time and historical performance metrics: Perform root cause analysis on performance bottlenecks, even if they happened days or weeks ago.
- Logically presented, actionable information: Cut through the noise of thousands of possible metrics to see the most relevant and actionable information.
- Performance overview and detail: Get an overview of the entire estate so you can quickly report on overall health and decide whether deeper analysis is necessary.
- Index size, fragmentation and usage analysis: Find out when and how to perform defragmentation operations, when to adjust fill factors or when an index definition should be changed. Perform automated maintenance, view historical trends.
- Visual deadlock analysis: Visualise a deadlock event, including the numbered order of operations, lock types and the associated query text for each process involved in the deadlock.
- Automated index defragmentation: Automate index defragmentation across the entire estate using well-known best practices. Run multiple defrag threads at the same time. Visualise the impact of fragmentation and defragmentation over time.