How can I log query time?

Question

I have few oledb connections like this:

try
{
    OleDbConnection Connection8;
    using (Connection8 = new OleDbConnection("Provider=MSDAORA.1;Data Source=DATABASE:1521/orcl;Persist Security Info=True;Password=PASSWORD;User ID=USERNAME;"))
    {
        string sqlQuery = "select * from TABLE";

        using (OleDbDataAdapter cmd = new OleDbDataAdapter(sqlQuery, Connection8))
        {
            Connection8.Open();
            DataTable dt = new DataTable();
            cmd.Fill(dt);
            GridView5.DataSource = dt;
            GridView5.DataBind();
            v8 = 1;
            Connection8.Close();
        }
    }
}
catch (Exception)
{
    v8 = 0;
}

Some connections waiting so much, but I can't know which one.

How can I log or see query time for every connection? Any suggestion for that? Thank you.

You can use a profiler during debugging sessions. Or is this a production issue? New Relic might be helpful for example. However a 'best' solution i to broad. Ofcourse in-code like stopwatch can work but this sounds unwise for troubleshooting. (Exception: logging) — Myrtle, Jan 26 '16 at 15:28

score 3 · Accepted Answer · answered Jan 26 '16 at 15:27

You can use Stopwatch:

var stopwatch = new Stopwatch();
DataTable dt = new DataTable();
stopwatch.Start();
Connection8.Open();
cmd.Fill(dt);
stopwatch.Stop();

var timeElapsed = stopwatch.ElapsedMilliseconds;

Notice here in sample I've shown time to open connection will be included in measured time. If you don't need it and want "pure" query execution time - then just change the order od lines where connection being opened and stopwatch started.

score 0 · Answer 2 · answered Jan 26 '16 at 15:46

0

I don't know if this will work because you are using a OleDbConnection but one thing you may be able to do is in control panel open the "Odbc Administrator" (Be sure to check if you want 32 bit or 64 bit) there is a "Tracing" tab you can turn on, that gives you a log file of all ODBC requests that are processed.

But remember, like I said, because you are using a OleDbConnection it may not log anything.

answered Jan 26 '16 at 15:46

Scott Chamberlain

124,994
33
282
431

I deleted my answer. Thanks for your input. – Ian Jan 26 '16 at 16:28

score 0 · Answer 3 · answered Jan 26 '16 at 17:04

0

I've used Glimpse in the past, might be as well useful for you:

http://getglimpse.com/

answered Jan 26 '16 at 17:04

Swag

2,090
9
33
63

How can I log query time?

3 Answers3