Re: Sql Loopback Monitor $799 introductory offer
Posted in 1999
Sql Loopback Monitor and Service Level Loopback Monitor for Solaris and AIX =========================================================================== Sql Power Tools is pleased to announce the release of the Sql Loopback Monitor and Service Level Loopback Monitor products. The products are companion products to the Zero Impact Sql Monitor and Zero Impact Service Level Monitor. This breakthrough industry product line monitors what causes 80% of all database server performance problems (i.e. the end-user SQL transactions). Other database monitor product offerings typically monitor only the high level resources of production database servers (i.e. the cause of only 20% of all database performance problems). Sql Loopback Monitor product is essential to monitoring SQL statement performance for batch processes, WWW servers, three tiered architectures, application servers and telnet sessions that run on the same platform as the database server. These SQL transactions are not sent over the network and consequently cannot be monitored by the Zero Impact Sql Monitor or Zero Impact Service Level Monitor. The product line requires NO intrusive middleware, has NO connections to the database server and application clients (end users, batch programs, WWW servers, application servers, etc.) connect directly to the database server. Product line does NOT connect to the database server, does NOT query the database server and does NOT poll the database server for SQL performance statistics! NOTE: Database monitors that connect to the database server, read the database server shared memory, poll the database server, are middleware based, etc. -- may have such a significant performance impact on production database servers (use to much CPU time, memory and I/O), that they cannot be used 24x7 or for any extended time period to monitor production database servers. i.e. they negatively impact the performance of the database server, increase end user response times, and effect service levels. With the Sql Loopback Monitor you can: ===================================== 1. Monitor performance 24 hours a day, seven days a week in order to be alerted to batch process, WWW server, application server and telnet sessions with poor SQL statement performance. 2. Pinpoint the exact SQL or SQL transaction mix causing poor performance. 3. Reconstruct or filter SQL statements or a SQL statement mix by time period, run time, rows returned, key words in the SQL text (i.e. by SQL operation, table name, column name, stored procedure name), login id and much more -- by batch process, WWW server or application server. With the Service Level Loopback Monitor you can: =============================================== 1. Monitor service levels (end user and database server response time) 24 hours a day, seven days a week in order to receive alert notification of batch processes, WWW servers, application servers and telnet sessions by SQL statement or stored procedure. 2. Detect trends in database server service levels at the SQL transaction level. e.g. average database server response time, average total SQL statement run time, average rows returned and more by service level monitoring interval. 3. Obtain database server service levels by server, database, login id, application, SQL operation, table or column name references, stored procedure execution and more. Product benefits: ================ 1. Save your organization an expensive and unnecessary hardware upgrade of the production servers on which the database servers run. 2. Monitor SQL statement performance as database applications (OLTP, WWW, application servers, client server, DSS) are developed and tested. 3. Dramatically reduces time for resolution of database performance issues. Increases productivity of Help desks, Operations Managers, DBAs, System Administrators and Developers. 4. Service Level Monitoring of total 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. 5. Service Level Monitoring of total response time, database server response time and other metrics allows proactive resolution of database server performance problems prior to end-user complaints or degrading system performance. e.g. poor database performance due to disk space fragmentation, skewed distribution statistics, outdated distribution statistics, increased transaction loads, poor performing SQL statements, blocked SQL transactions as well as many other performance issues. 6. Allows the IT organization to proactively resolve database performance problems prior to end-user or performance complaints, instead of reactively responding to performance problems after they are visible to the end-users. 7. Products monitor 80% of the causes of poor database performance, and are not limited, as other database monitors are, to monitoring only 20% of the causes of performance issues. Furthermore, the products are available at a license cost well below overpriced conventional database monitoring products! The Sql Loopback Monitor or Service Level Loopback Monitor products require licenses to the Zero Impact Sql Monitor and Zero Impact Service Level Monitor products. The Sql Loopback Monitor and Service Level Loopback Monitor products are available on AIX and Solaris for monitoring of Informix, Microsoft SQL Server, Oracle and Sybase databases. Product evaluations are available. Contact information: =================== info@sqlpower.com www.sqlpower.com Sql Power Tools The Development Group for Advanced Technology, Inc. 201.825.9511