CS403 Database Management Systems GDB Solution Fall 2012

Suppose you are appointed as a Database Administrator in a well reputed organization. Database in that organization is completely indexed. However, it has been noted that query performance of retrieval operations are good, but “write” operations are creating overhead.
Your task is to improve the performance in the given perspective. There might exist different ways to solve this problem. Discuss the solution with strong arguments.
The performance of the database depends upon the database vendor you are using and the platform on which the database is running. Mainly the database should be checked for deadlocks, blocking session etc. Physical memory and user activity on the server should also be monitored for better performance.