Home | Savision

Vital Signs for Microsoft SQL Server

Real-time SQL Server Performance Troubleshooting

Data is king. Your company depends on constant and reliable access to its SQL databases. Even the smallest performance degradation can be costly. Manually diagnosing, troubleshooting and resolving SQL Server performance problems is nearly impossible. SQL is complex with many dependencies. Without a real-time view into SQL health, transactions, and logs, IT Pros are left frustrated when trying to resolve SQL Server 2005 problems.

Vital Signs for SQL Server is the answer. With its real-time performance view and informative graphical interface crafted by SQL experts, IT Pros are able to immediately identify performance problems, ran contextual diagnostic tests and resolve problems without ever logging onto the SQL Server.

Proactive SQL Server Management

Vital Signs provides early-warning of potential service disruptions before end-users notice and complain. By coupling historic and real-time SQL Server data, IT pros are able to see impending performance problems up to an hour before end-users are affected.

Real-time SQL Server Performance Data

Vital Signs instantly displays numerous real-time performance graphs that allow IT pros to determine what SQL Server or OS resource is over utilized. Drilling in further to a OS or SQL component, IT pros may remotely run diagnostic tests to see what process or system call is causing the performance degradation.

Intelligent Visibility in One Place

Vital Signs’ real-time performance dashboards present all of the performance graphs necessary to make intelligent troubleshooting and capacity planning decisions. Up to twenty key SQL Server performance indicators are graphed and updated every second.

Self-Learning SQL Server Performance Thresholds

Vital Signs displays what is considered normal SQL performance given the time-of-day, day-of-week, and day-of-month. Vital Signs automatically calibrates thresholds based on past performance thereby eliminating any human guesswork. Threshold alerts visually indicate impending performance problems up to one hour before an outage. 

Embedded SQL Server Expertise

Industry-renowned SQL Server experts helped build this Vital Signs module. Their years of experience solving the toughest SQL problems guarantees that you have the right-data at the right-time to solve difficult SQL performance problems.

Uses Existing Operations Manager Infrastructure

Unlike other performance management tools, Vital Signs uses your existing Operations Manager 2007 infrastructure. This allows you to view real-time performance information without deploying new hardware or ever leaving Operation Manager Console. Vital Signs also provides a full-featured web-based console.

Vital Signs SQL Server Video

Watch Vital Signs for SQL Server in Action

Managing SQL Server has never been easy. There are numerous components that must be tuned based on the application and users connecting to the database. Tracking down SQL Server performance problems is often like looking for a needle in a high-stack – only the needle can disappear as soon as load conditions change. Vital Signs for SQL Server monitors the following performance indicators in real-time:

Vital Signs Screenshots

As an essential extension to Operations Manager 2007, Vital Signs for SQL Server helps you proactively identify impending SQL performance problems, troubleshoot specific SQL problems and optimize system and virtual capacity over-time.

Storage

A graphical view of your SQL Server's storage system including all the database files.

Properties

A complete list of all relevant properties helps you quickly understand the configuration of your SQL server.

Services

A list of all the core SQL server services and their state.

Events

A list or calendar view of all events relevant to your SQL Server. Events are taken from multiple sources, e.g. the local event log, SQL Server logs and management systems like Microsoft Operations Manager and Microsoft Service Manager.

 

This gives you a complete view of what happened to your server.

Jobs

A complete list of database jobs running on your server, their current state and their last outcome, so you can instantly tell if one of your key jobs failed.

Sessions

Ever wondered why your SQL Server was so slow? The always up-to-date list of sessions immediately shows you which sessions are consuming the most resources. The sessions details provide instant insight into the SQL queries that those sessions are running.

Databases

A unified view showing all databases on your SQL server and their state. Key performance indicators for each database are collected and compared against a set of best practices and thresholds. All relevant database details, like data files and database properties can be accessed from the same view.

Key Performance Indicators

A unified view of all key performance indicators of your SQL Server. The built-in calibration system ensures that thresholds relevant for your environment are used. Visual event correlation allows you to pinpoint the root cause of a problem at a glance.

Vital Signs For Microsoft SQL Server

Below you will find the necessary download for getting up and running on Vital Signs for SQL Server. Our products come in both an ISO image and a self-extracting executable. Download the one of your choice.

Download Category