examples of idioms Tracing in asp.net A real time example Part 81

Text version of the video
http://csharp-video-tutorials.blogspo...

Slides
http://csharp-video-tutorials.blogspo...

All ASP .NET Text Articles
http://csharp-video-tutorials.blogspo...

All ASP .NET Slides
http://csharp-video-tutorials.blogspo...

All Dot Net and SQL Server Tutorials in English
https://www.youtube.com/user/kudvenka...

All Dot Net and SQL Server Tutorials in Arabic
https://www.youtube.com/c/KudvenkatAr...

ASP.NET Page is very slow. What will you do to make it fast?
This is a very common interview question. There are several reasons for the page being slow. We need to identify the cause.

We cannot debug an application on the production server, as we will usually, not have visual studio installed, and as the code is optimized for release builds.

1. First find out which is slow, is it the application or the database : If the page is executing SQL queries or stored procedures, run those on the database and check how long do they take to run. Alternatively, SQL profiler, can be used, to inspect the queries and the time they take. If the queries are taking most of the time, then you know you have to tune the queries for better performance. To tune the queries, there are several ways and I have listed some of them below. a) Check if there are indexes to help the query b) Select only the required columns, avoid Select *. c) Check if there is a possibility to reduce the number of joins d) If possible use NO LOCK on your select statements e) Check if there are cursors and if you can replace them with joins

2. If the queries are running fast, then we know it is the application code that is causing the slowness. Isolate the page event that is causing the issue by turning tracing on. To turn tracing on, set Trace="true" in the page directive. Once you have tracing turned on you should see trace information at the bottom of the page or in trace.axd file. From the trace information, it should be clear to identify the piece of code that is taking the maximum time.

Set Trace=true, in Page directive

Many a times, the issue is not reproducible on the development environment. The issue happens only on the production server. In this case tracing is an invaluable mechanism to get to the root cause of the issue.

examples of idioms Tracing in asp.net A real time example Part 81
191 Likes	191 Dislikes
51,672 views views	524K followers
Education	Upload TimePublished on 11 Dec 2012

Related keywords

asp.net core docker,wcf vs web api,real time data,ado.net core,sql server management studio,webkinz,webadvisor,craigslist nj,wcf one piece,real time clock,tracking container,asp.net core 3,ajax players,examples of personification,weber grill parts,webtoon,tutorials by hugo,csharp corner,mvc design pattern,asp.net machine account,servers for minecraft,asp.net core dependency injection,ado.net tutorial,services angular,real time instagram,ajax ontario,example resume,asp.net mvc tutorial,examples of alliteration,asp.net cos'è,csharp assembly,real time marketing,tutorialspoint python,sql join,real time html,services briefcase,asp.net core web api,ajax jquery,wccftech,craigslist ny,asp.net zero,csharp foreach,server memes,sql date format,services online,chase,examples of culture,serverless architecture,server resume,wcf c#,server books,tutorialspoint javascript,mvcc connect,ado.net mysql,services technologies gps,ajax deadpool,server jobs,cvs,website,mvc tutorial,costco hours,wcf service application,examples of proteins,tutorialspoint spring,serverless,wcf soap,tracking maersk,wcf cat,wcf test client,cool math games,services & training hse colombia sas,servicestack,citibank,asp.net core identity,sql union,tracking hamburg sud,ajax parking,sql database,asp.net core logging,mvconnect,asp.net guida,cunyfirst,wcf nba,real time subscriber,csharp download,wcfi foundation,csharp online,wcf authentication,tutorials near me,http://asp.net,server 2019,ado.net descargar,web of dreams,chernobyl,serverminer,ajax cleaner,ado.net visual studio 2019,webassign,real time biologia,real time module labview 2017,ado.net vs entity framework,tracking wan hai,ado.net visual studio 2017,csharp list,sql like,asp.net mvc,asp.net core tutorial,tracking evergreen,sqlite,wcfm,ajax roster,mvc architecture,tracking apl,http://ado.net,tracing y tracking,asp.net core mvc,ajax soccer,server hosting,examples of parasitism,wcfi,ajax dish soap,capital one,server rack,tutorialspoint html,csharp interface,craigslist,webroot,tutorialspoint reactjs,ajax request,wcf dragon ball,tracking hapag lloyd,asp.net core 2.2,tracing de vapor,tutorialspoint python 3,sql developer,webster,services transmission company sas,sql group by,asp.net core signalr,services manager,mvc framework,ajax paving,mvc near me,tracking dhl,tracking one,examples of irony,examples of figurative language,tutorialspoint spring boot,mvc map,csharp online compiler,asp.net download,sql between,ado.net c# pdf,wcf 2019 nba,services tag dell,csharp switch,real time pcr,ado.net ventajas y desventajas,csharpstar,real time operating system,wcf tutorial,examples of adjectives,tutorialspoint,real time with bill maher,ajax meaning,csharp-video-tutorials.blogspot,tutorials dojo,csharp string format,central park 5,tracking msc,tracking hyundai,ado.net c#,asp.net core github,tracking,server status,ajax fc,server jobs nyc,asp.net core swagger,sql formatter,credit karma,services group,server error in '/' application,services windows,asp.net core 3.0,sql injection,wcf ria services,tutorialspoint c#,calculator,ado.net entity data model,sql insert,tutorialspoint tableau,services google play apk,sqlyog,asp.net core 3 release date,sql server,server job description,real time board,tutorials by a,real time sportscast,servicenow,examples of lipids,webcam,mvc hours,webmd symptom,csharp array,csharp enum,ajax call,asp.net core 2. guida completa per lo sviluppatore,asp.net core,server pro,server status ffxiv,webcrims,cheap flights,asp.net core hosting,services sas,tracking sealand,examples of metaphors,tutorialspoint java,tutorialspoint java compiler,examples of adverbs,webmd,csharp to json,college football,ado.net dataset,csharp dictionary,tracing paper,examples of tone,cnn,tracing electrico,website builder,real time clock error,tutorialspoint sql,asp.net web api,server side rendering,weber grills,sql server 2017,example synonym,mvc nj,tutorialspoint spark,ado.net oracle,asp.net core download,csharp to vb.net,webster bank,webstaurant,examples of resignation letters,tutorialsystems,ajax post,services fms publish announcement,services.msc no abre,tracking cosco,ajax jersey,csharp operator,tracking cma cgm,asp.net core razor pages,server duties,asp.net core environment variables,csharp random,century 21,examples of carbohydrates,real time bidding,services consultores,services consulting,mvcsd,mvcsc,services.msc,ado.net pdf,asp.net core configuration,ajax marvel,sql update,asp.net tutorial,mvc medical,example of mutualism,ado.net entity data model visual studio 2019,wcfs international curriculum,mvc2,ado.net entity data model visual studio 2017,chase online,wcf api,real time simulation failed to start,costco,server jobs near me,webex,sql meaning,sql tutorial,sql commands,ado.net entity framework,ajax tavern,example cover letter,tutorialsteacher,ajax javascript,services desk,tracking servientrega,real time labview,ajax greek,csharp tutorial,mvc pattern,ado.net sql server,ado.net connection,asp.net identity,real time youtube subscriber count,mvcu,example of commensalism,real time youtube subscriber count luisito comunica,asp.net core middleware,wcf web service,real time management,mvc webadvisor,web store,mvcc,webmail,mvci,mvctc,