SQL Stripes Enterprise description
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.