My databases were causing excessive load on the server...So I also know the issues where are in the database but i don't know how to solve that? Is there anybody who can guide me step by step to solve this problem?
There isn't really any blanket method of fixing load issues because it is very dependent on the available resources, the database structure and engine, and the actual load on the website using the database. What exactly in the database is causing the problem. It might be something as simple as query optimization. For high usage databases or for heavy loads, it might require upgrading to better or a dedicated server.