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
> 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
> 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
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
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
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
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
> 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'
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
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
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
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
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
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
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
15 matches
Mail list logo