CODEWITHSUNDEEP
c#.netoracle-databaseiis
Ilya Skaba
Ilya Skaba

Reputation: 65

How to find performance bottleneck in application?

Question is a bit general, but I'll try my best to ask it correctly.

So I started supporting system which is composed of parts:

In client application, user is making reports requests, which are proceeded by the web service, and the data is taken from DB. And some of these reports are proceeding VERY SLOW. About 1 hour for proceeding about 100 000 rows from 1 table.

So I want to know, which part of the system is slowing the whole system down. What are the most common practics to find this out? I understand that the question is very complex and general and recommending particular instrument is quite impossible. But what are common tactics? What is usual way to find out if system is slowing down on DB, web service or client side?

Upvotes: 1

Views: 1155

Answers (2)

Thabo
Thabo

Reputation: 1554

You can use profilers.You can find "Hot spots" based on profiling methods(eg CPU Sampling ,Instrumentation...and etc) .Personally for C# client i use visual studio profiler ,Jabraines DotTrace and ANT Memory profiler .Additionally you can use windows performance monitor as well. I use SQL profiler and RedGate Profiler for Database profiling.But there are more profilers available over the internet.Just have a research on Google and select a suitable one.

Upvotes: 2

Mark Redman
Mark Redman

Reputation: 24535

You may have answered your own question in the "where", ie have a look at the queries called when running the reports. As for the "How" have a look at the tools/profilers available to profile your application and the database.

Upvotes: 0

Related Questions