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.
Anupam SinghPosted Jul 28, 2014, 10:52 AM
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,
Guest UserPosted Jul 26, 2014, 1:33 AM
I'm under impression that table indexes are refreshed automatically, whenever insert, update operation is performed in table.
thnx
@sumitjolly
Anupam SinghPosted Jul 25, 2014, 11:17 AM
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.