Sql Database Optimization

Hi Hello,

Recently I posted few threads on asp.net fourms regarding to website performance issues. The webpage is taking around 15-20 seconds to load the web page. I have optimized the code on code behind but it's the same result. I noticed that the problem is not on implementation rather it's on sql database end. I executed the stored procedures on sql database it is taking around 17 seconds. So, the the most of the time is taking at database rather than rendering the web page. So, i need to optimize the database. Is there any article which explains about database optimization ??

Regards

Babu