iSight – Comprehensive, Actionable Metrics to Manage Your BI and Data Warehouse Environments
iSight empowers information, application and data warehouse management and staff to gain visibility on how all users and applications are interacting with the data. The goal: to quickly pinpoint performance issues, compliance concerns, user problems, and application inefficiencies that get in the way of IT delivering what the business expects.
Because iSight focuses on users and applications as well as database activity, it highlights problems in the overall environment not visible via database-only oriented utilities or application specific monitors. iSight employs network-based usage capture methods that do not put any overhead on the database or introduce transaction latency.
In BI and data warehouse environments almost every transaction is different. You can’t just periodically sample database activity and get a useful picture of what’s happening in order to manage performance or thoroughly audit for compliance. iSight captures each and every transaction continuously across key dimensions of analytical, BI and data warehouse environments.
These dimensions include:
• Who the actual application users are
• The users’ organizational context
• BI applications used
• Specific BI semantic layers used
• BI report names
• SQL queries launched by the application including DML such as inserts, updates and deletes
• Data objects accessed
• Query performance and result set metrics