c# - How can I identify which functions and sql procedures are causing high cpu usage on the host server -

-

i have c#/asp.net web application (non mvc) has pages access sql database many times, using stored procedures , views. application has 5-10 users, , hosts have informed me it's causing 95%+ cpu usage on server.

my question, how can identify functions/procedures/threads causing high cpu use can cache or optimise them? note hosts not give me access server logs, stats, or serversystem database tables, application's database, causes major headache!

you can use sqlprofiler trace performance , behavior of sql procedure, function , etc.

you can check this: sqlprofiler it's helpful tool , it's me lot in enhancing sql stored procedures performance.

you run application before go sql profiler , configure listen on needed events, 'procedure completed' , select filtering criteria database or execution user when make action in app related database, profiler track , analyze it.

you can check step step usage of here.

about c# functions not related data access can measure it's performance using stopwatch class calculate it's execution time:

var watch = stopwatch.startnew(); // code want measure comes here watch.stop(); var elapsedms = watch.elapsedmilliseconds;

or can analyze performance while debugging in visual studio 2015


Comments

Post a Comment

Popular posts from this blog

Hatching array of circles in AutoCAD using c# -

-
i beginner in autocad plugins .i have created array of circle using following code. now, have hatch circles in array .how that??how hatch circles @ once? moreover, how can return hatch method , use hatch objects.sorry language.thanks in advance. [assembly: commandclass(typeof(beamsection.class1))] namespace beamsection { public class class1 { //class1 obj = new class1(); [commandmethod("beamatsupport")] public void addlightweightpolyline() { // current document , database document acdoc = application.documentmanager.mdiactivedocument; database accurdb = acdoc.database; promptpointresult ppr = acdoc.editor.getpoint("\nselect starting point "); var ucs = acdoc.editor.currentusercoordinatesystem; point3d startingpt = ppr.value.transformby(ucs); list<double> radius = new list<double>(); radius.add(0.5);
Read more

ios - UITEXTFIELD InputView Uipicker not working in swift -

-
hello trying pop uipickerview view programmatically when user clicks on textfield. have tried doesn't doing anything. isn't working. nothing happening when click textfield class userprofiletableviewcontroller: uitableviewcontroller,uitextfielddelegate,uipickerviewdelegate,uipickerviewdatasource { var itempicker: uipickerview! = uipickerview() @iboutlet weak var gendertxtfield: uitextfield! var gender = ["male","female"] override func viewdidload() { super.viewdidload() gendertxtfield.delegate = self itempicker!.delegate = self itempicker!.datasource = self itempicker!.backgroundcolor = uicolor.blackcolor() self.gendertxtfield.inputview = itempicker } func numberofcomponentsinpickerview(pickerview: uipickerview) -> int{ return 1 } // returns # of rows in each component.. func pickerview(pickerview: uipickerview, numberofrowsincomponent component:
Read more

Python Pig Latin Translator -

-
so have been working on @ codecademy.com while trying learn python. don't know if blind , can't see why won't work or what. here's code won't let me use. function print variable if had typed in , print "empty" if didn't type anything. print "welcome english pig latin translator!" original = raw_input("what's name?") if len(original) > 0 print original else print "empty" if len(original) > 0 else the above lines contains syntax errors. try: if len(original) > 0: else: note added colons, ( : ).
Read more