CODEWITHSUNDEEP
asp.netsql-serverdatabaseperformancesql-server-2008
James
James

Reputation: 2246

Find database calls from a Page

I am using sql server 2008 and website is in asp.net 1.1.

Is there a way to find out how many times database has been called from a page?

What are the stored procedure called from the page?

What are the tables involved in a page load?

Please suggest how can i track these?

Upvotes: 3

Views: 711

Answers (1)

Habib
Habib

Reputation: 223247

The best thing is to use SQL profiler, which will keep track of every call made to the database.

You may see this article: SQL SERVER – Introduction to SQL Server 2008 Profiler

Upvotes: 5

Related Questions