Performance Monitoring and Tuning

Unparalleled insight, awareness and control over the true source of performance issues.

With specific products for SQL Server, Analysis Services, and Windows, Performance Advisor monitors relevant metrics and provides unmatched insight into poorly performing SQL, blocks, deadlocks, storage and I/O bottlenecks, as well as system resource usage. Its ground-breaking features are designed with the singular goal of simplifying the process of performance tuning and optimization.

 

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: NEW ALL SQL SSAS Windows

Performance Dashboard

   SQL Sentry Performance Dashboard

SQL Sentry's Performance Advisor Dashboard gives you a real-time and historical view of all of your server's most pertinent SQL Server, SSAS and Windows performance metrics. They are displayed side-by-side, in a single pane of glass, so you have the full picture at a glance. You can also easily switch between the real-time and historical modes to view performance metrics at any point in time or date range. For a full list of performance metrics that are on the dashboard, take a look at our User Guide.

  • Easily investigate long term trends over weeks, months, or even years.
  • Easily jump to a very specific range where performance issues were reported and investigate with moment-by-moment granularity.
  • After selecting a time frame of interest, easily zoom in or jump to other details to easily correlate Top SQL, blocks, deadlocks and more at that point in history.
  • New metrics are presented front and center for an instant warning of potential performance issues, including bookmark lookups, forwarded records, and I/O statistics for backup and restore operations.
  • Multiple instances on the same server can easily be selected and viewed.
  • All instances are represented by different colored segments on the Windows resource charts, allowing you to see how any one instance is impacting the server as a whole.
  • In history mode, you can zoom in and out, or move between time intervals with the click of a button.
  • Mirroring queue monitoring displays the Send and/or Redo Queues on the same chart.
  • SQL Server resource utilization is integrated into the Windows network, CPU and memory charts, so you can monitor exactly how much of your server resources are being consumed by each SQL Server instance.*
  • When monitoring a NUMA system, both the SQL Server and Windows memory charts are split to show exactly how much memory is allocated to and used by each NUMA node, which eases diagnosis of single-node memory pressure issues. In addition, page life expectancy history is also shown for each node.*
  • Organizes related processes into friendly groups, with both individual and group level metrics. Several groups come preconfigured, including SharePoint, IIS, SSIS, and SSRS, and you can easily add custom groups.**
  • Supports processor groups to enable display of more than 64 processors.**
  • Organizes processors by NUMA node so you can easily evaluate how NUMA resources are being utilized, and judge the effectiveness of configured affinity settings.**
*Requires Performance Advisor for SQL Server


**Requires Performance Advisor for Windows


Performance Advisor Wait Stats

This chart on the Performance Advisor Dashboard shows SQL Server Waits and the percentage of all of the waits that are waiting on the CPU. The SQL Server Waits graph shows both high-level and detailed resource utilization, giving you an instant profile for the SQL Server so you can see exactly which resources or subsystems may be causing slowdowns. Wait types are grouped together into categories by major physical resources and meaningless wait types are eliminated. If you hover over a category, then you will see a tooltip that shows the detailed wait types for that time sample.

Note: To view the SQL Server Waits chart, you need a license for Performance Advisor for SQL Server.

Performance Advisor Jump to Query

The dashboard allows you to investigate long term trends over weeks, months, or even years. You can just as easily jump to a very specific range where performance issues were reported and investigate with moment-by-moment granularity, something that isn't possible with other tools that take snapshots every several minutes. Then, drag your mouse to select a timeframe of interest and easily zoom in, create a baseline or go back to sample mode for that time period. You can also jump to other details to easily correlate Top SQL, blocks, deadlocks or more at that point in history. If you are also using Event Manager, then you can jump to the Calendar to see what was running during that time period.

Note: Not every jump to option is available in every platform.

 

 

Baselining

    Performance Advisor Baselines

