Database Performance Monitoring and Tuning Using Intelligent Agent Assistants
نویسندگان
چکیده
Fast databases are a necessity in today’s Ecommerce environment. Information from the database has to be provided at fast rates to impatient customers, otherwise they will move on to competitors with more attentive services. Corporations needing up-to-date internal information cannot wait for long running queries that process numbers and produce detailed statistics. Instead, they need databases capable of providing data in fractions of seconds to compete in today’s economy. Database performance tuning has always been one of the most important tasks for database administrators (DBAs). This research presents an intelligent agent assistant to aid DBAs in performance monitoring tasks and the automation of resolution actions. The assistant notifies DBAs when performance problems are detected and resolved. DBAs are expected to provide the agent assistant with definitions for the performance problem conditions and the possible resolution actions. They must also develop a notification communication mechanism for the problems the assistant agent monitors.
منابع مشابه
Where Are My Intelligent Assistant's Mistakes? A Systematic Testing Approach
Intelligent assistants are handling increasingly critical tasks, but until now, end users have had no way to systematically assess where their assistants make mistakes. For some intelligent assistants, this is a serious problem: if the assistant is doing work that is important, such as assisting with qualitative research or monitoring an elderly parent’s safety, the user may pay a high cost for...
متن کاملAn active and intelligent network management system with ontology-based and multi-agent techniques
This paper presents a system to collect information through the cooperation of intelligent agent software, in addition to providing warnings after analysis to monitor and predict some possible error indications among controlled objects in the network. This technique derived from the ontology combining Ethereal and Cacti, which store the operating information of network management perfectly into...
متن کاملOffline Auto-Tuning of a PID Controller Using Extended Classifier System (XCS) Algorithm
Proportional + Integral + Derivative (PID) controllers are widely used in engineering applications such that more than half of the industrial controllers are PID controllers. There are many methods for tuning the PID parameters in the literature. In this paper an intelligent technique based on eXtended Classifier System (XCS) is presented to tune the PID controller parameters. The PID controlle...
متن کاملSustainable Supplier Selection by a New Hybrid Support Vector-model based on the Cuckoo Optimization Algorithm
For assessing and selecting sustainable suppliers, this study considers a triple-bottom-line approach, including profit, people and planet, and regards business operations, environmental effects along with social responsibilities of the suppliers. Diverse metrics are acquainted with measure execution in these three issues. This study builds up a new hybrid intelligent model, namely COA-LS-SVM, ...
متن کاملIntelligent Monitoring of Elderly People
The aim of this article is to present our proposal for an intelligent monitoring of elderly people based on: the agent technology, a decision support system implemented using a description logic based system and Personal Digital Assistants (PDAs). Agents technology allows us to customize the monitoring service and to distribute the global functionality of the system among several agents. We use...
متن کامل