Re: What would you call high traffic for CF8 standard?

2013-06-13 Thread Brian Cain
I second the DB issue theory. I also run several job boards, and have found that most of my performance issues relate to the database. Sometime I can optimize the DB with the help of the profiler, other times I have simply reworked the code for better efficient. Use of nolock, small simple quer

RE: What would you call high traffic for CF8 standard?

2013-06-13 Thread Paul Vernon
> Yeah... again I would say you are getting all you can out of this > setup. I'm not finding a lot to criticize :) > > -Mark Thanks. It just crashed again. Albeit the reliability is much improved over what it was by reducing the time for cleaning up connections and switching the memory allocati

RE: What would you call high traffic for CF8 standard?

2013-06-13 Thread Paul Vernon
> That should work on 2005 and above as best I know. Not sure about > 2000. Not SQL 2000 then :-( > Also, I noticed in the trace, some of the queries look a bit > sequential, based on the parameters. Maybe like you are looping over a > result set and doing queries for each record in that fi

RE: What would you call high traffic for CF8 standard?

2013-06-13 Thread Mark A. Kruger
Paul, Yeah... again I would say you are getting all you can out of this setup. I'm not finding a lot to criticize :) -Mark Mark Kruger - CFG CF Webtools www.cfwebtools.com www.coldfusionmuse.com O: 402.932.3318 E: mkru...@cfwebtools.com Skype: markakruger -Original Message- From: Pau

Re: What would you call high traffic for CF8 standard?

2013-06-13 Thread Byron Mann
That should work on 2005 and above as best I know. Not sure about 2000. Also, I noticed in the trace, some of the queries look a bit sequential, based on the parameters. Maybe like you are looping over a result set and doing queries for each record in that first result set. If so, that could be

Re: What would you call high traffic for CF8 standard?

2013-06-13 Thread Russ Michaels
are you checking for hung requests when the issues occur? On Thu, Jun 13, 2013 at 6:49 PM, Paul Vernon < paul.ver...@web-architect.co.uk> wrote: > > Hi Byron, > > > Here's a simple one to show you real time what is executing on the > > server. > > What version of SQL Server is that for? > > Pau

RE: What would you call high traffic for CF8 standard?

2013-06-13 Thread Paul Vernon
Hi Byron, > Here's a simple one to show you real time what is executing on the > server. What version of SQL Server is that for? Paul ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthol

RE: What would you call high traffic for CF8 standard?

2013-06-13 Thread Paul Vernon
> Locks and blocks can occur and have no overall impact on general DB > server > performance - but still bring down your site because they prevent other > queries from completing. I'd bet my left eye that's what's happening. > Here's > what I would do On this server, I've done all what you'

Re: What would you call high traffic for CF8 standard?

2013-06-13 Thread Byron Mann
Here's a simple one to show you real time what is executing on the server. set transaction isolation level read uncommitted go SELECT s.blocked as blockedBy, r.session_id, st.text, r.status, r.command, r.cpu_time, db_name(r.database_id), object_name(st.objectid, r.database_id), r.sta

RE: What would you call high traffic for CF8 standard?

2013-06-13 Thread Mark A. Kruger
Paul, Locks and blocks can occur and have no overall impact on general DB server performance - but still bring down your site because they prevent other queries from completing. I'd bet my left eye that's what's happening. Here's what I would do. * monitor for locks and blocks and long running q

Re: What would you call high traffic for CF8 standard?

2013-06-13 Thread Steve 'Cutter' Blades
In my experience, many "CF" problems are actually DB performance issues. Not the DB server, per se, but a specific datasource and the queries running against it. Run your trouble queries through a query optimizer, and ensure you have the best query written for the task. Check out your indexes

RE: What would you call high traffic for CF8 standard?

2013-06-13 Thread Paul Vernon
After looking through the logs (and there are a lot of logs) when the server crashes, the first thing to start appearing is cfquery timing out. The DB however is fully responsive to other clients when this happens, so the issue is CF data source related rather than the DB directly. This all happen

RE: What would you call high traffic for CF8 standard?

2013-06-13 Thread Mark A. Kruger
Paul, It's a good idea but I don't think the change DB time out is saving you much. These DB connections are very tiny in terms of resources - probably around 24k or so. No data is associated with a connection - and a site as busy as yours will drop fe of the connections from the pool anyway. If

RE: What would you call high traffic for CF8 standard?

2013-06-13 Thread Mark A. Kruger
Great points Byron. -Original Message- From: Byron Mann [mailto:byronos...@gmail.com] Sent: Wednesday, June 12, 2013 9:26 PM To: cf-talk Subject: RE: What would you call high traffic for CF8 standard? Being a job site, aside from the search, are the other CF pages really dynamic? You c

RE: What would you call high traffic for CF8 standard?

2013-06-13 Thread Paul Vernon
I've been looking at the memory usage over the last 24 hours and spotted an optimisation that may benefit the server. The MaxPermSize was set to 384MB and the Eden space was set to 256MB. Looking at the memory usage, the MaxPermSize was nowhere near its limit and the Eden space was so I've swappe