To help manage change in your environment, Performance Advisor includes both pre-configured baselines and the ability to create your own custom baselines. Baselines can be viewed and managed from the Performance Advisor Dashboard. At a glance, you can see where performance deviates and resolve those issues before they become a problem. Custom baselines are configurable and, in combination with Intelligent Alerting, provide a comprehensive change management and notification system.

  • Out of the box pre-configured baselines are available for the previous period, day, week, month, quarter and year.
  • Create custom baselines on demand for any desired time range.
  • Overlay both pre-configured and custom baselines on the Performance Advisor Dashboard.
  • Full alerting capability for baseline metrics using Intelligent Alerting.

 

 

Intelligent Alerting

    Performance Advisor Custom Conditions

Intelligent Alerting allows you to build alerts specific to your own monitored environment, using values and metrics retrieved from multiple sources and subsystems. Via custom conditions, you can easily create advanced performance alerting, enhanced change detection and advisory rule sets. When building custom conditions, you can use any combination of ANDs and ORs, and any number of nesting levels, to compare the values retrieved from these multiple sources. Everything is point-and-click, so even complex conditions can be configured quickly.

  • Use multiplication, division, addition and subtraction to combine values from any subsystem, and use the results in comparison operators.
  • Easily combine multiple conditions together to create compound conditions.
  • Set up alerts for any query that exceeds a specific duration threshold.
  • Test any performance counter against a baseline value, or as a percentage of a baseline value.
  • Choose from 11 different actions that can occur when a condition is met.
  • See event markers on the Performance Advisor Dashboard charts, including enhanced tooltips with supplemental information.
  • Easily apply your conditions to an individual server, a group of servers, or your entire environment.
  • Test any new condition against monitored servers before assigning any actions.
  • Alerts write to the Events Log, where a historical record of the event with a snapshot of all associated metrics is maintained.

 

 

Cloud.SQLSentry.com

    Cloud.SQLSentry.com.

Cloud.sqlsentry.com provides an easily configurable and highly customizable way to access your performance data anywhere you have an Internet connection. Once you enable cloud syncing for your SQL Sentry installation, you will have access to many of the same views available in the SQL Sentry Client. This includes all of the popular reporting options, the new alerting Events Log, and the Global Status view. You will also have complete control over who has access to this information.

  • Easily share your SQL Sentry performance data with people in your organization and/or with SQL Server industry leading experts.
  • Choose an alias for the names of computers, servers, and databases before they are synchronized to keep your information secure.
  • Get full access to the SQL Sentry reporting options with the Web Report Viewer.
  • Keep track of your Intelligent Alerting rules as they are happening, with the new alerting Events Log.
  • Securely share pertinent performance data on a server-by-server basis, without ever giving out unneeded access to your environment’s back-end or the SQL Sentry Client.
  • The Cloud Portal’s Global Status view provides integrated history charting, with both detailed and high-level metrics.

 

 

Global Server Status View

   Global Server Status View

With the Global Server Status View, you can monitor the health of all of your SQL, SSAS and Windows servers from one centralized location. Metrics are color-coded based on pre-defined best practice thresholds, making it a simple process to quickly identify which metrics have a critical or warning state. Just like the Performance Advisor Dashboard, historical charts are also available from the Global Server Status View. The overview screens are filterable by the various columns to show only those servers you wish to know about.

  • View key performance metrics for all SQL, SSAS and Windows servers across your enterprise in one view.
  • Metrics and servers change color based upon predefined warning and critical ranges.
  • Set custom filters for any metric or combination of metrics to show only servers requiring attention.
  • Easily drill into the detailed dashboard view for any server with just a couple of clicks.
  • See Windows resources consumed by each SQL Server and SSAS instance for network, CPU, and memory.
  • Detailed history charts for a visual indication of server health over time.


SQL Sentry Global Server Status view

The Global Server Service view allows you to see the performance metrics for all of your servers in an easy to understand table. If a server needs attention, then the metric and server name will change colors to indicate that the metric has passed the pre-defined threshold. This allows you to easily see which servers require immediate attention. You can also filter the view by the various columns to show only those servers you wish to know about. You can then easily drill into the detailed dashboard view for any server with just a couple of clicks.

 

 

SQL Server Disk Activity

  Performance Advisor Disk Activity

