Zero Impact Sql Monitor detects HACKER Database Login Failures
Posted in 2000
Zero Impact Sql Monitor detects HACKER Database Login Failures ============================================================== The Zero Impact Sql Monitor from Sql Power Tools automatically alerts organizations to HACKER login failures to database servers. The Zero Impact Service Level Monitor (companion product) pro-actively alerts organizations to database server performance problems. The product identifies poor service levels (end-user response time) to end-users before they contact MIS, DBAs or the Help Desk. These breakthrough industry products monitor 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). 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, does NOT poll the database server or read shared memory 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 Zero Impact Sql Monitor one 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. 4. Reconstruct the SQL for blocked processes that are holding excessive database locks. 5. Automatically alert organizations to HACKER login failures to database servers. With the Zero Impact Service Level Monitor one can: ================================================== 1. Pro-actively identifies poor service levels (end-user response time) to end-users before they contact MIS or the Help Desk. The problem can then be immediately resolved. 2. 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 and application servers by SQL statement or stored procedure. 3. Detect trends in database server service levels at the SQL transaction level. e.g. average end-user response time, average database server response time, average rows returned and more by service level monitoring interval. 4. 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. Pro-actively identifies poor service levels (end-user response time) to end-users before they contact MIS or the Help Desk. The problem can then be immediately resolved. 2. 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! 3. Save your organization an expensive and unnecessary hardware upgrade of the production servers on which the database servers run. 4. Monitor SQL statement performance as database applications (OLTP, WWW, application servers, client server, DSS) are developed and tested. 5. Dramatically reduces time for resolution of database performance issues. Increases productivity of Help desks, Operations Managers, DBAs, System Administrators and Developers. 6. 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. 7. 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. 8. 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. The Zero Impact Sql Monitor and Zero Impact Service Level Monitor products are available for monitoring of DB2, Informix, Microsoft SQL Server, Oracle and Sybase databases. Product evaluations are available, installation is a few minutes. Contact information: =================== info@sqlpower.com www.sqlpower.com Sql Power Tools 702.990.3209