|
There
is one thing you can count on in BI, analytical 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 information 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.
Back
to top
|