SQL Sentry's Disk Activity view is patent pending functionality that provides a graphical view into the live activity on your server’s disk system. You can easily identify every data and log file to see where they reside on the system. For the first time, you can peer into your disk system in real time and see the hot spots! Just as valuable is the historical view. This view allows you to easily identify which files are consistently experiencing disk performance issues, and determine whether relocating them will improve performance.

  • Animation shows you exactly how data is moving through your disk system, highlighting performance bottlenecks at the database file, physical disk, or controller level for SAN, NAS or direct attached storage.
  • View disk bottlenecks in real-time mode, or historical mode for any date range.
  • Improve performance by easily identifying common configuration problems such as mixing busy data and transaction log files on the same physical drive.
  • Detection of Automatic Disk Partition Alignment problems with comparison to disk latency.
  • Mount Points and Fusion-IO drives are displayed alongside all other disks.
  • Misaligned partitions are highlighted, which allows you to instantly see where basic configuration issues may be hurting disk performance.
  • Innovative performance profiling highlights bottlenecks in the formula engine, storage engine, or elsewhere over any date range.*
  • View SSAS-related disk activity and system file cache usage, including file cache hit ratios.*
  • View SSAS internal cache activity, including hit ratios for all cache lookup types, as well as cache growth/shrinkage.*
*Requires Performance Advisor for Analysis Services


SQL Sentry Disk Activity
SQL Sentry Disk Activity History

The Disk Activity tab provides a patent-pending graphical disk analysis system which breaks down disk activity and tendency at the controller, physical disk, and file level, highlighting bottlenecks at any point in the disk system. The top pipe represents read activity while the bottom pipe represents write activity. The thickness and color of the displayed segmented line indicates the amount of latency being experienced. When you select any file, a tooltip will also be displayed. In it, you will see the numerical values for the reads and writes hitting a particular file.

You can also go back and see the historical view for a particular time period. This view allows you to easily identify which files are consistently experiencing disk performance issues, and determine whether relocating them will improve performance. The thickness and color of the lines of the lines are similar to sample mode so you can easily see the amount of latency being experienced.

 

 

SQL Server Disk Space

  Performance Advisor SQL Server Disk Space

The Disk Space view gives you a graphical display by file and partition size. At a glance, you can identify where you are running into disk space issues and additional details help you track file utilization. You can also view space data historically, and disk reports allow you to track file growth trends, making it easy to predict when disk space issues are likely to occur. All of these details are available for local disks, mount points, and SAN storage, for a complete view of your storage environment.

  • Graphically displays disk space utilization by database and file.
  • Easily monitor and identify SQL Server disk capacity issues and understand where various database files reside on the disk I/O sub-system for SAN, NAS or direct attached disks.
  • Auto growth settings are shown with suboptimal settings highlighted.
  • Too many virtual log files (VLFs) can be a significant hidden drain on SQL Server database performance, and Performance Advisor is the first tool to bring this issue to the forefront. VLF statistics are shown alongside disk space usage, and problematic auto-growth and backup settings are highlighted.
  • Log Files with a high number of VLFs are highlighted to show where performance issues are likely to develop.


Performance Advisor Disk Space

Under the graphical display of your disk space, there is a Gridview pane, which displays all of the useful metrics for disks. In the Gridview, auto growth settings are shown with suboptimal settings highlighted. This helps you catch potential problems that will lead to performance issues like excess virtual log files (VLFs). The Gridview also provides details on VLFs, and log files with a high number of VLFs are highlighted to show where performance issues are likely to develop.

 

 

Top SQL

  Performance Advisor Top SQL Tab

