>> hardware improvement options and need to quantify
>> (as much as possible) performance increases
In my limited experience with MSSQL the best investment is improved Hard
drive speed and/or throughput and increased memory. They are usually the
bottlenecks.
Dennis Powers
UXB Internet - A Webs
As an adjunct to the advice you've already received (which is
excellent I might add), I always recommend looking at the business use
cases for reporting. Are these reports ad hoc reports or are they
known reports that you can schedule ahead of time, execute during off
hours, then save the results
Mike had a lot of good comments. How dynamic is your data? Is it constantly
being updated? If so, do you need real-time query results?
You need to balance the creation of indexes (as many as possible on a
relatively static server) with the fact that indexes can slow down
insert/update/delet
The Database Engine Tuning Advisor only gets you so far and some of
the recommendations it generates are bad recommendations. For example,
it might suggest redundant overlapping indexes. It currently takes a
human to properly set up indexes.
Your best bet is to find the bottleneck and try to quan
Hi. I have a SQL Server running on:
DELL PowerEdge 2950
4 GB Memory
1 Processors with 4 Cores
Windows 2003 Standard - 32 bit
...and one 20 GB database. Normally, everything runs very quickly. In
certain edge-cases such as: user requests 14 month report resulting in query
joining 400,000 rows
No prob.
Mark A. Kruger, CFG, MCSE
(402) 408-3733 ext 105
www.cfwebtools.com
www.coldfusionmuse.com
www.necfug.com
-Original Message-
From: webmas...@pegweb.com [mailto:webmas...@pegweb.com]
Sent: Friday, December 18, 2009 11:22 AM
To: cf-talk
Subject: RE: Server Performance
Thanks
Thanks. I will look over these.
-Original Message-
From: DURETTE, STEVEN J (ATTASIAIT) [mailto:sd1...@att.com]
Sent: Friday, December 18, 2009 9:01 AM
To: cf-talk
Subject: RE: Server Performance
CFMeetup just had a meeting on "Homebrewed ColdFusion Monitoring" by Wil
Gen
er 18, 2009 8:46 AM
To: cf-talk
Subject: RE: Server Performance
2 things for you.
First, check the DB for blocks and locks - about 9 times out of ten
queuing
requests are due to DB requests that are hanging. For some reason we web
developers bang our head against CF over and over thinking the
lk
Subject: RE: Server Performance
2 things for you.
First, check the DB for blocks and locks - about 9 times out of ten
queuing
requests are due to DB requests that are hanging. For some reason we web
developers bang our head against CF over and over thinking there is
something we can do on the web
ow busy is it - in real time, it's
handy and easy.
-Mark
Mark A. Kruger, CFG, MCSE
(402) 408-3733 ext 105
www.cfwebtools.com
www.coldfusionmuse.com
www.necfug.com
-Original Message-
From: webmas...@pegweb.com [mailto:webmas...@pegweb.com]
Sent: Thursday, December 17, 2009 6:
On Friday 18 Dec 2009, webmas...@pegweb.com wrote:
> Is there a way through command line or a 3rd party application to see
> what web sites on a CF Pro 8 server are causing the most requests?
Your web server logs would seem the obvious bet...
--
Helping to enthusiastically aggregate unique tot
Another good choice for a little less dough is SeeFusion which has some
very handy database logging.
http://www.seefusion.com/
~Brad
Original Message
Subject: Re: Server Performance
From: Andrew Scott
Date: Thu, December 17, 2009 6:52 pm
To: cf-talk
As you are not running
As you are not running ColdFusion Enterprise your best bet would be
http://www.fusion-reactor.com/
On Fri, Dec 18, 2009 at 11:20 AM, wrote:
>
> Is there a way through command line or a 3rd party application to see
> what web sites on a CF Pro 8 server are causing the most requests? On
> one p
Is there a way through command line or a 3rd party application to see
what web sites on a CF Pro 8 server are causing the most requests? On
one particular server it is starting to show behavior of page timeouts
and longer running requests. In the Performance Monitor in windows I see
the running re
On Friday 14 Dec 2007, Dan G. Switzer, II wrote:
> Do you have any of CF8's Server Monitoring enabled? It's known to cause
> performance issues and should only be used to debug problems;
You can (I'd argue should) have the first level of monitoring enabled.
--
Tom Chiverton
Helping to elementar
>>Every since upgrading to CF8 I've been having a frustrating problem.
>After
>>starting CF, it will run for a while (sometimes serveral hours, sometimes
>>less than an hour) at about 1% - 3% in terms of processor load. (It's a 2
>>cpu - 4 core system.) Then, all of a sudden, the processor load w
--Original Message-
From: Bob Hendren [mailto:[EMAIL PROTECTED]
Sent: 14 December 2007 11:31
To: CF-Talk
Subject: Re: Server performance problem since upgrading to CF8
>Every since upgrading to CF8 I've been having a frustrating problem.
>After starting CF, it will run for a while (som
>Every since upgrading to CF8 I've been having a frustrating problem. After
>starting CF, it will run for a while (sometimes serveral hours, sometimes
>less than an hour) at about 1% - 3% in terms of processor load. (It's a 2
>cpu - 4 core system.) Then, all of a sudden, the processor load will
Kevin Pompei wrote:
> Well I've isolated the problem down. It happens 1 hour and 7 minutes after
> restart which it time that is set for the client stores to be purged. This
> must be a bug in CF because once it starts the one CPU core is at 100% and
> stays there even for days until the server i
m
> the JVM.config file - and the general config of the server?
>
> -Mark
>
> -Original Message-
> From: Kevin Pompei [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, October 30, 2007 9:53 AM
> To: CF-Talk
> Subject: Re: Server performance problem since upgrading to CF
-Original Message-
From: Kevin Pompei [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 30, 2007 9:53 AM
To: CF-Talk
Subject: Re: Server performance problem since upgrading to CF8
You're correct. One core is at 100%.
On 10/29/07, James Holmes <[EMAIL PROTECTED]> wrote:
>
> On a fo
Thanks Dave. I'll try this.
On 10/29/07, Dave Watts <[EMAIL PROTECTED]> wrote:
>
> > Anyone seen this, or have any ideas. BTW, I'm running the
> > standard edition of CF so I don't have access to the server monitor.
>
> I suggest you invest in one of the other monitoring tools available -
> SeeF
You're correct. One core is at 100%.
On 10/29/07, James Holmes <[EMAIL PROTECTED]> wrote:
>
> On a four core system, a CPU pegged at 25% means one core is at 100%;
> CF has probably filled the JVM memory and is permanently garbage
> collecting.
>
> I agree with Dave - get FusionReactor and set a
Kevin Pompei wrote:
> Every since upgrading to CF8 I've been having a frustrating problem. After
> starting CF, it will run for a while (sometimes serveral hours, sometimes
> less than an hour) at about 1% - 3% in terms of processor load. (It's a 2
> cpu - 4 core system.) Then, all of a sudden,
You could also install the Dev version locally at and try running the code
with the server monitor turned on.
On 10/29/07, Kevin Pompei <[EMAIL PROTECTED]> wrote:
>
> Every since upgrading to CF8 I've been having a frustrating
> problem. After
> starting CF, it will run for a while (sometimes ser
Kevin,
What codebase are you running on it?
Mark
On 10/30/07, Kevin Pompei <[EMAIL PROTECTED]> wrote:
> Every since upgrading to CF8 I've been having a frustrating problem. After
> starting CF, it will run for a while (sometimes serveral hours, sometimes
> less than an hour) at about 1% - 3% in
On a four core system, a CPU pegged at 25% means one core is at 100%;
CF has probably filled the JVM memory and is permanently garbage
collecting.
I agree with Dave - get FusionReactor and set a memory alert threshold
in the crash prevention options.
On 10/30/07, Kevin Pompei <[EMAIL PROTECTED]>
> Anyone seen this, or have any ideas. BTW, I'm running the
> standard edition of CF so I don't have access to the server monitor.
I suggest you invest in one of the other monitoring tools available -
SeeFusion or FusionReactor. You will likely find the problem a lot faster,
and it'll pay for it
Every since upgrading to CF8 I've been having a frustrating problem. After
starting CF, it will run for a while (sometimes serveral hours, sometimes
less than an hour) at about 1% - 3% in terms of processor load. (It's a 2
cpu - 4 core system.) Then, all of a sudden, the processor load will jump
Grab a copy of seefusion or fusionreactor and watch the server especially
when it's timing out. You might see what's going on .
Russ
> -Original Message-
> From: Matthew Chambers [mailto:[EMAIL PROTECTED]
> Sent: Sunday, November 05, 2006 11:47 PM
> To: CF-
Hi guys,
I am getting random errors from CF along the lines of "The request has exceeded
the allowable time limit Tag: cfmail "... the error varies from CFMAIL,
CFOUTPUT and CFQUERY tags and different pages. The queries are fine, because
they work most of the time and I've run them through a DB
> // Declare a new image to obtain math values
> x=new Image;
> x.src=element.value;
> is=Math.ceil(x.fileSize/1000);
>
> This is a snippet of an old piece of javascript that I used for previewing
> and uploading multiple image files. I'm not 100% that I got the file size
> preview to work but I th
I think you can do this with javascript?
// Declare a new image to obtain math values
x=new Image;
x.src=element.value;
is=Math.ceil(x.fileSize/1000);
This is a snippet of an old piece of javascript that I used for previewing and
u
>Not I a m aware of. Bowsers are too picky about security.
>Javascript has no access to any information about the file selected for
>upload.
>The size of the file should be available in an onSubmit event, at least.
You can move to a 3rd party plug-in for Image uploading
(Java/ActiveX/Flash.) Using
ED]
> Sent: Tuesday, October 24, 2006 12:52 PM
> To: CF-Talk
> Subject: RE: Image upload impacting web server performance
>
> Absolutely. Large file uploads has a measurable impact on the server's
> CPU usage and memory usage as the file chunks are uploaded and them
> copi
y, October 24, 2006 12:28 PM
To: CF-Talk
Subject: Image upload impacting web server performance
I have a community site where members can upload photos of themselves.
I'm having problems with the ColdFusion server and think the problem may
be associated with people uploading large image files.
Is is possible?
It is quite possible, the way CF and HTTP servers handle files.
Also some people are still sending files in BMP format.
>> Is there something I can do about it?
Not I a m aware of. Bowsers are too picky about security.
Javascript has no access to any information about the file s
I have a community site where members can upload photos of themselves. I'm
having problems with the ColdFusion server and think the problem may be
associated with people uploading large image files. The server cpu and memory
races and freezes the server for a short while.
Is is possible? Is the
It's worth mentioning that there is some overhead for calling a stored
proc that isn't involved with straight queries, though it should be
minimal. Where stored procs REALLY shine is when you've got a query
whose result is only used for some logic driving another query. Using
a stored proc in tha
> Well, OK, not that dramatic, but every DBA I have ever known
> has told me that if you want performance, you use stored
> procedures. My quick test this evening has me rethinking that.
Just a warning - quick tests are often worth about the time you put into
them.
> The straight query using CF
On 5/20/06, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote:
> Has anyone else found this to be the case? I'm really thinking about
> ripping out all of my SP's and just using queries, it would make my
> life easier on a number of levels. I have all of my queries as
> methods in a CFC, so code re
here's what i have found...
i agree. when it comes to small queries like that with NOT MUCH LOGIC involved.
When it comes to a larger Stored Proc with LOTS of gobbledeegoop, i
think it changes
then.
but yeah, for the most part, i refactored most if not all of my
smaller queries into straight
sq
Well, OK, not that dramatic, but every DBA I have ever known has told
me that if you want performance, you use stored procedures. My quick
test this evening has me rethinking that.
Using essentially the same query (basically a login query against a
single table, pass in username and password, ret
Hey Ken. I'm naturally a biased responder here, but there was some public
discussion on Ben Forta's blog about comparisons:
http://www.forta.com/blog/index.cfm/2006/1/19/Check-Out-SeeFusion
Also, I'd be happy to talk offline about the products if you like, where my
bias can be unleashed. ;)
To
Hey guys. Does anyone know a good comparison between these 2 coldfusion
server monitoring tools? I am talking about seefusion Vs. fusion reactor.
My basic purpose is to optimize client requests and avoid frequent
coldfusion failures caused by faulty code, or heavy sql queries etc. Please
see if you
Here's a really good article for those of you debating server upgrades:
http://www.samag.com/documents/s=9408/sam0411b/0411b.htm
--
*Damien McKenna* - Web Developer - [EMAIL PROTECTED]
The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
"Nothing endures but change." - Heraclitus
[T
2-300 users, 500k cf hits/day is not all that much (it's a good amount,
but it's not at all abusive). Also, it depends on how you measure
concurrency. Some people do it by # of cf sessions, some by DB last
activity time, and others by whatever their log stats says. Others would
argue that you can't
Not sure if the product support team has a technote published on this yet or not, but check out this Microsoft KB article regarding IIS6 performance. This issue does affect ColdFusion MX 6.1 running on IIS6. Fortunately, it's a pretty simple tweak and ultimately it's going to be fixed by Microsoft
On Wed, 06 Oct 2004 02:32:21 +0200, Jochem van Dieten
<[EMAIL PROTECTED]> wrote:
> JB McMichael wrote:
> > I am currently running CFMX 6.1 Standard Edition with the updater
> > installed on a Win2k3 server, with IIS, connecting to a SQL Server
> > 2000 db that is on another computer. The web serve
riginal Message -
From: Jochem van Dieten
To: CF-Talk
Sent: Tuesday, October 05, 2004 7:32 PM
Subject: Re: Server performance
JB McMichael wrote:
> I am currently running CFMX 6.1 Standard Edition with the updater
> installed on a Win2k3 server, with IIS, connecting to a S
JB McMichael wrote:
> I am currently running CFMX 6.1 Standard Edition with the updater
> installed on a Win2k3 server, with IIS, connecting to a SQL Server
> 2000 db that is on another computer. The web server itself is a
> pretty beefy machine, and it is running one website that is fairly
> comp
I am currently running CFMX 6.1 Standard Edition with the updater
installed on a Win2k3 server, with IIS, connecting to a SQL Server
2000 db that is on another computer. The web server itself is a
pretty beefy machine, and it is running one website that is fairly
complex. The site usually has 200
I am looking for an app that will monitor our SQL server at a minimum for
performance. Something like this product, but I am unable to really find
many things out there and not really interested in this one
http://www.tntsoftware.com/Products/EEM/
[Todays Threads]
[This Message]
[Subscription]
t; From: Shahzad.Butt [mailto:Shahzad.Butt@;JJFastFood.com]
> Sent: 28 October 2002 13:27
> To: CF-Talk
> Subject: Server Performance
>
>
> Hi
>
> Some application/request is killing my server (running intranet). And
> almost everyweek my server stops working (for intranet) a
AIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, October 28, 2002 1:27 PM
Subject: Server Performance
> Hi
>
> Some application/request is killing my server (running intranet). And
> almost everyweek my server stops working (for intranet) and when
Hi
Some application/request is killing my server (running intranet). And
almost everyweek my server stops working (for intranet) and when I check
the server there is message "OUT OF VIRTUAL MEMORY". I want to log all
applications which are taking longer than 2 minutes (to find the
culprite one).
ailto:[EMAIL PROTECTED]]
Sent: Friday, December 01, 2000 9:24 AM
To: CF-Talk
Subject: SQL Server performance
I know this issue has probably been talked about in the past, but I'm new to
the list... I'm certainly NOT new to CF, been doing it for quite some time
(over 5 years), but haven
I know this issue has probably been talked about in the past, but I'm new to
the list... I'm certainly NOT new to CF, been doing it for quite some time
(over 5 years), but haven't played much with administration, just coding.
I have a small performance issue that has only recently begun to be
bot
er 25, 2000 9:19 AM
To: CF-Talk
Subject: SQL Server performance with CF
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Are there ways to optimize the connection between a CF server and an
SQL Server machine? We've just plugged them both into the network
(they are side by side in the same se
Message-
From: Chris Lott [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 25, 2000 12:19 PM
To: CF-Talk
Subject: SQL Server performance with CF
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Are there ways to optimize the connection between a CF server and an
SQL Server machine? We've
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Are there ways to optimize the connection between a CF server and an
SQL Server machine? We've just plugged them both into the network
(they are side by side in the same server rooom) and ran, but I
wondered if there were ways to optimize the travel o
61 matches
Mail list logo