Academic Journals Database
Disseminating quality controlled scientific knowledge

Evolution of Database Emerging to Sybase Adaptive Server Enterprise and Ensuring better Server Performance Tuning and Query Optimization

Author(s): Mohammad Ghulam Ali

Journal: International Journal of Computer Applications
ISSN 0975-8887

Volume: 35;
Issue: 1;
Start page: 37;
Date: 2011;
Original page

Keywords: Database | Database Management System | Relational Database Management System | Performance Tuning | Query Processing | Query Optimization

Evolution of the database is emerging to a robust Sybase Adaptive Server Enterprise Database System. Key issue in the Sybase Database System is to obtain better server performance by tuning the server and optimizing the query processing. The server performance tuning and query optimization are two main issues to gain high throughput and less or fast response time. In this paper we have considered well two issues and explained how to gain better server performance by tuning the server and optimizing the query processing. We are also illustrating solutions to some situations normally occurs related to this two issues in this paper. This paper will introduce the reader to the most basic concepts of server performance tuning, query processing and optimization of query processing. We hope this paper will provide an adequate support to Database Administrator's' 'DBAs' who are working on Sybase and researchers who are working on Database Server performance tuning and query optimization. We have discussed in brief in the introduction section of this paper about the evolution of the database emerging to SYBASE ASE version under different operating system environments.
Why do you need a reservation system?      Affiliate Program