The Top SQL view provides details about any live or historical long running and/or high impact statements. Top SQL thresholds can be set based on duration, CPU, reads, or writes. The executed statement, database, host, application, and login are provided along with pertinent performance metrics. You can also visualize a statement's history with runtime graphs, or easily jump to the calendar to see the statement alongside any jobs or other events.

  • Capture all high impact worst performing stored procedures, batches and statements.
  • All information is provided in a highly customizable grid view that allows you to sort, rearrange, or filter on any column for raw or normalized metrics.
  • Low-overhead tracing system can safely be run 24/7 without impacting SQL Server/SSAS performance.
  • Multiple executions of the same SQL are automatically normalized and aggregated, so you can easily determine which SQL is having the greatest overall impact on performance.
  • Drill into individual query executions to rapidly isolate problems with particular parameter values.
  • Runtime graphs show how the performance and runtime of a particular query have been trending over time.
  • Generate email notifications and automate other actions based on statement completion, runtime thresholds, or string matches on statement details.
  • Running queries are shown, auto-growth events are captured, and query plans can be viewed for running and completed queries. Blocked and failed queries are highlighted, and error information is provided.
  • Rows affected and auto-growth size are shown alongside other performance metrics.
  • Top SQL captures and aggregates all high impact SSAS commands (MDX, DMX and XMLA), showing top commands by CPU and I/O usage.*
  • Pinpoint problem SSAS queries, and see exactly how much formula and storage engine time each query is using, as well as the most heavily used partitions and aggregations.*
*Requires Performance Advisor for Analysis Services


SQL Sentry Performance Advisor Top SQL Settings
SQL Sentry Top SQL Top SQL Runtime Graph

You can easily change your collection settings to capture only the queries that you want. By default, SQL Sentry only captures queries that run longer than 5 seconds. You can easily change your settings to capture shorter queries, but it could cause a negative impact on performance.

You can also view a statement’s history with runtime graphs. The graph marks the maximum, average, and minimum runtime for a particular statement. It makes it easy to see runtime trends, which can be an indicator of or eventually lead to performance issues with the statement or the server.

Note:To view runtime graphs, you must have a license for Event Manager.

 

 

Index Analysis

 Performance Advisor Index Analysis

The Indexes tab displays information that has been collected about your tables and indexes by SQL Sentry Fragmentation Manager. It can be used to help you make intelligent decisions about index management in your environment: such as when and how to perform defragmentation operations, when to adjust fill factors, or even when an index definition should be changed. You can even perform automated maintenance of indexes including support for multiple concurrent defragmentation operations. You can also view historical trends on index usage, size and fragmentation.

  • The Index Grid View shows statistics about your individual indexes, including size, average percent fragmented, average percent page space used, fill factor, and much more.
  • The Index Tree View contains the same statistics as the grid but organized by Database, Table, Index, and Partition-level drilldowns.
  • Sort the data and apply filters to easily see which indexes need to be addressed.
  • SQL Sentry’s collection of buffer data enables you to see how much of each index is currently memory-resident, allowing for better decision making regarding index maintenance strategies.
  • Easily shortcut to index properties in SQL Server Management Studio via the right-click context menu.


SQL SentryPerformance Advisor Indexes Tree

The Index Tree View shows statistics about your individual indexes, including size, average percent fragmented, average percent page space used, fill factor, and much more. It is the same as the Index Grid View except that it’s organized by databases on the monitored SQL Server instance. You can drill down into information at the table, index, and partition levels as well.

 

 

 

AlwaysOn Monitoring

 SQL Server AlwaysOn

The SQL Server AlwaysOn tab displays information about your AlwaysOn environment. It is split into 3 different sections. The first section provides you with several unique actionable layouts to display your AlwaysOn environment. The connector pipes and inner flow lines in the layouts provide you with visual indicators of both data flow volume and rate between nodes or replicas. The second section displays historical charts and AlwaysOn health events from your environment. The final section displays high level and detailed level metrics concerning your environment.

  • Several unique layouts display your AlwaysOn environment from different perspectives.
    • The WSFC Members layout offers a high level perspective of the topology, including file share or disk witnesses, as well as aggregated data flow between WSFC nodes.
    • The WSFC Node/Group Matrix layout offers a grid-style presentation of the entire WSFC, by node and Availability Group.
    • The Groups/Replicas layout shows the performance, health, and configuration of each Availability Group.
  • Flow lines between replicas highlight bottlenecks in the environment via dynamically changing width and color.
  • Context-aware charts and grids provide historical performance and health details over any date range.
  • Visual indicators on each replica provide quick cues about group health and configuration.
  • Notifications can be easily configured to alert you to health changes and failovers.


