Performance Tuning Asp.Net / Sql Server

There are many things that we need to take care of when boosting ASP.NET performancehere are some points to be note- Disable IIS ASP debugging - clean up unmanaged resources- Reducing page load time- Set debug=false in web.config- Use StringBuilder to concatenate strings- Use Client-side Scripts for validations- Use Page.ISPostBack method to avoid code duplication- Do Minification Additionally you can use IIS features to improve application performance, I have written an article on it, check below link, http://www.dotnetspider.com/resources/45582-Improve-your-web-application-performance-with-IIS-7.aspxThanksKoolprasd2003Editor, DotNetSpider MVMMicrosoft MVP 2014 [ASP.NET/IIS]

While Implement any application we need to concentrate performance also. To improve performance we need to concentrate on several factors. I will share you few of those.

DataBase Wise:

1) Proper indexes in a table2) Use Proper relationships between tables.3) while querying try to avoid unnecessary fields, instead of * use respective fields (columns).4) Try to avoid aggregate functions and Grouping clauses.5) Instead of temporary tables use CTE.6) Use proper joins, and try to avoid nested queries7) While joining first call master table then child table, because master table contains limited records while searching its look at limited records.

Application Wise:

1) try to avoid unnecessary code blocks2) Avoid to load all the records while loading time, instead of that load based on filter.3) Unnecessary don't use nested looping and looping, if it's required then only use.4) Always use light weight controls.5) Try to reuse code blocks, instead of create new.

Apart from the above you need to look at Server, RAM, Hard disk etc...--------------------------------------------------------------------------------Give respect to your work, Instead of trying to impress your boss.