.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Performance Tuning

Posted By:      Posted Date: September 15, 2010    Points: 0   Category :ASP.Net
Hi all,In my application , I am using many number of farpoint spread control. So the size of the page will be large.So the performance was very low. I have improved that by using update panels and some clientside scripts.while i am going through some articles on net, i found some suggestions as1. To use string.Empty  instead of ""2. To use StringBuilder instead of string.so i tried like ,        string str = string.Empty;        for (int i = 1; i <= 100000; i++)        {            str += string.Empty;        }now i am getting End Raise PostBackEvent 0.00284593221345047 0.001111 when i use,StringBuilder sb = new StringBuilder(string.Empty);        for (int i = 1; i <= 100000; i++)        {            sb.Append(string.Empty);        }the trace was End Raise PostBackEvent 0.00284593221345047 0.002418 .can you please tell me the difference.Also please suggest me some techniques to improve the performance.Thanks

View Complete Post

More Related Resource Links

Performance tuning tips for database developers

Performance tuning is not easy and there aren't any silver bullets, but you can go a surprisingly long way with a few basic guidelines.

In theory, performance tuning is done by a DBA. But in practice, the DBA is not going to have time to scrutinize every change made to a stored procedure. Learning to do basic tuning might save you from reworking code late in the game.

Below is my list of the top 15 things I believe developers should do as a matter of course to tune performance when coding. These are the low hanging fruit of SQL Server performance - they are easy to do and often have a substantial impact. Doing these won't guarantee lightening fast performance, but it won't be slow either.

Performance Tuning on DirectShow Camera Application

Windows CE 6.0 supports DirectShow® components to develop a rich camera application. A minimum requirement of the camera application is to show preview, capturing the still images which is stored as a compressed file (JPG) format, capturing/multiplexing the video with or without audio i.e. stored as a compressed file (WMV) format.

Windows CE 6.0 provides sample applications for showing preview, capturing still and video using DirectShow® components. However these sample applications doesn't cover all the aspects to develop a commercial application. A commercial camera application at least satisfies the following performance criteria.

Thread Diagnostics: Performance Tuning with The Concurrency Visualizer in Visual Studio 2010


Understanding performance bottlenecks in multithreaded apps used to require significant instrumentation and analysis by expert developers. The Concurrency Visualizer in Visual Studio 2010 significantly reduces the burden of parallel performance analysis.

Hazim Shafi

MSDN Magazine March 2010

Event Tracing: Improve Debugging And Performance Tuning With ETW


Event Tracing for Windows (ETW) provides general-purpose, high-speed tracing of events raised by both user-mode applications and kernel-mode device drivers. Learn how ETW can improve your development and debugging work.

Dr. Insung Park and Ricky Buch

MSDN Magazine April 2007

.NET Code Tuning: Make Your Apps Fly with the New Enterprise Performance Tool


Because the common language runtime (CLR) is a black box, it's pretty hard to divine what's going on when you want to track down performance problems. Microsoft will be delivering a brand new profiler, the Enterprise Performance Tool (EPT), as part of Visual Studio 2005 Team Developer Edition that's ideal for use on a production system because it offers some very lightweight means of collecting performance data. Here John Robbins takes you on a tour.

John Robbins

MSDN Magazine December 2004

Can any one give me guide line in performance tuning of sql queries

What are the steps that any one should take for performance tuning in the case of sql-queries ?

wcf performance tuning questions

We have an IIS 7.5 WAS hosted (net.tcp) internal WCF Service.  It is running on a Win2008 X64 R2 server with 8 cores (16 with hyperthreading) and 16gb RAM. The App Pool is set to 16 max worker processes.  We are trying to tune the client / service so that we can run as many worker processes as possible and keep the server as close to 100% CPU utilization as possible.   The client is coded for for 17 concurrent threads / WCF service requests (using .NET 4.0 TPL library).   However, I believe there is some bottleneck going on as the server CPU's never get above 40% utilization and the number of worker processes stays fairly low.  What is the best way to determine where the bottleneck is?  How do you determine if the bottle neck is client side or server side?   What perf counters should I be looking at client side?  What perf counters should I be looking at server side?  Is there a more efficient binding than Net.Tcp?   thanks