SQL Sentry AlwaysOn WSFC Members Layout
SQL Sentry AlwaysOn WSFC Node/Group Matrix

The WSFC Members layout offers a high level perspective of the topology, including file share or disk witnesses, as well as aggregated data flow between WSFC nodes. The flow lines between the nodes change width and color depending on the amount of information that is moving between them.

The WSFC Node/Group Matrix offers a grid-style presentation of the entire WSFC, by node and Availability Group. The flow lines between the nodes change width and color depending on the amount of information that is moving between them.

 
SQL Sentry AlwaysOn Groups/Replicas Layout

The Groups/Replicas layout shows the performance, health, and configuration of each Availability Group. The nodes display the name of the server and whether it is a primary or a secondary. The flow lines between the replicas change width and color depending on the amount of information that is moving between them.

 

 

SQL Query Optimization (SQL Sentry Plan Explorer)

  Performance Advisor Query Plan Optimization

The integrated Plan Explorer functionality gives you dramatically enhanced visibility into SQL execution plans. You get a more compact, readable format than what is provided with the native tools. Plan information is collected automatically for Top SQL statements, and plan history is retained so you can see how plans are being used over time and how different versions impact performance. You can even make modifications to statements within the SQL Sentry Client and then retrieve estimated or actual plans to determine how effective your changes will be.

  • The integrated Plan Explorer takes SQL query plan performance optimization to a level never before possible.
  • Cost information is color-scaled so highest cost operations are instantly obvious.
  • Improved layout algorithms render more of the plan in view, making navigation much easier even for large, complex plans.
  • Plan information is continuously captured for heavy, slow-running, poorly-performing T-SQL, providing a record of all plan changes so you can see how different plan versions impact SQL query performance.
  • Plan CPU and I/O metrics are shown alongside operation totals, including lookups, scans, parallelism, sorts and more, so you can quickly find the heaviest plans on a SQL Server.
  • Plan Tree, Top Operations, and Query Column views are synchronized with the graphical plan diagram, letting you quickly view a plan from different angles.
  • Instant access to important details previously buried in the plan XML make the query optimization process much more efficient.
  • Easily identify which columns and indexes are used in particular operations and determine which modifications will have the biggest impact.


SQL Sentry Query Plan Optimization Object View

The Query Plans tab gives you a list of all plans collected for Top SQL events in a specified date range. The plans that have the highest cost operations will be highlighted so you can easily see which plans may lead to a performance problem. You also have the ability to view any query plan using the integrated tool, Plan Explorer.

 
SQL Sentry Query Plan Optimization Estimated/Actual Plan

When you view a plan in the Query Plans tab, you can make modifications to statements and then retrieve the estimated or actual plans to determine how effective your changes will be. With Plan Explorer, you can quickly and easily identify which columns and indexes are used in particular operations and determine which modifications have the biggest impact.

 

 

SQL Server Blocking

 Performance Advisor SQL Server Blocking

SQL Sentry's block analysis captures all block details based on configured duration thresholds. You get a hierarchical view of your blocking chains historically as well as in real time. Details such as the executed statement, database, login and host are provided for all processes involved. Additional details like wait types and wait resources are provided as well. In addition to historical information, blocks can be viewed while they are occurring and blocking processes can be killed from the SQL Sentry Client.

  • Hierarchical display of all blocking process chains provides the most complete picture of blocks available for SQL Server.
  • Wait Resources are automatically resolved for you, so for the first time you can instantly see which tables or indexes are being contended for without any manual effort.
  • Generates email alerts with full block chain details whenever a block occurs, when a block exceeds a specific duration, or when a blocking query contains specific text.


SQL Sentry Performance Advisor Process Killed

In the Blocking SQL tab, you can view blocks while they are occurring and blocking processes can be killed. If you use Event Manager, then you can also jump to the calendar to see what processes are running at the time the block occurred.

 

 

SQL Server Deadlocks

 Performance Advisor SQL Server Deadlocks

The Deadlocks tab provides the most comprehensive view available into SQL Server deadlocks. A graphical representation gives you a snapshot of all processes and resources involved. In addition to the graphical view, all other pertinent details are shown including the SQL statements executing at the time the deadlock was detected. All of this is “out of the box” functionality without the need to install any agents, set any trace flags, or perform any configuration on the monitored servers themselves.

  • Provides a graphical display of all SQL Server deadlock types, synchronized with an innovative grid-based display to provide the most complete picture of SQL Server deadlocks available.
  • Grid display lists all nodes organized by resource, owners and waiters, and includes the full T-SQL for all nodes.
  • Host, application, and resource names are resolved in the graph, eliminating the need to translate reference IDs and SPIDs.
  • Unlike other deadlock graphing tools, deadlock nodes contain the concise information you need to rapidly visualize the deadlock and determine the root cause, as well as the order in which the locks are taken.
  • The deadlock victim is clearly marked in red, and the graph is annotated to not only show lock types, but also the order in which they were applied.
  • Generates email alerts including the deadlock victim T-SQL whenever a deadlock occurs, or when the victim query contains specific text.


SQL Sentry Performance Advisor Deadlock Graph

SQL Sentry's graphical deadlock analysis provides the most comprehensive view available into SQL Server deadlocks. A graphical representation gives you a snapshot of all processes and resources involved. Host, application, and resource names are resolved in the graph, eliminating the need to translate reference IDs and SPIDs. The deadlock victim is clearly marked in red, and the graph is annotated to not only show lock types, but also the order in which they were applied. You can step right through the deadlock and see exactly how it developed!

 
SQL Sentry Performance Advisor Deadlock Grid
 

The Deadlocks tab also provides you with a Gridview that displays all of the processes and resources involved in the deadlock. The Gridview provides you with more information on what processes were involved in the deadlock including the amount of log space used by the process, the time spent waiting on the resource and state of the process. Just like the graphical view, the deadlock victim is clearly marked in red to make it easy to identify.

 

 

Quick Trace®

 Performance Advisor Quick Trace

Sometimes you need a complete, trace level, unfiltered view of all SQL activity on your server. In addition to long running or high impact queries, you might have very short queries that run hundreds or thousands of times in a short time span. Quick Trace provides a comprehensive view of all activity, similar to Activity Monitor and Profiler, but integrated within one tool. Quick Traces can be fired on demand, or automated based on conditions such as performance thresholds, blocks, or defined schedules.

  • Provides a complete picture of exactly which SQL Server processes are doing work on the server by automatically correlating trace and process activity data together for the first time.
  • Totals are provided for CPU, I/O, network, batches, transactions, cache misses, recompiles, cursor operations, and many other valuable performance metrics.
  • Eliminates continual starting and stopping of Profiler, refreshing Activity Monitor, and tediously correlating and calculating aggregates.
  • Quick Trace® can be fired automatically in response to many different conditions such as "Job: Runtime Threshold Max", so if a problem occurs after hours you’ll always have the full details.
  • Easily sort, filter, or group your metrics to quickly zero in on the data you need.


SQL Sentry Performance Advisor Quick Trace

Quick Trace provides a complete picture of exactly which SQL Server processes are doing work on the server by automatically correlating trace and process activity data together for the first time. Quick Trace provides totals for CPU, I/O, network, batches, transactions, cache misses, recompiles, cursor operations and many other valuable performance metrics. You can even sort, filter, or group your metrics to quickly zero in on the data you need.

 
SQL Sentry Performance Advisor Quick Trace Actions

When you are setting up your alerts, one of the options is to run a quick trace. For every condition, you can have a Quick Trace fired up automatically so if a problem occurs after hours you’ll always have the full details.

 

 

Performance Reporting

   Performance Advisor Performance Reporting

