| Topic : Automating Database Deployment |
|
|
Database Administration
|
||
|
Source : http://www.ciol.com
Activity:
1 comments
264 views
last activity : 07 06 2010 20:18:04 +0000
|
||
|
|
The DBA can tune and improve the performance of a database by using such tools. The performance-monitoring tool helps a DBA gauge the efficiency and responsiveness of SQL queries, system parameters and database structures. Such performance monitoring tools run in the background and maintain a log of the database performance statistics and alert the DBA on occurrence of any problem. Some advanced tools can also take proactive steps to counter the problem so that database performance is not hindered at all.
The performance enhancement tools should monitor three aspects of a database application, which are database structure, the system itself and the application. These tools help manage the system resources perform optimally, while allowing you to analyze and optimize queries and run applications at top speed.
On a day-to-day basis a DBA requires some administration tools that help him in simplifying the tasks ranging from database object creation to database synchronization. In the absence of such administrative tools, the DBA would be required to write complex scripts for such intricate tasks that would consume time and would sometimes be error-prone too. Such administrative tools help DBA by automating some of the complex tasks and also help him in saving time.
Most of the DBMS applications provide basic backup and recovery features. However, these can't satiate the requirements of a DBA. He needs tools that can automate processes of backup and recovery and can also implement procedures for disaster recovery. The recovery tools help the DBA in such tasks. Some advanced recovery tools are also available that examine the database logs and then perform online SQL-based recoveries of the crashed or corrupted databases.
Adoption of such tools by DBAs that have automation capabilities, results in great improvement of the data availability and integrity, and hence improved performance of the database.
- Create a confidential Career Profile and Resume/C.V. online
- Get advice for planning their career and for marketing of experience and skills
- Maximize awareness of and access to the best career opportunities
|
|
women only have an adjusting type to handle the administration vs Man can able take correct... |
|
|
1639 referals
24 arguments,
315 views
|
|
|
It is just a two-letter word, but not a dirty one. It is the simplest thing to say, yet we... |
|
|
0 referals
15 comments,
666 views
|
|
|
Today everybody is running for an MBA. But can an MBA make a better manager? After engineering... |
|
|
1105 referals
63 arguments,
2490 views
|
|
|
|
|
|
|
|
|
A Sufi Story Once upon a time, a fox that lost its legs lived in a forest. A forester who used... |
|
|
294 referals
8 comments,
168 views
|
|
|
Yes they are going to be here.. and the first destination is Bangalore... Google cars and trikes... |
|
|
1339 referals
12 comments,
443 views
|
|
|
Successful Project Managers - Characteristics and Skills What are the Characteristics of... |
|
|
203 referals
14 comments,
11875 views
|
|
|
This is really good and this sort of initiative should happen across the country, and as Suvrajit has put it will narrow the gap between the current education system which is really not in sync with the current industry standards. Really good... |
I m agree wit you yhat we have to go for grass roots marketing to stand in the market. |
Devarajan , i completely agree with you that giving back to your loyal customer is really important,as they are the one whom we have to retain with us. |