Re: Consultants - FREE Zero Impact Sql & Service Level Monitor

    Does your product work with Sybase IQ 12.4 (our Data Warehouse database server)? We are in the process of evaluating product like your product. At the moment only Teleran (iSight, iGuard) seams to work with IQ.

Thanks a lot.

Gino Santerre
Entrepôt de données - QuébecTel
http://www.quebectel.qc.ca

In article <8gcd21$r81$1_at_slb0.atl.mindspring.net>,   "Mary Owens" <mowens_at_sqlpower.com> wrote:
> Consultants - FREE Zero Impact Sql & Service Level Monitor
> ==========================================================
>
> The database and service level monitor with ZERO impact wins!
>
> Consultants build your SQL performance, tuning and service level
 consulting
> practices with the Zero Impact Sql and Service Level Monitoring
 products.
> Sql Power Tools, Inc. is a product based company and rarely if ever
> provides consulting services. Consultants are under NO obligation to
> recommend the product line to your customer base.
>
> Sql Power Tools will give Consultants a free copy of the industry
> breakthrough
> Zero Impact Sql Monitor and Zero Impact Service Level Monitor
 products!
> Excellent for monitoring with ZERO impact - database servers having
 50 to
> 10,000+
> users and processing 50 to 10,000+ SQL transactions per second.
>
> Zero Impact Sql Monitor and Zero Impact Service Level Monitor
 products are
> available for DB2, Informix, Microsoft, Oracle and Sybase.
>
> You may install the products on a laptop (takes a few minutes) and
 build
> your SQL performance, tuning and service level consulting practices.
 Once
> installed on a laptop, simply plug the laptop into a client's network
 and
> you will be IMMEDIATELY capturing and monitoring:
>
> 1. All or any subset of the SQL statements (with their performance)
 sent
> to the database server 24x7 with the Zero Impact Sql Monitor. Plus
> filter or reconstruct the SQL statements from any prior time
 period.
>
> Real-time alerts pinpoint poor performing production SQL.
>
> Reconstructs all Transact-SQL batches involved in a deadlock or
 blocked
> process for a transaction.
>
> 2. Average end user response time, average database server response
> time, average network send and receive time plus other important
> Service Level metrics by monitoring interval with the
> Zero Impact Service Level Monitor. Product allows detection of
> trending poor database performance prior to end-users contacting
> the Help Desk, DBAs or Administrators. Real-time alerts pinpoint
> monitoring intervals with poor database server or end user
 performance.
>
> Refer to the following section 'IV. What can you do with the product
 line?'.
>
> I. Product overview:
> ===================
>
> The products scale to thousands of users and 1000+ transactions per
> second with no impact upon the database server, network or end users.
> Perfect for production, OLTP, WWW, eCommerce, 3-Tier, DSS, test, and
> SQL development database monitoring.
>
> Product line requires no connection to the database server, nor are
> agents installed on the server or client workstations. No software is
> installed upon the customer's server, network or client workstations.
> Requires no installation of performance impacting database monitors,
> probes, traces or database audits. Requires no intrusive middleware,
> gateways or proxy servers that impact the performance of end user
> SQL transactions.
>
> Product installation on a laptop is a three step process that takes
> a few minutes. Product GUI is intuitive and a snap to learn (no
> customer has required a class on product usage todate!) We will
> give you complete product support at no charge.
>
> II. How the product works:
> =========================
>
> The product line non-intrusively analyzes the SQL network packet
> flow to the database server for end-user SQL and service level
> performance monitoring. In the SQL network packets are the SQL
> statements, results, error messages, show plans, I/O statistics
> and more. SQL statement performance is obtained from real-time
> network packet time stamps provided by the network adapter.
>
> Install the product on your laptop (takes a few minutes), then
> plug the laptop into a client's network (client does NOT need to
> assign you an IP address) and you will be IMMEDIATELY capturing
> and monitoring database server performance. The laptop needs
> to be connected to the network on the same subnet or switch
> as the database server. Then our product can non-intrusively
> view and analyze the SQL packet flow to the database server.
>
> Product is available for 95, 98, NT, AIX, HP-UX and Solaris
> laptops. From any laptop a database server on any other
> platform type can be monitored (e.g. Linux, SCO Unix, Sequent,
> DEC, etc.).
>
> III. Competitive monitoring approaches:
> ======================================
>
> Other industry database monitoring approaches are less than
> satisfactory due to the following issues:
>
> 1. They do NOT capture or monitor 24x7 what causes 80% of all database
> server production performance problems (end-user SQL transactions).
> They monitor high level resources, the cause of about
> 20% of all database performance problems.
>
> 2. They do NOT monitor end-user or database server response time
> (service levels) at the SQL statement level for predictive
> identification of pending performance problems.
>
> (e.g. poor database performance caused by disk space fragmentation,
> skewed distribution statistics, outdated distribution statistics,
> increased transaction loads, poor performing SQL statements,
> blocked SQL transactions as well as other performance issues)
>
> 3. They are intrusive, difficult/expensive to install and setup,
> have a high cost of operation and are usually quite expensive.
>
> 4. They are so intrusive they may not be used 24x7 in production
> environments. i.e. they may only be used in development and
> test environments, not in production where SQL performance
> plus end user service level measurement is critical to success.
>
> 5. Other database monitors may not scale well when additional users
> are added or transaction processing requirements increase.
>
> 6. Other database monitors that do not measure Service Levels such
> as end-user response time, database server response time, network
> time and other metrics which allows DBAs, Administrators and Help
> Desks to proactively detect and resolve database performance issues
> prior to end user complaints.
>
> 7. Rejected database server login attempts are not monitored.
 Important
