Well, today's been one of those days where I'm hunting down information that seems nearly impossible to find. I'm in a small bind because I can't get a decent log file from the request broker on the database server. I continually get a log that looks like: XX:XX:XX dbuser@webserver could not connect (exceeded maximum number of allowed connections). That's all that the log file has. I was going to use DBI->trace(3) in order to log the errors and good connections from the web server end, but it doesn't do me much good if the logs on the database server can't match up.

Which brings me to my question: Is anyone aware of a utility that will let me watch real time connections to a database and plot them to graphs, logs, whatever? I'd need/want to be able to use this primarily on an NT environment, since I can use DBI's own logging on the *nix.

I am beginning to realize that this is actually looking very similar to netstat, but I would need not only the connection strings logged, but any transactions that occur over the established connection. I think this is where my exceeded limit comes from.

I will be grateful.

ALL HAIL BRAK!!!

In reply to DBD::ODBC and possibly OT. by PsychoSpunk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.