CODEWITHSUNDEEP
sql.netperformancevisual-studiodao
Sandeep
Sandeep

Reputation: 967

What is best way to check performance of DAO call (SQL call) using visual studio?

What is best way to check performance of DAO call (SQL call) using visual studio ?

I am trying to achieve below point:

  1. Check each backend call (DAO) execution time?
  2. Use this data for performance tuning ..

Upvotes: 0

Views: 97

Answers (1)

rich kalasky
rich kalasky

Reputation: 628

Using the Visual Studio profiler is a good place to start. It will show you call stacks with inclusive and exclusive times from your .NET code.

If your looking to tune SQL queries however, you'll end up wanting to use SQL Server Management Studio. Taking some time to understand query plans and how to read them will benefit you greatly when attempting to improve SQL performance. Management Studio provides the tools to gather and analyze this information.

Upvotes: 1

Related Questions