How to count all the queries executed by a page in asp.net

Question

0.00/5 (No votes)

See more:

I want to list out all the queries executed by a page and log the all queries executed by a page. I am using MYSQL. Can any one help me with this?

Posted 15-Apr-11 0:26am

Balu Arigela

Updated 15-Apr-11 1:28am

#realJSOP

v3

Add a Solution

4 solutions

Solution 1

The answer to your problem is Log4Net which you will find here: http://logging.apache.org/log4net/[^].
It's a logging framework derived from a Java project Log4J and has all the stuff you need to do good logging. It can be customized if you want to, but for starters you'll probably be quite happy with it the way it is.

Cheers,

-MRB

Posted 15-Apr-11 0:50am

Manfred Rudolf Bihy

Comments

Espen Harlinn 15-Apr-11 8:19am

Good advice, my 5

Solution 3

Queries by a page or queries by a session. Queries by page can be known at design time. I think you are asking about queries by session for the particular page. Even not page global variable which destroyed once the page html rendered, you need a session variable counter Session[Page1_Queries] and increment whenever you succeed with a query.

Posted 15-Apr-11 2:14am

Albin Abel

Comments

Espen Harlinn 15-Apr-11 8:19am

Another nice and simple solution, 5ed!

Albin Abel 15-Apr-11 9:07am

Thanks Espen Harlinn

Solution 4

You can take a use of SQL Profiler
SQLProfiler : tool which gives all Queries fired during your Page life cycle

for more info click Here[^]

Posted 15-Apr-11 3:39am

koolprasad2003

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sridhar Patnayak · Accepted Answer · 2011-04-15T01:06:00

Solution 2

I think for you it is better to write your own logic.
because it may contain select,update,sp,etc..
So Maintain one variable globally and write your own logic

Posted 15-Apr-11 1:06am

Sridhar Patnayak