|
Performance Advisor for SQL Server
SQL Sentry Performance Advisor is a revolutionary new performance monitoring and
tuning tool which provides unparalleled insight, awareness and control over the true source of SQL Server performance issues.
Performance Advisor is packed with ground-breaking new features that aren’t found in any other
performance monitor or performance tuning software, all designed with the singular goal of simplifying the process of optimizing your SQL Server performance. Performance Advisor represents over two years of research and development by the same team that brought you the innovative, award-winning
SQL Sentry Event Manager.
Performance Advisor utilizes the same management console and collection service as SQL Sentry Event Manager. This provides a variety of benefits including a single unified installation package and setup process, streamlined configuration, and integrated features such as the ability to view performance events like blocking and deadlocks on the SQL Sentry calendar.
Review the features below to find why SQL Sentry Performance Advisor is
the ultimate SQL Server performance monitor and tuning software.
SQL Sentry Performance Advisor Features
Performance Dashboard
-
Shows the most important Windows and SQL Server performance metrics side-by-side in a single view, so you have the full picture at a glance.
-
Easily switch between real-time and historical modes to view performance metrics for any point in time. Go back days or even months to see exactly how your SQL Server performance has changed over time.
-
SQL Server resource utilization is integrated into the Windows network, CPU and memory charts, so you can see exactly how much of your server resources are being consumed by each SQL Server instance.
-
See Top SQL, 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 can impact each other which simply can’t be ascertained from a grid.
-
Wait Type analysis 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 friendly categories, and meaningless wait types are eliminated.
-
Quick Trace™ provides an instant picture of exactly which processes and applications are consuming the most resources on the SQL Server, without having to open Profiler or Activity Monitor and manually correlate the results.
-
The Windows Process Activity viewer shows CPU, paging, and other I/O metrics on a server with a single-click, showing you exactly which Windows processes are consuming the most resources, without having to fire up PerfMon or remote into a machine simply to open Task Manager.
-
Network utilization is displayed by SQL Server instance and by network adapter.
-
Disk latency charts show you exactly how long reads and writes are taking for each disk and each database file, quickly highlighting disk bottlenecks.
Disk Activity
-
Revolutionary, patent-pending graphical view of your server’s disk topology and activity.
-
Shows you exactly how data is moving through your disk system, highlighting bottlenecks at the database file, physical disk, or controller level.
-
View disk activity in real-time mode, or historical mode for any date range.
-
Easily identify common configuration problems such as mixing busy data and transaction logs files on the same physical drive.
Disk Space
-
Graphical display of disk space utilization by database and file.
-
Easily identify disk capacity issues and understand where various database files reside on the disk system.
Top SQL Analysis
-
Captures all high impact stored procedures, batches and statements.
-
Low-overhead tracing system can safely be run 24/7 without impacting server 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 server performance.
-
Drill into individual query executions to quickly isolate problems with particular parameter values.
-
Runtime graphs show how a particular query has been trending over time.
-
View Top SQL on the SQL Sentry calendar, alongside jobs and other events. For the first time you can visualize complex scenarios involving resource contention between queries that simply can’t be ascertained using a list view.
-
Generate email or pager alerts whenever a query exceeds a specific duration, or contains specific text.
Blocking
-
Hierarchical display of all blocking chains provides the most complete picture of blocks available.
-
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!
-
Blocks are displayed on the SQL Sentry calendar alongside other events.
-
Generate email and pager alerts with full block chain details whenever a block occurs, when a block exceeds a specific duration, or when a blocking query contain specific text.
Deadlocks
-
Graphical display of all 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 SQL for all nodes!
-
Unlike other deadlock graphing tools, deadlock nodes contain the concise information you need to quickly visualize the deadlock and determine the root cause.
-
Deadlocks are displayed on the SQL Sentry calendar alongside other events.
-
Generate email and pager alerts including the deadlock victim SQL whenever a deadlock occurs, or when the victim query contains specific text.
Quick Trace
-
Provides a complete picture of exactly which 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 SQL Server metrics.
-
Eliminates continual starting and stopping of Profiler and 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.
Pricing
SQL Sentry Performance Advisor is licensed per individual monitored 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.
| SQL Sentry Performance Advisor |
|
|
| Individual Licenses *1 |
License Fee |
Maintenance Fee |
| Microsoft SQL Server |
$1,495 |
$299 |
| Quick Start Pack *2 |
|
|
| SQL Server Quick Start 5 Pack |
$4,495 |
$0 |
*1 The first year annual software maintenance is required with license purchase.
*2 The first year annual software maintenance is included in the Quick Start Pack. |
|
|
|
|
