Sql Database Optimization

Last Reply on May 06, 2012 02:22 AM By Mudassar

Posted on May 03, 2012 08:34 AM

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 

 

Posted on May 06, 2012 02:22 AM

There are 2 main drawbacks

1. Too many conditions

2. Dynamic SQL

Both together contributing to low performance as dynamic SQL is compiled on each execution