SQL Stripes Enterprise

SQL Stripes Enterprise is a complete, robust, fully scalable SQL Server online monitoring & alerting solution SQL Stripes is an application that helps you, the SQL Server DBA, having complete control over your various SQL servers.

From the high-level of monitoring essential components - to the low-level of analyzing your various databases, tables, users, processes, logs and much more... (see more at the full feature list)

This is *not* another Query-Analyzer like tool, nor does it intend to be. The main concept of SQL Stripes is that each server gets a 'Stripe' (see image below) which contains valuable real-time data on the Server.
SQL Stripes is an intuitive and easy to use application, which is intended to make your DBA life much easier.

On a high level, SQL Stripes can automate many of your daily tasks as a DBA and alert you if anything goes wrong.
It is being developed by a DBA and therefore provides solution to the real day to day problems that (I) DBAs come across.

Here are some key features of "SQL Stripes Enterprise":

All-In-One SQL Server Monitor & Control

Support SQL Server 7, 2000, 2005 (Yukon)

Unlimited multiple server connections

Requires only SQL Connection to the selected servers. (no network shares etc...)

Stripes (tm) - Contains the following information:

Ping Result / Latency

SQL Service Result (Up, Down or Up with invalid Login)

SQL Agent Status

SQL Jobs Status

Ram Status

Server name on the Network (i.e. Network ID)

Used/Free Hard disk space

Can be used for All drives or only drives that are being used by Databases

SQL Server Version detection

Ability to Stop/Start SQL Server & Agent Services

Extended Server Information :

Collation

Default Domain/Logins

Installation information

Version / CSD Version

Linked Servers

Databases

OS Memory

Number of CPUs

Extended Database Information / Properties:

Database Name / Owner

Database Size Graphs (Bar/Pie, 2D/3D)

Database Total/Used/Free Space

Database State (online, offline etc...)

Database Creation Date

Database Status

Backup / Maintenance Status

SQL Error Log

Database Files (Logical/Physical)

List & View Objects:

Tables (List, Viewer, Editor)

Views (Source, Result)

Stored Procedures

Functions

Triggers

Users

Dependencies

Database Processes

DBCC Check: - Simple, Extended.

Alerts:

What can be alerted:

Ping Status

SQL Service

SQL Agent

Low Disk Space

Failed Jobs

Alerting Methods:

Email Alert

Sound Alert

Visual Alert

Automatic HTML Report Generator - allows realtime online status.

Remote Connection Support:

Terminal Services

Remote Desktop

pcAnywhere

VNC

SQL CMD Emulator (tm):

Gives you the ability to run commands as if you are opening a CMD window on the SQL Machine

Get/Put Commands are supported inside CMD through 3rd side FTP Server

System Tray Support:

Can be minimized to system tray automatically & upon request

Ballon Tip Support

Indicates Monitoring results on System Tray Icon

Can initiate test from Tray Icon

More:

Integration with SQL Query Analyzer

Integration with SQL Management Studio (2005)

Integration with SQL Profiler

Integration to Enterprise Manager

Built-in Object Viewer (Tables, Views,

Dynamic Setup Screen

Automated startup

Auto Start command line options

Linked Server Support; this allows you to communicate with one SQL Server using another.

Most displayed data can be exported to Excel/XML

Multiple Object Search


Requirements:

MDAC 2.7


Limitations:

15 days trial.