Service Level Manager
|
From the publisher website or publicity Automated Process Minimizes the Cost of Meeting Performance and Service Expectations There is one thing you can count on in BI and data warehouse applications - user reports and queries are always changing. These dynamic usage patterns reflect the constantly shifting business environments your analytical applications support. With Teleran Service Level Manager (SLM) you can automatically maintain consistent service levels and performance expectations as user behavior, reporting and query patterns, database structure and system resources change over time. You no longer have to manually track and kill long-running queries. SLM Policies, applied via iGuard query manager, do the work for you. And, because SLM Policies are predictive, inappropriate queries are blocked, or users are warned, before the queries reach the database and degrade application performance and reduce user productivity. Business Intelligence Advisor "If you are looking for an innovative and flexible data warehouse administration and management system, Teleran offers capabilities and features simply not available elsewhere." Curt Hall, Editor Predicts query performance before queries reach the database Learns & adapts automatically to changing system use Advise mode informs users of long-running queries Predicts Query Performance Before Queries Reach the Database Teleran's Service Level Manager uses a patented induction process called Discovery™ that creates and recommends SLM Policies based on periodic analysis of historical patterns of user behavior and system performance. SLM Policies, when activated via the iGuard policy manager, will block queries before they get to the database that are predicted to run over specified elapsed time or result size thresholds that you set. In this way long-running or unconstrained queries are pre-emptively stopped before users' time is wasted and database performance is reduced for all users. Here is an example of a Teleran Automated Helpdesk message associated with an SLM Policy: "This query will run over 3 hours. Please schedule it to run overnight with your query scheduler." Learns & Adapts Automatically to Changing System Use Discovery is an automated learning process - it gets smarter over time as it sees a wider range of queries and system conditions. Periodically evaluating the usage history collected by iSight, Discovery correlates SQL combinations with high resource use and then automatically creates new SLM Policies based on those correlations. Because Discovery works with the patterns of SQL, it does not have to see the same long-running or large result set query to make an accurate prediction on a new query. It will recognize certain characteristics that are similar to what it has seen in the past. A key benefit of SLM Policies is that they automatically maintain service levels and system availability without requiring any additional administrative overhead. Advise Mode Informs Users of Long-Running Queries SLM Advise Mode gives users more information and more control to better manage their work, and when and how to best utilize system resources. Just because some queries run long, does not mean that they are poorly written or inappropriate. Working in conjunction Teleran's Automated Helpdesk messaging system, SLM Policies can operate in Advise Mode, letting users know that their query is predicted to run, for example, over 3 hours. In warn mode, queries are not blocked but users receive a Helpdesk message that warns them that this will be a long-running query. The user can then decide to go ahead and run the query, further constrain the query, or run it overnight via a query scheduler. |
Keywords
Other tools that may interest you by area:-
Vendor: Teleran |
|