Checking number of DB calls

Question

With respect to performance tuning, I would like to find out the number of DB calls each page is making. Also, the stored procedures and queries that is executed. I'm using Asp.net and SQL Server 2008. In some places we have directly written the query in C# insead of calling SP.

I tried using SQL Profiler. In that, under Event if I select SP, I'm able to trace the SP calls. But what about the queries that are direcly called in C#. How can I trace that.

Kindly let me know how this can be done or if there is a better tool to find this out.

Thanks in advance.

score 3 · Answer 1 · edited May 23 '17 at 12:19

3

Use SQL Profiler to create a trace that logs these events:

RPC:Completed
SP:Completed
SP:StmtCompleted
SQL:BatchCompleted
SQL:StmtCompleted

See How Can I Log and Find the Most Expensive Queries?

edited May 23 '17 at 12:19

Community

1
1

answered Feb 28 '11 at 11:04

Mitch Wheat

295,962
43
465
541

score 1 · Answer 2 · answered Feb 28 '11 at 11:04

1

When you open a new trace you can select the template TSQL Which will then include the event SQL:BatchStarting that will show you the queries as well

answered Feb 28 '11 at 11:04

TBohnen.jnr

5,117
1
19
26

Checking number of DB calls

2 Answers2