> for E-Commerce, WWW and web based end-user database access.
>
> The real business payoff with database monitoring products is
> obtained when monitoring occurs at the end-user SQL transaction
> level, not when monitoring high level system resources (NT and UNIX
> allow availability, cpu utilization, I/O, memory, etc. to be easily
> monitored). Then the cause of production database server performance
> problems can be immediately pinpointed to specific SQL transactions.
> Plus service level monitoring proactively alerts DBAs, Administrators
> and Help Desks trending performance issues.
>
> IV. What can you do with the product line?
> =========================================
>
> Build your SQL performance, tuning and database service level
> consulting practices. Assist your clients in pinpointing and
> resolving problematic SQL performance in production environments
> (a great service to your client and generates significant
> consulting revenues).
>
> Assist your clients is setting up 24x7 service level management
> programs for DBAs, Administrators and Help Desks. You may save
> your client an expensive hardware upgrade!
>
> From your laptop use the Zero Impact Sql Monitor and Zero Impact
> Service Level Monitor products to:
>
> 1. SQL capture (all or any subset) and performance monitoring in
> real-time or with offline SQL statement filtering. SQL
> statements can be pinpointed by end user response time, database
> server response time, network time, rows returned, login id,
> application group, host group, database, server, client IP
> address, pid, errors, and key words in SQL statement text.
>
> 2. SQL can be reconstructed by time periods by: end user
> response time, database server response time, network time,
> rows returned, login id, application group, host group, database,
> server, client IP address, pid, errors, and key words in SQL
> statement text.
>
> 3. Alert notification in real-time or offline to poor performing
> SQL or stored procedures.
>
> 4. View SQL currently in progress at the database server. SQL
> can be filtered by run time.
>
> 5. Obtain real-time service level metrics at the SQL statement
> level. Average end user response time, average database server
> response time, average network send and receive time plus other
> important Service Level metrics are available by user selectable
> monitoring interval.
>
> 6. Obtain the service levels 24x7 by stored procedure execution,
> SQL statement type, table usage or column usage for a monitoring
> interval (e.g. 30 seconds).
>
> 7. Proactively detect and resolve database performance issues
> prior to end-user complaints. e.g. trending average end user
> response time, database server response time, rows returned or
> network times are important service levels to take action upon
> prior to end user complaints.
>
> 8. Monitor the cause of 80% of database server performance problems,
> i.e. SQL statement and end user response time performance.
>
> 9. Position your consulting practice to gain a competitive advantage
> over your competitors! How? Easy, with these products one can
> pinpoint SQL statement performance problems due to individual
> poor performing SQL statements or groups of SQL statements
> collectively causing unnecessary hardware upgrades and poor end
> user service levels.
>
> 10. Make your clients day! If they have just spent (or are about
> to spend) BIG BUCKS on competitive database monitors and
> consulting services that CANNOT pinpoint the SQL statements
> causing poor database performance, or proactively identify
> pending end user poor response times (i.e. service levels),
> or allow complete reconstruction of the SQL causing poor
> performance, or are to intrusive to run in production
> environments, -- then you can immediately provide
> consulting services with an outstanding ROI!
>
> V. How do you join the Consultant Partnership Program?
> =====================================================
>
> Simply email Sql Power Tools at consultant_at_sqlpower.com. We will
> email you Consultant Partnership Program Application that can
> be completed in a few minutes. Program qualification is a SNAP
> and there is no charge. All product software and licenses are
> distributed via the Internet.
>
> Sql Power Tools
> www.sqlpower.com
> Copyright 2000. All rights reserved.
>
> 702.990.3209
> consultant_at_sqlpower.com
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue May 23 2000 - 00:00:00 CDT