App performance

Question

I've many WebAPI calls reading MSSQL Server database and few of these are fetching good chunk of data (close 1MB). And there are 130 + http requests flowing. To improve performance I've used server side caching client side machine & dynamic compression enabled at IIS7 I've load balanced server with good configuration & it's single app running on it. YSlow performance result is grade C. So any advice how to scale performance better despite all these efforts added.

Sumit Jolly · Answer

Thanks for reply! I'm under impression that table indexes are refreshed automatically whenever insert update operation is performed in table. thnx @sumitjolly

Anupam Singh · Answer

I am not sure but you might talking about  UPDATE STATISTICS feature of MSSQL. But actually it is quite different from index rebuilding. You can read this thread : http://social.msdn.microsoft.com/Forums/en-US/08a0b498-2d28-4eba-ab5c-7a14389e104d/rebuild-indexes-and-update-statistics . Apart from it there might be issue with IIS application pool memory recycling. etc

Anupam Singh · Answer

Hi Sumit When was the last time you rebuild or recreate indexes in SQL Server? IF its more then a month or two .I would suggest you to do that.