| SQL
Query Result Caching |
Accelerates application response and offloads database
servers, providing an alternative to expensive server
upgrades and database tuning. |
| SQL
Monitoring and Logging |
Offers complete, real-time monitoring of all database
activity, including top-N, slowest, and pending query
statements, and historical usage and response-time analysis.
|
| Service-Level
Management |
Continuous, real-time monitoring of applications and databases,
with configurable service-level thresholds. Email alerts
and logfile updates can be generated when configured service-level
performance thresholds are exceeded. |
| Database
Failover and Load Balancing |
For improved database availability , the dbAppliance can
automatically load balance among database servers and
re-route failed connections to backup databases. |
| Rich,
Flexible Reports |
dbAppliance performance data may be filtered by server,
database, user or client. A large suite of reports is
provided via Teraview, the dbAppliance user interface,
as well as the ability to easily create fully customized
reports. |
| Performance
Data Archival |
Performance data collected by the dbAppliance can be archived
to an external database for long-term storage and for
trend reporting. |
| Response-time
Analysis |
Gives direct insight into end-user experience and usage
patterns, eliminating guesswork associated with relying
on only indirect performance parameters, such as server
resource statistics. |
| Table
and Column Usage |
Enables administrators to devise optimum archival, indexing,
and normalization strategies. |
| Visual
Monitoring Tools |
Maps and historical graphs provide at-a-glance monitoring
of current and historical usage and performance. |
| Network-based,
Zero-overhead |
Performance solutions shouldn't hurt performance. The
dbAppliance imposes no loading on servers and requires
no software installation or code changes. |