Performance tuning > two tables with strings > best query to join them


I have two subqueries which build a string (varchar(200)), first subquery creates 200000 records and second 50000 records, how can I write a select statement to get records from subquery first with string existing in second subquery records.

Will sorting both the sub query results be helpful? Kindly advice for best performing select statement.

partitioned view performance tuning question


There are 20 tables with the same schema. And a view

create view Everything
select 1 as area, pk_col1, pk_col2, col1, col2, ... from T1
union all 
select 2 as area, pk_col1, pk_col2, col1, col2, ... from T2
union all 
select 3 as area, pk_col1, pk_col2, col1, col2, ... from T3
union all 
select 4 as area, pk_col1, pk_col2, col1, col2, ... from T4
union all 
select 5 as area, pk_col1, pk_col2, col1, col2, ... from T5

However, the foll

performance tuning of stored procedures

How do i do performance tuning of stored procedures?
I was browsing the internet and found this link, http://www.sql-server-performance.com/tips/stored_procedures_p1.aspx

but is there any other way like a step by step procedure that i need to follow in order to fine tune the procs?

I heard that we can use sql profiler and database engine tuning advisor, but i don't know how to use those tools for performance tuning of stored procedures?

Would be eagerly waiting for your replies :)


Performance Tuning


1)      What meant by Performance Tuning, how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning?

Doubts on performance tuning



Caught up with few Issues, Advice is highly appreciated:

 We are trying to improve the performance of our query by adding some indexes amd eliminating some unwanted stuff. When I run the old and the new query in o together and check the execution plan, I could see Cost relative to batch, the old query is higher then the new query,I think that is a good sign but what I want to know is how true it is. The reason for asking is I have read it is only estimate and not neccessarily be true. 

 And also , While testing I would like to clear the server cache, I am using dbcc dropcleanbuffers command for that, Does that clear the server cache or is there any other Command?

Is it good to have Clustered index on identity field, it also happens to be the PK of the table.Are there any disadvantages in making identity field as PK and have clustered index on it?


While doing Transactional Replication, if we happen to add a new table at publisher, does that not replicated on to the subscriber unless a snapshot is generated again, if not, is there anyway we can generate the snapshot only for that table and replicate it,because I do not want to generate the snapshot for the entire DB.


ASP.NET Best Practices for High Performance Applications

This article lists the techniques that you can use to maximize the performance of your ASP.NET applications. It provides common issues, design guidelines, and coding tips to build optimal and robust solutions.

Top .NET Performance Problems and how to avoid them

Every time I work with one of our .NET customers to help them with managing their application performance I come across the same problems as seen with other clients before: lots of ADO.NET queries, many hidden exceptions in core or 3rd party .NET libraries, slow 3rd party components, inefficient custom code

High-Performance .NET Application Development & Architecture

It has always been a goal of project architects to plan an effective strategy from the ground up in regards to an new application. All relevant factors are taken into consideration with respect to the application, from its design and layout to a functional website infrastructure. Pre-.NET strategies and design guidelines still effective now were developed with Microsoft's DNA (Distributed interNet Application) platform. This model successfully served the purpose of architecting N(any number of)-Tier (levels) applications. In its basic sense, as in most robust, distributed applications, you'll architect 3 main layers or Tiers: presentation, business rules and data access.

How to improve the performance of ASP.NET MVC web applications

It is an in depth analysis of a Digg-like site and how it went from serving (on a test machine) 6 req/sec to 390 req/sec.

The biggest gain, 74 req/sec to 390 req/sec happened when he introduced data caching and another 25 req/sec where gained when he introduced the compilation of LINQ queries.

High Performance ASP.NET - Speeding Up ASP.NET Pages

have been writing a series of blog posts, which I have named High Performance ASP.NET Websites Made Easy! There is no rhyme or reason to the order of these posts and certainly can be read in any order:

Developing High Performance and Scalable ASP.NET Websites
Avoid Chatty Interfaces Between the Tiers in Your ASP.NET Web Application
ASP.NET Page Profiling - Page Tracing - High Performance and Scalable ASP.NET Websites Made Easy
Web Applications: N-Tier vs. N-Layer - Benefits and Trade-Offs
Query Analyzer - Sql Server Database Indexes and Execution Plans
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend