Hi Charlie, I have checked our client variables pages and there aren't any DSN's listed (just the default option of registry selected), I've checked the cfapplication tag for the site too and it uses the default (registry). I'll log full query stats for a day anyhow and see if it shows us anything interesting :)
Regards Barry. On Mon, Nov 29, 2010 at 4:39 PM, charlie arehart <charlie_li...@carehart.org > wrote: > Well, as far as having the limits because you’ve not needed to use it, I’m > proposing that now’s the time. :-) And after capturing that data, then look > in the JDBC logs (which are not enabled by default—again, controlled in the > jdbc settings page). It’s going to be a lot of data, but you can do all > sorts of things to analyze it, whether using Excel (or Open Office Calc) or > the free Microsoft Log Parser tool. There is a technote from Intergral on > using Excel to analyze the FR logs ( > http://www.fusion-reactor.com/support/kb/FRS-161.cfm), and I have a page I > created with lots of info on analyzing them using LogParser ( > http://groups.google.com/group/fusionreactor/web/log-parser-commands-for-fr-3 > ). > > For instance, just getting a count of queries happening per minute can help > (you can also interpolate that from the resource log instead, since it has a > count of queries that finished every 5 seconds). But you could go further > and report things like how many times specific queries are running, etc. > > As for the DBA being “fairly certain” in his assertion, this is one of > those times where analysis of diagnostics should be trusted more than > intuition. I make a living help people find and correct such misconceptions. > :-) > > As for the client var question, the first step is simply to look in the CF > Admin, on the Client variables page, to see if any DSNs are listed. Are you > able to do that, or are you perhaps not allowed to access the Admin? Just > can’t tell what you’re conveying in only being able to guess at things (it’s > your Monday workday for you guys, right, so I’m assuming it isn’t that > you’re not at work). :-) > > As always, just trying to help. > > /charlie > -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