Preformatted reports are available on any metrics SQL Sentry collects, from a global level down to individual counters. You can even report on date range comparisons for trending and baselining of your server's long term performance. Reports can be generated within the SQL Sentry Client, and exported to various formats like Excel, PDF, or Word. You can also use custom reporting to specify any combination of servers, counters, or instances and save them for future use.

  • Powerful SSRS-based performance reporting, including Global Server Status, Wait Stats Analysis, Disk Space, Database File Size, and many more!
  • Custom Reporting:
    • Performance Counter History report lets you report on any combination of servers, performance counters, and instances.
    • Date Range Comparison report lets you compare performance across two different date ranges, using any metrics.
  • Custom reports aren’t limited to only Windows counters - report on data collected from DMVs, WMI, and even internally calculated metrics like Waits by Category!
  • Report on any date range, from 3 minutes to 3 years or longer.
  • Easily save custom reports for future reference.
  • Deploy reports to an SSRS instance, and create subscriptions to auto-email reports for any frequency, including daily, weekly and monthly.
  • Export reports to PDF, Excel, XML, and other formats.
  • New reports include Top SQL, High VLFs, and Misaligned Partitions.


SQL Sentry Performance Advisor Reporting Menu

SQL Sentry offers a lot of powerful SSRS-based performance reports, including Global Server Status, Wait Stats Analysis, Disk Space, Database File Size, and many more. Reports are available in four different categories: Performance, Blocking, Top SQL and Disk/File Space. In the Performance menu, there are preformatted reports for any metric that SQL Sentry collects, from a global level down to individual counters.

 

 

Calendar View*

   Performance Advisor Calendar View

When you integrate Event Manager with Performance Advisor, you get a complete chronological picture of all activity on your servers. Top SQL, blocks, and deadlocks will appear on the Event Manager calendar alongside any SQL Agent jobs, Reporting Services reports and more. Event Manager and Performance Advisor are fully integrated within the SQL Sentry Client, and you can easily switch between views with just a couple of clicks.

  • See Top SQL, Blocking, and Deadlocks on the Outlook-style SQL Sentry Event Manager calendar, alongside SQL Agent jobs and other events.
  • Chronological display of these types of events provides unparalleled insight into how they can impact each other and SQL Server performance which simply can’t be ascertained from grids alone.
  • Quickly jump back and forth between Performance Advisor and Event Manager via context menus and toolbar buttons.
  • Easily see related events in one place, such as a job that executed a long running query that caused a block.
  • All related events will be highlighted on the calendar based on defined criteria, such as SPID, application, login, or more.
  • View SSAS commands on the Event Manager calendar, side-by-side with all other jobs and performance events on a server.*
  • Create custom calendars combining all SQL Server, SSAS, SSIS, and SSRS events for a data warehouse.*
*Requires Performance Advisor for Analysis Services


SQL Sentry Performance Advisor Calendar

The Event Manager calendar displays Top SQL, blocks, and deadlocks alongside any SQL Agent jobs, Reporting Services reports and more. For example, if someone kicks off a long running ad hoc query against the server just before a job’s scheduled execution, and the job runs long as a result, you can easily see the chain of events that led to the performance bottleneck on the server.

 
SQL Sentry Performace Advisor Highlight Menu

You can also easily visualize related events in one place, such as a job that executed a long running query that caused a block. All related events will be highlighted on the calendar based on defined criteria, such as SPID, application, login, or more. You can also add/edit notes on the selected process or you can jump back to Performance Advisor to view the process in the dashboard or other tab.

 

 

View   Reports   in   Client   and   Cloud

Reports

Benefits

Performance Improvement

Make quicker and smarter decisions by viewing SQL Server and Windows performance metrics side-by-side, and easily ascertain the root cause of performance issues.

 

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

Performance Advisor greatly reduces the amount of labor required to 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 noisy, dumb alerts cluttering your inbox?

Read our white paper on the most intelligent alerting in the industry

Articles

July 2014

I Didn't Know It Could Do That

Justin Randall begins a blog series aimed at showing our customers things they might not know about Performance Advisor and Event Manager. In this first post, Justin discusses the “Jump To” Menu, which is a context menu command that allows you to navigate from one element of the client to another while maintaining the time range of the jump off point.

July 2014

Another Way to View Automatic Updates to Statistics

