|
Performance Advisor for SQL Server
SQL Sentry Performance Advisor® is a revolutionary new performance monitoring and
tuning tool for
Microsoft SQL Server 2000,
2005 and
2008. The software 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 monitoring or performance tuning software, all designed with the singular goal of simplifying the process of optimizing your SQL Server performance. SQL Sentry 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.
SQL Sentry Performance Advisor utilizes the same management console and collection service as SQL Sentry Event Manager to provide integrated performance monitoring or performance tuning software, all designed with the singular goal of simplifying the process of SQL Server performance monitoring, scheduling, and tuning. 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 monitoring and tuning software.
SQL Sentry Performance Advisor Features
|
SQL Server Performance Dashboard |
-
Monitors and displays the most important Microsoft Windows and SQL Server 2000, 2005 and 2008 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 Microsoft Windows network, CPU and memory charts, so you can monitor exactly how much of your server resources are being consumed by each Microsoft SQL Server instance.
-
Wait Type analysis shows both high-level and detailed resource utilization, giving you an instant profile for the SQL Server so you can monitor exactly which resources or subsystems may be causing slowdowns. Wait types are grouped together into friendly categories, and meaningless wait types are eliminated.
-
SQL Sentry’s Quick Trace™ provides an instant picture of exactly which processes and applications are consuming the most MS SQL Server resources, 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.
|
|
SQL Server Disk Activity
|
|
|
|
Top SQL Analysis
|
-
Software captures all high impact stored procedures, batches and statements.
-
Low-overhead tracing system can safely be run 24/7 without impacting MS SQL 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 MS SQL 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.
-
Improve tuning capabilities by viewing 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 with other software tools using only grid views.
-
Generate email or pager alerts whenever a query exceeds a specific duration, or contains specific text.
|
|
SQL Server Blocking |
|
|
|
SQL Server Deadlocks
|
-
Software provides a 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 of MS SQL Server performance problems.
-
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™ |
-
Tool 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 performance 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.
|
|
Calendar View of Top SQL and Blocking |
-
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 as used in other software tools.
-
Quickly jump back and forth between Performance Advisor and Event Manager via context menus and toolbar buttons.
|
|
SQL Server Disk Space |
|
|
| 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.
| 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. |
|
|
|
|
