Seefusion does offer logging. Check out the feature list here http://www.seefusion.com/index.cfm?do=c.versions
Aaron Lynch www.InstantSpot.com On Fri, 2006-10-27 at 15:00 -0500, Dave Shuck wrote: > I am not sure about a logged report, but you can watch the queries in > "real time" meaning a rapid refresh that is sent to the flex display. > You can watch execution times and show long running queries. I would > bet that it can be logged too, but I am not certain. > > ~Dave > > On 10/27/06, Kyle Murphy <[EMAIL PROTECTED]> wrote: > Thanks for the info Dave. Actually, FusionReactor does have a > JDBC Wrapper. The only problem is that it just dumps JDBC > request into a single page without any analytics. I haven't > yet seen the benefit from that feature just yet, but I'm sure > one is there. Does SeeFusion provide a clear report showing > long running & problem SQL statements? > > Thanks, > Kyle > > Dave Shuck wrote: > > I passed on SeeFusion early on because I simply didn't "get > > it" as opposed to FusionReactor which I really liked, and I > > found the interface very familiar as it seemed to take after > > the ColdFusion admin. However, once I saw SeeFusion being > > used like it was intended by people who actually knew what > > they were doing, I realized I had not given it a fair look. > > Obviously that points to a usability issue, but I think that > > has been greatly addressed with their new Flex interface. I > > have not tried FusionReactor in a little more than a year or > > so, but to the best of my knowledge both are pretty equal in > > power these days. One *big* advantage to me that SeeFusion > > has is the ability to use that DSN wrapper that lets you > > have insight on very specific activity. I am almost certain > > there is no equivalent with Fusion Reactor. > > > > ~d > > > > On 10/26/06, Kyle Murphy <[EMAIL PROTECTED]> wrote: > > Everyone here is talking about SeeFusion. Has > > anyone tried FusionReactor? We're evaluating it > > right now. I passed on evaluationg SeeFusion right > > now because of it's interface. I really like > > FusionReactor so far (although, it has actually > > crashed my servers on restart because of the way we > > configured it), but that is our problem. > > > > Should I be looking at SeeFusion over FusionReactor? > > If so, what does it offer that FusionReactor > > doesn't? > > > > -Kyle > > > > Christopher Jordan wrote: > > > Dave, > > > > > > We had problems like this a long while back, > > > (turns out that one of our db drivers wasn't > > > thread safe - gasp! :o)), and a tool like this > > > would have helped. Now we're not having problems > > > like this anymore, but I wanted to check out the > > > seefusion stack trace tool all the same. I have a > > > page with an error and expanded the bit that says > > > "Stack Trace (click to expand)". I copied that > > > into the tool and it tells me it doesn't appear to > > > be a valid stack trace. > > > > > > I'm just curious (and this is by no means critical > > > to me right now), but are there different sorts of > > > stack traces? > > > > > > Chris > > > > > > Dave Shuck wrote: > > > > Ahmed, I imagine you are talking about doing > > > > metrics dumps. Just an FYI, there is a way to > > > > get similar metrics while continuing to run as a > > > > service (Windows only). Check this out: > > > > > > > > > http://www.bpurcell.org/blog/index.cfm?mode=entry&entry=1062 > > > > > > > > If you end up doing metrics dumps, rather than > > > > try to read it raw, save yourself a *lot* of > > > > time and use this free online stack trace > > > > parser. It is good stuff: > > > > http://www.seefusion.com/seestack/seestack.cfm > > > > > > > > Man these are frustrating problems to go > > > > through! Hang in there. > > > > > > > > ~Dave > > > > > > > > > > > > On 10/25/06, AHMED EL-RASHEEDY > > > > <[EMAIL PROTECTED] > wrote: > > > > Try this > > > > Go to your jvm.config file in \JRun4\bin > > > > \ in the multi-server install (it may be > > > > under cfusionmx7 in the single instance. > > > > Look for the java.args line and change > > > > the argument for the MaxPermSize from > > > > 128m to 256m.as below > > > > java.args=-server -Xmx512m > > > > -Dsun.io.useCanonCaches=false > > > > -XX:MaxPermSize=256m ... > > > > > > > > Keep in mind that on a windows machine > > > > you are allowed to use 1500 MB in > > > > combined memory for each JVM > > > > (Macromedia support say it is 1.8 GB but > > > > the most it would allow CF to restart > > > > with is 1500MB). > > > > So if you are allocating 1 GB to your > > > > JVM and take 256m out of it for the > > > > MaxPermSize then you are left with > > > > whatever is left of the 1 GB. > > > > > > > > As far as tools to monitor the JVM, > > > > there is a tool that monitors the JVM > > > > which is a Java Util that I got from > > > > Macromedia support at my previous job. > > > > It allows you to see the memory > > > > allocation in the JVM. It was pretty > > > > neat but required running the CF from > > > > console not as a Windows service. It is > > > > not available out there but I will see > > > > if I can get it somehow and post it to > > > > the DFWCFUG. > > > > Let us know if changing the MaxPermSize > > > > works. > > > > > > > > Thanks, > > > > Ahmed El-Rasheedy > > > > > > > > > > > > On 10/25/06, Eric Knipp > > > > <[EMAIL PROTECTED]> wrote: > > > > Have you looked at increasing > > > > the maximum permanent generation > > > > size? This helped a lot at my > > > > last job. Your problem could be > > > > directly related to garbage > > > > collection. > > > > > > > > > > > > On 10/25/06, Michael Stowe > > > > <[EMAIL PROTECTED]> > > > > wrote: > > > > Dave: > > > > > > > > The other issue that I > > > > was concerned about was > > > > the garbage collection. > > > > The JVM is currently > > > > runing with a 768M heap. > > > > I had seen some tech > > > > notes on GC that can > > > > cause 100% cpu usage. I > > > > tried using the low > > > > pulse collector, but > > > > that didn't seem to > > > > help. > > > > > > > > To further elaborate on > > > > Kevin's information: > > > > > > > > We have two twin > > > > systems: > > > > > > > > 1x Opteron 246 2 GHz > > > > 2GB RAM > > > > Windows 2003 Server x64 > > > > > > > > Jrun of course is > > > > running in 32bit mode. > > > > It is also running as a > > > > local user for > > > > interaction with our SMB > > > > file server. > > > > > > > > We have the latest > > > > version of SeeFusion on > > > > both systems. What I > > > > have observed is that > > > > the query times to the > > > > database are less than a > > > > second ( Fractions of ). > > > > Where we run into > > > > problems is CF rendering > > > > the results. We start > > > > seeing 6+ second times > > > > after the query has > > > > executed. > > > > > > > > I have also been running > > > > a tool on our DB server > > > > called mytop..basically > > > > identical to the top > > > > command on Linux / UNIX > > > > systems. It allows for > > > > per-thread montitoring > > > > of incoming queries. > > > > > > > > The types of queries are > > > > on average very > > > > short..but there are > > > > times when very large > > > > reports on data are ran. > > > > We also use a mixture of > > > > MyISIAM and InnoDB > > > > tables. The rows in the > > > > InnoDB tables are very > > > > long. I'm wondering if > > > > this can be part of the > > > > issue too? > > > > > > > > Thanks agian! > > > > > > > > -- > > > > Michael Stowe > > > > Network Administrator > > > > Alcatraz Media, Inc. > > > > (509) 232-0704 > > > > (888) 248-7211 > > > > > http://www.alcatrazmedia.com/hosting > > > > ----- Original > > > > Message ----- > > > > From: Dave > > > > Shuck > > > > To: Dallas/Fort > > > > Worth ColdFusion > > > > User Group > > > > Mailing List > > > > Sent: Wednesday, > > > > October 25, 2006 > > > > 1:08 PM > > > > Subject: Re: > > > > [DFW CFUG] not > > > > the first time > > > > you've heard > > > > from me > > > > > > > > > > > > Kevin, I felt > > > > the same way on > > > > my first pass of > > > > SeeFusion. > > > > However, we > > > > enlisted their > > > > (Webapper) > > > > consulting > > > > services and > > > > after seeing how > > > > they used the > > > > tool, its value > > > > became apparent > > > > *very* fast. > > > > With SeeFusion > > > > you can watch > > > > the threads come > > > > and go, and find > > > > long running or > > > > hanging > > > > requests. They > > > > also have a > > > > wrapper that you > > > > can put around > > > > your jdbc:// > > > > path in your > > > > DSNs that will > > > > log the database > > > > interaction and > > > > you can monitor > > > > all the way down > > > > to specific > > > > lines of code > > > > and queries that > > > > are breaking > > > > your stuff. > > > > Believe me, I > > > > understand your > > > > plight. We had > > > > an application > > > > tailspin on us > > > > like this and > > > > the Webapper > > > > guys helped us > > > > nail it. I > > > > don't know what > > > > your budget is > > > > like but if you > > > > can afford to > > > > contract them in > > > > on the > > > > troubleshooting, > > > > I can almost > > > > guarantee you > > > > will feel it was > > > > money well > > > > spent. > > > > > > > > ~Dave > > > > > > > > On 10/25/06, > > > > Kevin > > > > <[EMAIL PROTECTED] > > wrote: > > > > I am so > > > > tired of > > > > trying > > > > to find > > > > out the > > > > answer > > > > to these > > > > problems > > > > that I'm > > > > about to > > > > look for > > > > a job > > > > flipping > > > > burgers. > > > > > > > > > > > > > > > > We > > > > continue > > > > to have > > > > 100% > > > > JRUN > > > > issues > > > > on our > > > > servers. > > > > > > > > > > > > > > > > We have > > > > windows > > > > 2003 64x > > > > servers > > > > – plenty > > > > of ram, > > > > etc. > > > > > > > > We have > > > > a Linux > > > > box > > > > running > > > > mySQL 5 > > > > – plenty > > > > of ram, > > > > etc. > > > > > > > > > > > > > > > > > > > > > > > > Our > > > > systems > > > > are all > > > > production > systems. Everything is built on the fly. Therefore I KNOW that there are > some code issues and db issues. I can't even begin to correct these issues > because the servers keep maxing out the JRUN and crashing. > > > > > > > > > > > > > > > > Can > > > > anyone > > > > help? > > > > See > > > > fusion > > > > sux for > > > > some > > > > reason > > > > and has > > > > been no > > > > help. > > > > Are > > > > there > > > > any > > > > tools > > > > out > > > > there > > > > that we > > > > can use > > > > to > > > > monitor > > > > traffic > > > > and > > > > requests > > > > by cf > > > > and > > > > mySQL to > > > > help us > > > > identify > > > > where > > > > the > > > > problems > > > > are? > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Thank > > > > you for > > > > any help > > > > you can > > > > provide. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > kevin > > > > > > > > > > > > > > > > > _______________________________________________ > > > > Reply to > > > > DFWCFUG: > > > > > [email protected] > > > > > Subscribe/Unsubscribe: > > > > > http://lists1.safesecureweb.com/mailman/listinfo/list > > > > List > > > > Archives: > > > > > > > > > http://www.mail-archive.com/list%40list.dfwcfug.org/ > > > > > http://www.mail-archive.com/list%40dfwcfug.org/ > > > > DFWCFUG > > > > Sponsors: > > > > > www.HostMySite.com > > > > > www.teksystems.com/ > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > ~Dave Shuck > > > > [EMAIL PROTECTED] > > > > www.daveshuck.com > > > > > > > > Where's your > > > > Spot? > > > > www.instantspot.com > > > > > > > > ________________ > > > > > _______________________________________________ > > > > Reply to > > > > DFWCFUG: > > > > > > > > [email protected] > > > > Subscribe/Unsubscribe: > > > > > > > > > http://lists1.safesecureweb.com/mailman/listinfo/list > > > > List Archives: > > > > > > > > > http://www.mail-archive.com/list%40list.dfwcfug.org/ > > > > > > > > > http://www.mail-archive.com/list%40dfwcfug.org/ > > > > DFWCFUG > > > > Sponsors: > > > > > > > > www.HostMySite.com > > > > > > > > www.teksystems.com/ > > > > > > > > > _______________________________________________ > > > > Reply to DFWCFUG: > > > > [email protected] > > > > Subscribe/Unsubscribe: > > > > > http://lists1.safesecureweb.com/mailman/listinfo/list > > > > List Archives: > > > > > > > > > http://www.mail-archive.com/list%40list.dfwcfug.org/ > > > > > http://www.mail-archive.com/list%40dfwcfug.org/ > > > > DFWCFUG Sponsors: > > > > www.HostMySite.com > > > > www.teksystems.com/ > > > > > > > > > > > > > > > > > > > > > > > > > _______________________________________________ > > > > Reply to DFWCFUG: > > > > [email protected] > > > > Subscribe/Unsubscribe: > > > > > http://lists1.safesecureweb.com/mailman/listinfo/list > > > > List Archives: > > > > > > > > http://www.mail-archive.com/list > > > > %40list.dfwcfug.org/ > > > > > http://www.mail-archive.com/list%40dfwcfug.org/ > > > > DFWCFUG Sponsors: > > > > www.HostMySite.com > > > > www.teksystems.com/ > > > > > > > > > > > > > > > > > > > > > > > > _______________________________________________ > > > > Reply to DFWCFUG: > > > > [email protected] > > > > Subscribe/Unsubscribe: > > > > > http://lists1.safesecureweb.com/mailman/listinfo/list > > > > List Archives: > > > > http://www.mail-archive.com/list% > > > > 40list.dfwcfug.org/ > > > > http://www.mail-archive.com/list% > > > > 40dfwcfug.org/ > > > > DFWCFUG Sponsors: > > > > www.HostMySite.com > > > > www.teksystems.com/ > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > ~Dave Shuck > > > > [EMAIL PROTECTED] > > > > www.daveshuck.com > > > > > > > > Where's your Spot? > > > > www.instantspot.com > > > > > > > > ________________________________________________ > > > > > > > > _______________________________________________ > > > > Reply to DFWCFUG: > > > > [email protected] > > > > Subscribe/Unsubscribe: > > > > http://lists1.safesecureweb.com/mailman/listinfo/list > > > > List Archives: > > > > > http://www.mail-archive.com/list%40list.dfwcfug.org/ > > > > > > > > > > > > http://www.mail-archive.com/list%40dfwcfug.org/ > > > > DFWCFUG Sponsors: > > > > www.HostMySite.com > > > > > > > > > > > > www.teksystems.com/ > > > > > > > > > > __________________________________________________ > > > > > > _______________________________________________ > > > Reply to DFWCFUG: > > > [email protected] > > > Subscribe/Unsubscribe: > > > http://lists1.safesecureweb.com/mailman/listinfo/list > > > List Archives: > > > http://www.mail-archive.com/list%40list.dfwcfug.org/ > > > > > > > > > > http://www.mail-archive.com/list%40dfwcfug.org/ > > > DFWCFUG Sponsors: > > > www.HostMySite.com > > > > > > > > > www.teksystems.com/ > > > > > > > _______________________________________________ > > Reply to DFWCFUG: > > [email protected] > > Subscribe/Unsubscribe: > > http://lists1.safesecureweb.com/mailman/listinfo/list > > List Archives: > > http://www.mail-archive.com/list% > > 40list.dfwcfug.org/ > > http://www.mail-archive.com/list%40dfwcfug.org/ > > DFWCFUG Sponsors: > > www.HostMySite.com > > www.teksystems.com/ > > > > > > > > > > > > > > -- > > ~Dave Shuck > > [EMAIL PROTECTED] > > www.daveshuck.com > > > > Where's your Spot? > > www.instantspot.com > > > > ____________________________________________________________ > > > > _______________________________________________ > > Reply to DFWCFUG: > > [email protected] > > Subscribe/Unsubscribe: > > http://lists1.safesecureweb.com/mailman/listinfo/list > > List Archives: > > http://www.mail-archive.com/list%40list.dfwcfug.org/ > > > > > http://www.mail-archive.com/list%40dfwcfug.org/ > > DFWCFUG Sponsors: > > www.HostMySite.com > > > > www.teksystems.com/ > > > > _______________________________________________ > Reply to DFWCFUG: > [email protected] > Subscribe/Unsubscribe: > http://lists1.safesecureweb.com/mailman/listinfo/list > List Archives: > http://www.mail-archive.com/list%40list.dfwcfug.org/ > http://www.mail-archive.com/list%40dfwcfug.org/ > DFWCFUG Sponsors: > www.HostMySite.com > www.teksystems.com/ > > > > > > > -- > ~Dave Shuck > [EMAIL PROTECTED] > www.daveshuck.com > > Where's your Spot? > www.instantspot.com > _______________________________________________ > Reply to DFWCFUG: > [email protected] > Subscribe/Unsubscribe: > http://lists1.safesecureweb.com/mailman/listinfo/list > List Archives: > http://www.mail-archive.com/list%40list.dfwcfug.org/ > http://www.mail-archive.com/list%40dfwcfug.org/ > DFWCFUG Sponsors: > www.HostMySite.com > www.teksystems.com/ _______________________________________________ Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.HostMySite.com www.teksystems.com/