Over on SQLPerformance.com, Erin Stellato of SQLskills.com has a blog series where she looks at different methods that can be used to track automatic updates to statistics. In her first post, she went through 3 options that are available in SQL Server: SQL Trace, Extended Events, and snapshots of sys.dm_db_stats_properties. In this post, she discusses how Plan Explorer and Performance Advisor make it easier to track automatic statistics updates.

June 2014

SQL Server, SharePoint & Windows Alerts: A New Take on Alerting

In this white paper, SQL Server MVP Kevin Kline discusses how the basic alerting system included with SQL Server behaves. He also shows how SQL Sentry's alerting functionality overcomes many of these limitations and those of many other alerting systems. Whether you're currently using a Windows, SharePoint, or SQL Server alerting system that you're very happy with or you're considering acquiring one, it's important to be aware of the potential limitations of that alerting system and then develop strategies to shore up those weaknesses.

April 2014

SQL Sentry v8: Baselines from Every Angle

In my last post I covered the exciting new intelligent alerting features in SQL Sentry v8. Next up in the series is another huge and often requested feature: Baselining. Designing this feature proved to be somewhat of a challenge due to the diversity of opinions on this topic. Seems that everyone has a different idea about baselining – what it is, and how it should be used effectively to improve performance.

April 2014

SQL Sentry Introduces v8 with Intelligent Alerting, Baselining, and Cloud Features

The Power Suite continues its category dominance as the most complete monitoring solution available for SQL Server, with seamless history tracking and the lowest documented server overhead. The new features of v8 fall into three main categories: intelligent performance alerting, flexible performance baselining and cloud access to shared performance data.

March 2014

SQL Sentry v8: Intelligent Alerting Redefined

It's tempting to insert some clever reference to everyone's favorite vegetable juice medley here, but I will refrain, for fear of diminishing what is perhaps the most significant SQL Sentry release to date! In v8 we've addressed the three most frequent requests from our users – performance alerting, baselining, and cloud access – and we've done so in typical SQL Sentry fashion.

September 2013

A Brief Tour of SQL Sentry's "AlwaysOnMonitoring"

"My first impressions are very favorable and I do think this is a useful tool – particularly for environments that have numerous availability groups and higher complexity topologies."

July 2013

SQL Sentry v7.5: A Better AlwaysOn

When we released SQL Sentry v7.2 with dedicated Windows monitoring last October, we were already hard at work on the AlwaysOn-oriented features that would become v7.5. We wanted to be the first to market with integrated, visual AlwaysOn monitoring and management, and I'm happy to say that we've achieved this goal – v7.5 RTM is now available for download!

October 2012

SQL Sentry v7.2 does Windows (and a whole lot more)

Since releasing SQL Sentry v7 with Fragmentation Manager in May, we've been hard at work on v7.2. Development ran concurrently with Plan Explorer PRO, which was released last week. v7.2 includes two exciting new products: Performance Advisor for Windows and Event Manager for Windows. The release candidate was recently published, and you can download it from our customer portal.

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.

SQL Sentry - New in Version 6

SQL Sentry - New in Version 6

SQL Sentry v6 introduces several groundbreaking features like Integrated Execution Plan Capture and Analysis, Top SQL Enhancements, VLF (virtual log file) Info along with many new reports.

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.

Performance Advisor Dashboard

SQL Sentry's Performance Advisor dashboard not only gives you real time performance details on your server, but easily provides long term trending as well as flexible point in time details for all of your SQL Servers.

Watch more Performance Advisor videos at: SQLSentry.TV

Pricing

SQL Sentry Performance Advisor is licensed per individual monitored Microsoft SQL Server 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
Performance Advisor for Windows
$295.00 $59.00
Performance Advisor for SQL Server
$1,495.00 $299.00
SAVE 50% / $4,475 Performance Advisor for SQL Server Quick Start 5-Pack
$4,495.00 included
Performance Advisor for Analysis Services
$2,495.00 $499.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

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 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 on version 8.

* First Name:

* Last Name:

Phone:

* Company Name:

* Email Address:

* Country:

How did you hear about SQL Sentry?


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