_____________________________________________________________   iSight - SQL Auditing & Analysis

Increase Performance, Compliance & Productivity   iSight delivers a continuous and comprehensive audit of business intelligence, data warehouse and enterprise reporting environments, enabling companies to understand and optimize how users interact with applications, data and system resources.    iSight's analysis and reporting facility directs application performance tuning, data security compliance auditing, problem query analysis, system resource management, database conversions and capacity planning.   With iSight you have an instant edge: a tactical and strategic roadmap to increase performance, enhance information security and compliance, as well as reduce costs and improve both business and support staff productivity. MetLife "Teleran iSight is our ‘eyes and ears’ to understand and optimize how our business users are leveraging our information." - Bob Sickenger, IT project lead Managing Dynamic Applications Analytical and enterprise applications users are unpredictable, resource intensive and constantly changing. Due to these dynamic usage patterns, ensuring that your business-critical information driven applications perform to expectations and are secure requires continuous SQL auditing and analysis over time.   Fills a Gap That System Level Tools Do Not Address Because iSight uniquely maintains a continuous awareness of not only user behavior and application activity, but also data usage, it fills a gap that database administration and system level performance monitors do not address: understanding and managing applications and users versus monitoring system resources. With iSight, organizations can now "holistically" manage the entire information environment to get the greatest value from their investments in people, information and technology. AberdeenGroup "Managers interested in effectively tuning the entire data warehouse environment at a minimal cost should give Teleran a close look."   Read Teleran Product Review by AberdeenGroup (15KB PDF) Essential regulatory and security compliance Actionable metrics to improve performance & reduce costs Web-based reports deliver iSight value across the organization Continuous usage profiling without consuming database resources Essential Regulatory Compliance Significant demands have been placed on IT organizations by Federal financial reporting transparency regulations such as the Sarbanes-Oxley Act (SOX), and personal health and financial data privacy regulations such as the Health Insurance Portability and Accountability Act (HIPAA), and the Gramm-Leach-Bliley Act (GLBA). These regulations require that organizations must apply appropriate controls to protect the security and integrity of their information and processes. In addition, they must monitor their use of information to document that regulations are followed.   iSight's compliance solution provides a centralized audit facility that can be applied across all SQL applications and databases. Auditing all activity by users, roles, and applications at the database, schema, table, column and row levels, iSight provides a comprehensive solution that automates key compliance requirements for tracking and documenting adherence to regulatory compliance policies.   Actionable Metrics to Improve Performance & Reduce Costs Providing a comprehensive usage auditing application right out of the box, iSight offers a packaged kit of more than 80 customizable reports and analyses presented within the iSight Web Portal.  It delivers key performance indicators, summary and detailed usage reporting organized by issues and roles including IT management, application support staff, DBAs and systems staff. Here are just some of the questions that iSight provides answers to: Regulatory Compliance Auditing - Is data use in compliance with federal regulations such as Sarbanes-Oxley, HIPAA and GLBA? Performance - What reports and queries are long-running and why? At what point during the day does performance begin to degrade? Helpdesk - Who are your problem users? What applications are they using? What are common user errors? Application Management - Do some applications frequently generate inefficient queries? How many BI tool licenses are not being used? Service Levels - Are query times meeting your SLA? Database Tuning - Are joins, indexes and aggregates optimized for actual usage? Availability - What reports slow access for others? Are load-time windows interfering with system use? Maintenance - When can updates occur with least disruption to users?  Query Accuracy - Do some queries produce incorrect results? Information Usage - What information is most used by what users? What data is infrequently or never used? What dormant data can we archive or delete? Chargeback - Are system costs fairly allocated to departments based on actual usage? Sample iSight Report summarizing resource use by user and user group     Corporate Express "iSight application usage reporting provides us with very tangible information that enables us to negotiate more favorable contracts with application vendors and reduce support costs."   Web-Based Reports Deliver iSight Value Across the Organization Users can access iSight information from the office or the road. iSight's personalized, user-defined Report portal enables you to easily share reports across your organization. The iSight Portal provides easy access to usage information in a way that makes sense for the role and key issues of each iSight user: Application Managers & Analysts in each department receive usage profiles to ensure the system is used effectively and user-error reports to identify where user training may be required, or to pinpoint design problems. Watch application managers guide users automatically IT Staff - DBAs and system staff use reports and analyses that focus on potential performance and user problems. These reports give DBAs actionable detail to maintain application availability and quality and inform their use of system-level database administration tools. See how DBAs prevent problem queries & increase availability IT Management - CIOs and IT management receive summarized iSight compliance audit reports identifying which users accessed what information, high-level usage reports that illustrate how analytical applications are being used across the enterprise, and how IT application costs can be reduced. Watch how a VP of Data Warehousing reduced costs Data Warehouse Managers receive summarized performance, resource use and exception reports that assist them in allocating and efficiently managing system and staff resources as well as in budgeting and capacity planning. See how managers improve performance & prioritize access Continuous Usage Profiling Without Consuming Database Resources Database monitoring and administration tools require "in-the-database" agents, traces or monitors that consume up to 30% of database resources. Because of this significant resource consumption, these tools are limited to snapshot or sampling methods of capturing system level data. Teleran’s network-based Access Architecture is the foundation for iSight's continuous usage profiling and management without degrading database or application performance. Unlike resource consuming database monitors, iSight does not require the installation of any performance degrading agents or processes.   The Foundation for Comprehensive Information Management and Protection Sight coupled with iGuard policy-based query controls, Automated Helpdesk user guidance and Service Level Manager performance management offers a complete BI usage management solution that improves IT and user productivity while reducing IT costs.   Back to top