Re: Zero Impact Sql & Service Level Monitor for Oracle

From: Mary Owens <mowens_at_sqlpower.com>
Date: Mon, 18 Oct 1999 09:41:30 -0400
Message-ID: <7uf800$s88$1@bgtnsc01.worldnet.att.net>

The Database SQL and Service Level Monitor with ZERO impact wins!

Sql Power Tools is pleased to announce the availability of the Zero Impact Sql Monitor and Zero Impact Service Level Monitor products for Oracle.

Tired of database monitors that do NOT measure end-user service levels and SQL statement performance in production? (they monitor only high level resources, the cause of about 20% of all database performance problems)

Tired of database monitors that do NOT capture or monitor the performance of what causes 80% of all database server performance problems? (i.e. the end-user SQL statements)

Tired of database monitors that are intrusive, difficult to install, require thousands of dollars in consulting fees to setup, have a high cost of operation and are expensive?

Tired of database monitors that are so intrusive they are not used 24x7 in production environments?

Tired of database monitors that do not scale well when additional users are added or the transaction processing requirements increase?

Then you need the industry break-thru Zero Impact Sql and Service Level Monitors products from Sql Power Tools!

I. Product Overview

The product line non-intrusively analyzes the SQL network packet flow to the database server for end-user SQL statement and service level performance monitoring. The product does NOT have to run on the database server, NOR on client workstations connected to the server.

The products require NO intrusive database server monitors, shared memory polling, agents, probes, audits, middleware or proxy servers. NO agents are installed on end user workstations.

The products require NO impact upon the database servers, network or end-users. The products require no connections to the database server and end-users connect directly to the database server (not the monitor). Product installation is a three step process that can be completed in a few minutes.

II. Product Line

Two products for database monitoring at the end-user SQL level:

'Zero Impact Service Level Monitor' for 24x7 end-user and database server Service Level Monitoring with alerts.
'Zero Impact Sql Monitor' for ZERO impact end-user SQL statement capture, performance monitoring, SQL statement reconstruction and alert notification.

III. Comparison to conventional database monitors

Conventional database monitoring products monitor major resource usage such as cpu, memory, disk space, etc. The cause of about 20% of all performance problems.

They do NOT capture or monitor at the SQL statement level, where 80% of all database server performance problems occur.

Why you ask? Because the monitoring of operating system or database server cpu, memory, disk space, or other metrics is EASY! To monitor with ZERO impact at the end-user SQL statement level is difficult (however allows immediate identification of unacceptable end-user service levels and poor performing SQL).

The real business payoff with database monitoring products is obtained when monitoring occurs at the end-user SQL statement level, not when monitoring high level system resources. Then the cause of production database server performance problems can be immediately pinpointed to specific SQL statements.

IV. Benefits of the Zero Impact Sql Monitoring

and Zero Impact Service Level Monitoring

Finally a database monitoring product is now available that performs what DBAs have always wanted and needed:

End-user service level monitoring with alert notification now possible with ZERO impact upon the database server and end-users.
SQL capture, performance monitoring and alert notification now possible with ZERO impact upon the database server and end-users.
Pinpoints the exact SQL or SQL statement mix causing poor performance. Reconstruction of a service level monitoring interval or end-user SQL is possible by several criteria.
Trending database service level or SQL performance can be immediately detected at the SQL statement level.
Requires NO intrusive database server monitors, agents, probes, audits, middleware or proxy servers. NO agents are installed on end user workstations.
Scales to thousands of users with no required impact upon the database server.
Time for resolution of database performance issues is dramatically reduced. Makes DBAs, System Administrators and Developers more productive.
Product installation is a few minutes. Ongoing cost of ownership is minimal. No need to spend tens of thousands of dollars on product installation, configuration and training.
The Zero Impact Sql Monitor and Zero Impact Service Level Monitoring product may save you an expensive hardware upgrade.
Service Level Monitoring of end-user response time, database server response time and other metrics allows DBAs, Administrators and Help Desks to proactively detect and resolve database performance issues prior to end-user complaints.

info_at_sqlpower.com
www.sqlpower.com

Sql Power Tools
201.825.9511 Received on Mon Oct 18 1999 - 08:41:30 CDT