SOT: SQL Server Performance
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 and 15,000,000 rows and...etc...SQL Server takes about 1 minute to return results. I've optimized the database and optimized the SQL and Database Engine Tuning Advisor has no more recommendations for me. I have the following three hardware improvement options and need to quantify (as much as possible) performance increases that'll be realized by implementing each: - add a second Processors with 4 Cores - upgrade memory from 4GB to 8GB and move to 64 bit Windows Server 2008 - increase number of hard drives to achieve RAID 10 Suggestions for a tool and/or some documentation that'll help with this? Google has not produced anything useful yet... -- John Bliss IT Professional @jbliss (t) / http://www.brandiandjohn.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335845 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SOT: SQL Server Performance
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 quantify how much that bottleneck is impacting server operations. It would be hard to quantify any benefit from upgrades unless you know what the bottleneck is. Adding a CPU if the existing CPU never gets above 10% utilization wont do much. You can find bottlenecks using a number of methods. Wait stats would be the first thing I would check. In my experience, the hard drive is often the bottleneck. If your budget is limited I would make a guess that it is better to add more drive spindles than add another CPU. If you only have one drive array in your server that can be a problem, even if it is RAID 10. Adding RAM takes pressure off the hard drives and is usually a good idea. 4 GB is considered a small amount of RAM for a production SQL Server box. Even 8 GB might be too little depending on what you are doing. -Mike Chabot http://www.linkedin.com/in/chabot On Thu, Jul 29, 2010 at 8:40 AM, John M Bliss bliss.j...@gmail.com wrote: 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 and 15,000,000 rows and...etc...SQL Server takes about 1 minute to return results. I've optimized the database and optimized the SQL and Database Engine Tuning Advisor has no more recommendations for me. I have the following three hardware improvement options and need to quantify (as much as possible) performance increases that'll be realized by implementing each: - add a second Processors with 4 Cores - upgrade memory from 4GB to 8GB and move to 64 bit Windows Server 2008 - increase number of hard drives to achieve RAID 10 Suggestions for a tool and/or some documentation that'll help with this? Google has not produced anything useful yet... -- John Bliss IT Professional @jbliss (t) / http://www.brandiandjohn.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335858 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SOT: SQL Server Performance
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/delete operations. It sounds like it's your select statements that are slow so have you gone through all those queries and indexed everything properly? If so, I'd be surprised if you're not running out of RAM with only 4GB. This of course leads to dropped indexes, which leads to poor performance. Analyze the RAM usage of your SQL Server, especially once you've tuned your indexes. Then buy (more than) the amount of RAM you'll need. Don't automatically assume that 8GB will be enough because there's a good chance it won't be. Regarding cores, are you going to have to run this app under load? Will you have multiple people requesting the same queries? Can you cache results? If you have a query that takes even 20 seconds to respond and you can't cache the results, and you expect to have multiple concurrent users, then you'll run out of cores very quickly. If you don't need real-time data, or your data is fairly static, you can also look into Microsoft Analysis Services. - Andrew. On 2010-07-29, at 08:40, John M Bliss wrote: 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 and 15,000,000 rows and...etc...SQL Server takes about 1 minute to return results. I've optimized the database and optimized the SQL and Database Engine Tuning Advisor has no more recommendations for me. I have the following three hardware improvement options and need to quantify (as much as possible) performance increases that'll be realized by implementing each: - add a second Processors with 4 Cores - upgrade memory from 4GB to 8GB and move to 64 bit Windows Server 2008 - increase number of hard drives to achieve RAID 10 Suggestions for a tool and/or some documentation that'll help with this? Google has not produced anything useful yet... -- John Bliss IT Professional @jbliss (t) / http://www.brandiandjohn.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335859 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SOT: SQL Server Performance
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 of to deliver to whoever needs it? Can you do a replication setup to a db server that is just set up for reporting and remove the load from the main db server? There are plenty of technical solutions, like adding more ram, that are available but be sure to also look at business process options that might be available as well. A good deal of the time you can save things by reworking some processes instead of just adding more hardware and end up making people happier in the long run. Cheers, Judah On Thu, Jul 29, 2010 at 11:39 AM, Andrew Clarke s...@clarke.ca wrote: 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/delete operations. It sounds like it's your select statements that are slow so have you gone through all those queries and indexed everything properly? If so, I'd be surprised if you're not running out of RAM with only 4GB. This of course leads to dropped indexes, which leads to poor performance. Analyze the RAM usage of your SQL Server, especially once you've tuned your indexes. Then buy (more than) the amount of RAM you'll need. Don't automatically assume that 8GB will be enough because there's a good chance it won't be. Regarding cores, are you going to have to run this app under load? Will you have multiple people requesting the same queries? Can you cache results? If you have a query that takes even 20 seconds to respond and you can't cache the results, and you expect to have multiple concurrent users, then you'll run out of cores very quickly. If you don't need real-time data, or your data is fairly static, you can also look into Microsoft Analysis Services. - Andrew. On 2010-07-29, at 08:40, John M Bliss wrote: 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 and 15,000,000 rows and...etc...SQL Server takes about 1 minute to return results. I've optimized the database and optimized the SQL and Database Engine Tuning Advisor has no more recommendations for me. I have the following three hardware improvement options and need to quantify (as much as possible) performance increases that'll be realized by implementing each: - add a second Processors with 4 Cores - upgrade memory from 4GB to 8GB and move to 64 bit Windows Server 2008 - increase number of hard drives to achieve RAID 10 Suggestions for a tool and/or some documentation that'll help with this? Google has not produced anything useful yet... -- John Bliss IT Professional @jbliss (t) / http://www.brandiandjohn.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335861 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: SQL Server Performance
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 Website Design Hosting Company P.O. Box 6028 Wolcott, CT 06716 203-879-2844 http://www.uxbinternet.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335872 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Server Performance
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 total schemas as part of the IT team of the year, '09 and '08 This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.co ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329244 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 server to solve problems that exist on the DB server :) Secondly, If you are already running perfmon then you can get the information on which site is busiest (or at least handling the most requests). Choose web service and then Current connections and all instances. Use the report view (the little page icon next to the chart icon on the toolbar) it is clearer. Oh... current connections is appropriate for Wind2003 and above. For windows 2000 use current anonymous users. What you should see (using the report view) is a horizontal list of all your sites. The _total will be the first item. On a busy server you may need to scroll to the right to see them all. You can click on them and delete the ones you know are not the problem. Even though seeFusion and fusionReactor are great tools, I set up saved Perfomon mcc's for all my windows servers - in fact you can view the counters remotely (if you have the right domain rules in place) and you can see more than one server at a time in the same perfmon instance. Granted it is less introspective than one of the Java tools - but for a quick glimpse of a server to answer the question - how 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:20 PM To: cf-talk Subject: Server Performance 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 requests will max out from time to time and then requests start to queue. I want to be able to determine which sites are generating the most requests so I can examine the traffic and the code on those sites for potential problems. Anybody know of any way to do this? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329245 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Server Performance
CFMeetup just had a meeting on Homebrewed ColdFusion Monitoring by Wil Genovese. It was an awesome meetup and the recording can be viewed at: http://www.meetup.com/coldfusionmeetup/pages/Recordings_of_the_ColdFusio n_Meetup-2009/ Or at: http://experts.na3.acrobat.com/p34004904/ Also Wil has put the presentation files up at his blog. They are at: http://www.trunkful.com/index.cfm/2009/12/10/Homebrewed-ColdFusion-Monit or-Presentation-Files Steve -Original Message- From: Mark Kruger [mailto:mkru...@cfwebtools.com] Sent: Friday, December 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 there is something we can do on the web server to solve problems that exist on the DB server :) Secondly, If you are already running perfmon then you can get the information on which site is busiest (or at least handling the most requests). Choose web service and then Current connections and all instances. Use the report view (the little page icon next to the chart icon on the toolbar) it is clearer. Oh... current connections is appropriate for Wind2003 and above. For windows 2000 use current anonymous users. What you should see (using the report view) is a horizontal list of all your sites. The _total will be the first item. On a busy server you may need to scroll to the right to see them all. You can click on them and delete the ones you know are not the problem. Even though seeFusion and fusionReactor are great tools, I set up saved Perfomon mcc's for all my windows servers - in fact you can view the counters remotely (if you have the right domain rules in place) and you can see more than one server at a time in the same perfmon instance. Granted it is less introspective than one of the Java tools - but for a quick glimpse of a server to answer the question - how 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:20 PM To: cf-talk Subject: Server Performance 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 requests will max out from time to time and then requests start to queue. I want to be able to determine which sites are generating the most requests so I can examine the traffic and the code on those sites for potential problems. Anybody know of any way to do this? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329246 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Server Performance
Thanks Mark this actually helped quite a bit. I didn't realize that option was available in perfmon. Thanks, Patrick J. Hedgepath Pegasus Web Productions webmas...@pegweb.com 803-996-0578 -Original Message- From: Mark Kruger [mailto:mkru...@cfwebtools.com] Sent: Friday, December 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 there is something we can do on the web server to solve problems that exist on the DB server :) Secondly, If you are already running perfmon then you can get the information on which site is busiest (or at least handling the most requests). Choose web service and then Current connections and all instances. Use the report view (the little page icon next to the chart icon on the toolbar) it is clearer. Oh... current connections is appropriate for Wind2003 and above. For windows 2000 use current anonymous users. What you should see (using the report view) is a horizontal list of all your sites. The _total will be the first item. On a busy server you may need to scroll to the right to see them all. You can click on them and delete the ones you know are not the problem. Even though seeFusion and fusionReactor are great tools, I set up saved Perfomon mcc's for all my windows servers - in fact you can view the counters remotely (if you have the right domain rules in place) and you can see more than one server at a time in the same perfmon instance. Granted it is less introspective than one of the Java tools - but for a quick glimpse of a server to answer the question - how 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:20 PM To: cf-talk Subject: Server Performance 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 requests will max out from time to time and then requests start to queue. I want to be able to determine which sites are generating the most requests so I can examine the traffic and the code on those sites for potential problems. Anybody know of any way to do this? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329253 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Server Performance
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 Genovese. It was an awesome meetup and the recording can be viewed at: http://www.meetup.com/coldfusionmeetup/pages/Recordings_of_the_ColdFusio n_Meetup-2009/ Or at: http://experts.na3.acrobat.com/p34004904/ Also Wil has put the presentation files up at his blog. They are at: http://www.trunkful.com/index.cfm/2009/12/10/Homebrewed-ColdFusion-Monit or-Presentation-Files Steve -Original Message- From: Mark Kruger [mailto:mkru...@cfwebtools.com] Sent: Friday, December 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 there is something we can do on the web server to solve problems that exist on the DB server :) Secondly, If you are already running perfmon then you can get the information on which site is busiest (or at least handling the most requests). Choose web service and then Current connections and all instances. Use the report view (the little page icon next to the chart icon on the toolbar) it is clearer. Oh... current connections is appropriate for Wind2003 and above. For windows 2000 use current anonymous users. What you should see (using the report view) is a horizontal list of all your sites. The _total will be the first item. On a busy server you may need to scroll to the right to see them all. You can click on them and delete the ones you know are not the problem. Even though seeFusion and fusionReactor are great tools, I set up saved Perfomon mcc's for all my windows servers - in fact you can view the counters remotely (if you have the right domain rules in place) and you can see more than one server at a time in the same perfmon instance. Granted it is less introspective than one of the Java tools - but for a quick glimpse of a server to answer the question - how 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:20 PM To: cf-talk Subject: Server Performance 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 requests will max out from time to time and then requests start to queue. I want to be able to determine which sites are generating the most requests so I can examine the traffic and the code on those sites for potential problems. Anybody know of any way to do this? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329254 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Server Performance
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 Mark this actually helped quite a bit. I didn't realize that option was available in perfmon. Thanks, Patrick J. Hedgepath Pegasus Web Productions webmas...@pegweb.com 803-996-0578 -Original Message- From: Mark Kruger [mailto:mkru...@cfwebtools.com] Sent: Friday, December 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 there is something we can do on the web server to solve problems that exist on the DB server :) Secondly, If you are already running perfmon then you can get the information on which site is busiest (or at least handling the most requests). Choose web service and then Current connections and all instances. Use the report view (the little page icon next to the chart icon on the toolbar) it is clearer. Oh... current connections is appropriate for Wind2003 and above. For windows 2000 use current anonymous users. What you should see (using the report view) is a horizontal list of all your sites. The _total will be the first item. On a busy server you may need to scroll to the right to see them all. You can click on them and delete the ones you know are not the problem. Even though seeFusion and fusionReactor are great tools, I set up saved Perfomon mcc's for all my windows servers - in fact you can view the counters remotely (if you have the right domain rules in place) and you can see more than one server at a time in the same perfmon instance. Granted it is less introspective than one of the Java tools - but for a quick glimpse of a server to answer the question - how 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:20 PM To: cf-talk Subject: Server Performance 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 requests will max out from time to time and then requests start to queue. I want to be able to determine which sites are generating the most requests so I can examine the traffic and the code on those sites for potential problems. Anybody know of any way to do this? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329256 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Server Performance
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 requests will max out from time to time and then requests start to queue. I want to be able to determine which sites are generating the most requests so I can examine the traffic and the code on those sites for potential problems. Anybody know of any way to do this? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329239 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Server Performance
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, 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? 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 requests will max out from time to time and then requests start to queue. I want to be able to determine which sites are generating the most requests so I can examine the traffic and the code on those sites for potential problems. Anybody know of any way to do this? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329240 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Server Performance
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 andr...@andyscott.id.au Date: Thu, December 17, 2009 6:52 pm To: cf-talk cf-talk@houseoffusion.com As you are not running ColdFusion Enterprise your best bet would be http://www.fusion-reactor.com/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329241 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Server performance problem since upgrading to CF8
Might be worth downloading FusionReactor and installing that. I think you get a 10 day trial. You'll get pretty much all the monitoring functionality that you'd get with Enterprise. http://www.fusion-reactor.com/fr/downloads.cfm?gclid=CJ30m97ap5ACFSJIEgod30O H7Q Cheers Will -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 (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 up to about 25% and stay there until CF is restarted. Pages then start loading very sluggishly. This never happened with CF7 and I haven't made any code changes since upgrading. Also, the CF code that this server runs is very light. I have had this EXACT problem! Have you found a solution? A fire-breathing, quad-processor, dual core Dell that just locks up - weird! 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. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294763 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Server performance problem since upgrading to CF8
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 elementarily expedite wireless mindshares on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294767 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
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 (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 up to about 25% and stay there until CF is restarted. Pages then start loading very sluggishly. This never happened with CF7 and I haven't made any code changes since upgrading. Also, the CF code that this server runs is very light. I have had this EXACT problem! Have you found a solution? A fire- breathing, quad-processor, dual core Dell that just locks up - weird! 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 shouldn't enable it in normal circumstances. -Dan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294766 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
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 (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 up to about 25% and stay there until CF is restarted. Pages then start loading very sluggishly. This never happened with CF7 and I haven't made any code changes since upgrading. Also, the CF code that this server runs is very light. I have had this EXACT problem! Have you found a solution? A fire-breathing, quad-processor, dual core Dell that just locks up - weird! 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. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294762 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Server performance problem since upgrading to CF8
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, the processor load will jump up to about 25% and stay there until CF is restarted. I have seen this before on systems that had profiling enabled, but 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. that can not be your problem. If you installed CF less then 30 days ago you should be able to remove the license key from license.properties and after a restart it should revert to a trial license. With a trial license you can start the server monitor. Obviously you should not try this in production. Jochem ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292310 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 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] 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, the processor load will jump up to about 25% and stay there until CF is restarted. Pages then start loading very sluggishly. This never happened with CF7 and I haven't made any code changes since upgrading. Also, the CF code that this server runs is very light. -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292330 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Server performance problem since upgrading to CF8
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 - SeeFusion or FusionReactor. You will likely find the problem a lot faster, and it'll pay for itself on its first use as a result. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292331 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Server performance problem since upgrading to CF8
That makes me think you should try a different GC... How about the concMarksweep GC? Theoretically it should handle scheduling across multiple procs better than the default parallel GC. Can you post your java args from 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 CF8 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 memory alert threshold in the crash prevention options. 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 terms of processor load. (It's a 2 cpu - 4 core system.) Then, all of a sudden, the processor load will jump up to about 25% and stay there until CF is restarted. Pages then start loading very sluggishly. This never happened with CF7 and I haven't made any code changes since upgrading. Also, the CF code that this server runs is very light. -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292333 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Server performance problem since upgrading to CF8
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 is restarted. On 10/30/07, Mark A Kruger [EMAIL PROTECTED] wrote: That makes me think you should try a different GC... How about the concMarksweep GC? Theoretically it should handle scheduling across multiple procs better than the default parallel GC. Can you post your java args from 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 CF8 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 memory alert threshold in the crash prevention options. 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 terms of processor load. (It's a 2 cpu - 4 core system.) Then, all of a sudden, the processor load will jump up to about 25% and stay there until CF is restarted. Pages then start loading very sluggishly. This never happened with CF7 and I haven't made any code changes since upgrading. Also, the CF code that this server runs is very light. -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292378 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Server performance problem since upgrading to CF8
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 is restarted. Do you store client variables in the registry? If so, don't. And make sure you change the default storage from Registry to None. If you store client variables in the database you should be able to see what SQL CF executes or just disable automatic purging and run your own purge directly on the 2 tables from a scheduled task. Jochem ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292381 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 (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 up to about 25% and stay there until CF is restarted. Pages then start loading very sluggishly. This never happened with CF7 and I haven't made any code changes since upgrading. Also, the CF code that this server runs is very light. 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. ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292280 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Server performance problem since upgrading to CF8
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 itself on its first use as a result. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292288 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Server performance problem since upgrading to CF8
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] 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, the processor load will jump up to about 25% and stay there until CF is restarted. Pages then start loading very sluggishly. This never happened with CF7 and I haven't made any code changes since upgrading. Also, the CF code that this server runs is very light. -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292292 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Server performance problem since upgrading to CF8
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 terms of processor load. (It's a 2 cpu - 4 core system.) Then, all of a sudden, the processor load will jump up to about 25% and stay there until CF is restarted. Pages then start loading very sluggishly. This never happened with CF7 and I haven't made any code changes since upgrading. Also, the CF code that this server runs is very light. 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. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292293 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Server performance problem since upgrading to CF8
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 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 up to about 25% and stay there until CF is restarted. Pages then start loading very sluggishly. This never happened with CF7 and I haven't made any code changes since upgrading. Also, the CF code that this server runs is very light. 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. ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292298 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Server performance
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-Talk Subject: Server performance 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 client which returns the result set very fast. CFMAIL is fine as well. I think that there is something else going on because it's random, therefore I'm thinking that it's timing out when the server is overloaded. Can anyone suggest how I could find out more precisely why pages are timing out (the pages vary as well)? I guess I need to look at stress testing the server, so where on earth do I start? Also, is there any good resources with suggestion on how the CFADMIN settings can be optimised? At the moment CF is setup to receive 8 simultaneous connections. The server is Windows Server 2003, MySql 4.1, IIS Cheers Matthew ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259271 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Server performance
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 client which returns the result set very fast. CFMAIL is fine as well. I think that there is something else going on because it's random, therefore I'm thinking that it's timing out when the server is overloaded. Can anyone suggest how I could find out more precisely why pages are timing out (the pages vary as well)? I guess I need to look at stress testing the server, so where on earth do I start? Also, is there any good resources with suggestion on how the CFADMIN settings can be optimised? At the moment CF is setup to receive 8 simultaneous connections. The server is Windows Server 2003, MySql 4.1, IIS Cheers Matthew ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259243 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Image upload impacting web server performance
// 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 think I did. Before you can check an image's size with JavaScript you have to wait for its onload event to fire. An example of clien-side image upload validation is visible below, please read the notes about browser's compatibility: http://www.massimocorner.com/validator/samples/image_upload.htm Massimo Foti, web-programmer for hire Tools for ColdFusion and Dreamweaver developers: http://www.massimocorner.com ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258078 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Image upload impacting web server performance
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 uploading multiple image files. I'm not 100% that I got the file size preview to work but I think I did. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258027 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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. The server cpu and memory races and freezes the server for a short while. Is is possible? Is there something I can do about it? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257886 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Image upload impacting web server performance
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 selected for upload. The size of the file should be available in an onSubmit event, at least. On the server side, it is not better, the size of the file is not available either before it is completely uploaded. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257890 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
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 copied. One thing you can do is add a bit of restrictions on the file size. Unfortunately, the client can't know the size of the file before upload. Your only option that I can see is to make an obvious prompt to your users about file type(s) and size restrictions, then enforce it on the server side by checking the fileSize property of the uploaded file. -Original Message- From: MJ Frauenaheim [mailto:[EMAIL PROTECTED] Sent: Tuesday, 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. The server cpu and memory races and freezes the server for a short while. Is is possible? Is there something I can do about it? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257891 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Image upload impacting web server performance
Perhaps the server doesn't have enough RAM/Threads? I can't imagine a file upload freezing up the server unless you're doing some sort of image processing on it (such as resizing). Just uploading a file is not a very cpu intensive operation, and even if it's a file that's several MB long, you should have sufficient ram to handle it. Now what happens if you have 10 users doing it at the same time is another story. But 1 file upload should not noticeably slow things down. Russ -Original Message- From: Steve Brownlee [mailto:[EMAIL PROTECTED] 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 copied. One thing you can do is add a bit of restrictions on the file size. Unfortunately, the client can't know the size of the file before upload. Your only option that I can see is to make an obvious prompt to your users about file type(s) and size restrictions, then enforce it on the server side by checking the fileSize property of the uploaded file. -Original Message- From: MJ Frauenaheim [mailto:[EMAIL PROTECTED] Sent: Tuesday, 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. The server cpu and memory races and freezes the server for a short while. Is is possible? Is there something I can do about it? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257893 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Image upload impacting web server performance
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 a plug-in you'll have the ability to control the type, size, etc of files before they're actually uploaded. -Dan ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257895 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Did my own CF/SQL Server performance testing, my world is tur ned upside down.
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 CFQUERYPARAM was consistently the fastest. I fully expected this to be the case when compared to using a straight query without cfqueryparam, but I was really surprised to find that the stored procedure was consistently the SLOWEST. 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 reuse is about the same that it would be when using a stored procedure. First, this may simply be due to the database drivers you're using. You might try running your stored procedure through CFQUERY instead. Or, you might try newer database drivers, if they're available. You might, just for curiosity's sake, try running your queries and stored procedures through Query Analyzer, to see how they compare then. Second, prepared statements using bound parameters are typically as fast as stored procedures in most modern databases. There are still reasons why you still might want to use stored procedures over prepared statements, though, such as the ability to provide additional database security, and the ability to provide a database interface to multiple applications. Third, the reason that stored procedures and prepared statements are generally faster is because they allow the database to cache an execution plan, so that the next time the query is run, the database can reuse the plan rather than calculating a new plan. While this is generally going to provide better performance, this will not always be the case; if the inputs to the query are radically different from the ones used to generate the existing plan, that plan may not be optimal for the new query. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241105 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Did my own CF/SQL Server performance testing, my world is tur ned upside down.
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 that scenario will save you DB roundtrips, which is huge (at least if you're hitting the DB across a network, which will pretty much always be the case for larger apps thare care about performance). The other argument for stored procs is security: you can limit application access to invoking stored proce, and thereby prevent any ad hoc access to the DB. Outside those two very specific situations, prepared statements as inlined SQL is almost always a better choice. cheers, barneyb On 5/21/06, Dave Watts [EMAIL PROTECTED] wrote: The straight query using CFQUERYPARAM was consistently the fastest. I fully expected this to be the case when compared to using a straight query without cfqueryparam, but I was really surprised to find that the stored procedure was consistently the SLOWEST. 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 reuse is about the same that it would be when using a stored procedure. First, this may simply be due to the database drivers you're using. You might try running your stored procedure through CFQUERY instead. Or, you might try newer database drivers, if they're available. You might, just for curiosity's sake, try running your queries and stored procedures through Query Analyzer, to see how they compare then. Second, prepared statements using bound parameters are typically as fast as stored procedures in most modern databases. There are still reasons why you still might want to use stored procedures over prepared statements, though, such as the ability to provide additional database security, and the ability to provide a database interface to multiple applications. Third, the reason that stored procedures and prepared statements are generally faster is because they allow the database to cache an execution plan, so that the next time the query is run, the database can reuse the plan rather than calculating a new plan. While this is generally going to provide better performance, this will not always be the case; if the inputs to the query are radically different from the ones used to generate the existing plan, that plan may not be optimal for the new query. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241106 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Did my own CF/SQL Server performance testing, my world is turned upside down.
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, return ID, first name, last name, username, and email address), looped through each query 1,000 times, did that 10 times, in 3 different variations. I used CFTIMER for timings, SQL Server 2000 on my development workstation running MX7: * Straight SQL in a cfquery * Straight SQL using CFQUERYPARAM in a CFQUERY * Stored procedure using CFSTOREDPROC The straight query using CFQUERYPARAM was consistently the fastest. I fully expected this to be the case when compared to using a straight query without cfqueryparam, but I was really surprised to find that the stored procedure was consistently the SLOWEST. 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 reuse is about the same that it would be when using a stored procedure. Pete ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241054 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Did my own CF/SQL Server performance testing, my world is turned upside down.
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 sql code, with cfquery. tw On 5/20/06, Pete Ruckelshaus [EMAIL PROTECTED] wrote: 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, return ID, first name, last name, username, and email address), looped through each query 1,000 times, did that 10 times, in 3 different variations. I used CFTIMER for timings, SQL Server 2000 on my development workstation running MX7: * Straight SQL in a cfquery * Straight SQL using CFQUERYPARAM in a CFQUERY * Stored procedure using CFSTOREDPROC The straight query using CFQUERYPARAM was consistently the fastest. I fully expected this to be the case when compared to using a straight query without cfqueryparam, but I was really surprised to find that the stored procedure was consistently the SLOWEST. 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 reuse is about the same that it would be when using a stored procedure. Pete ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241055 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Did my own CF/SQL Server performance testing, my world is turned upside down.
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 reuse is about the same that it would be when using a stored procedure. Try using the stored procedure not using cfstoredproc - maybe it's the culprit. -- Phillip Beazley Onvix -- Website Hosting, Development E-commerce Visit http://www.onvix.com/ or call 727-578-9600. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241056 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CF Server performance
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 can touch upon how much load these tools themselvs will cause on coldfusion. links: http://www.seefusion.com http://www.fusion-reactor.com Any inputs would be great. Thanks, K ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233098 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF Server performance
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 answer your specific question about performance, there's never been any detectable overhead to SeeFusion, either in our own testing, or in the experiences of hundreds of customers worldwide using it in production. Hope that helps. Best, Patrick 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 can touch upon how much load these tools themselvs will cause on coldfusion. links: http://www.seefusion.com http://www.fusion-reactor.com Any inputs would be great. Thanks, K ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233101 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: Server performance article
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] mailto:[EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 Nothing endures but change. - Heraclitus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Server performance
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 server itself is a pretty beefy machine, and it is running one website that is fairly complex.The site usually has 200 to 300 concurrent users and averages about 500,000 page views a day. To me, this seems like a reasonable amount of traffic for a single server to handle.But I am seeing, what I perceive to be, slow response times on most of the pages.Myself and the other developers have gone through each page on the site and optimized all of the cf and sql and html as much as we can, and things have only improved slightly. Do you have debugging enabled? No, debugging is not enabled. I was wondering if switching to CF Enterprise would make a difference? Or, if a switch to Enterprise with a different backend, besides JRun, would be faster?Or should I put the money into a new web server or 2, and start running a load balanced site? How far have you optimized your CF settings? Did you tweak any of the Java parameters? I have gone through the Macromedia suggested settings for the CF optimizations.I can't find the link right now to the page, but everything Macromedia recommends, I have set on the server.If you know of certain Java parameters I could use to speed things up, or a page with information, please, let me know. I am pretty sure that SQL Server is not the culprit in all of this. Its average time to return a query, at least according to the CF performance monitor, is around 35 msec.And IIS doesn't seem to be at fault since we are timing the CF code itself, and I can see that it is slow.And like I said earlier, we have gone through the code line by line pruning and tweaking, so I don't think (or I am hoping it isn't) the code is to blame. Can you provide the 'worst case code' so we can have a look? What is the load on the system (CPU and I/O percentages)? I cannot provide any code, sorry. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Server performance
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 in W2K3 service pack 1. http://support.microsoft.com/default.aspx?scid=kb;EN-US;840875 BTW- make sure you have trusted cache turned on too. Jim Schley ColdFusion Macromedia Inc. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Server performance
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 measure user concurrency, but hits/sec concurrency. If you talk to CF support engineers, they will ask you about concurrent hits. You won't find much better performance with CF Enterprise, unless you're sending mass amounts of email. I have an app that runs way more traffic on cf standard, no slowdowns. What it really probably boils down to is your application. I know you can't share your code (not even the nasty parts), but that would be helpful. Perhaps we could help a bit. It sounds like you need to do some performance tuning. Perhaps re-evaluate some of the things you do, and they way you go about doing these things. Reduce the number of database transactions and move queries to stored procedures. Look for ways around other external processes like cfhttp, cfftp, cfmail, cfpop, image processing and so on. If you can make these processes asynchronous, do so. Remove or replace any CFX tags. Make sure you have all the CFMX patches (though I don't recommend the post-6.1 updater, we had some sqlserver driver problems). Turn on cfm page caching options. Begin caching queries wherever possible. good luck -nathan strutz http://www.dopefly.com/ 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 complex.The site usually has 200 to 300 concurrent users and averages about 500,000 page views a day. To me, this seems like a reasonable amount of traffic for a single server to handle.But I am seeing, what I perceive to be, slow response times on most of the pages.Myself and the other developers have gone through each page on the site and optimized all of the cf and sql and html as much as we can, and things have only improved slightly. I was wondering if switching to CF Enterprise would make a difference? Or, if a switch to Enterprise with a different backend, besides JRun, would be faster?Or should I put the money into a new web server or 2, and start running a load balanced site? I am pretty sure that SQL Server is not the culprit in all of this. Its average time to return a query, at least according to the CF performance monitor, is around 35 msec.And IIS doesn't seem to be at fault since we are timing the CF code itself, and I can see that it is slow.And like I said earlier, we have gone through the code line by line pruning and tweaking, so I don't think (or I am hoping it isn't) the code is to blame. So I am left with it either being a hardware issue, or I am hitting the limits of CF Standard Edition. Thanks for any help you can give, JB McMichael [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Server performance
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 to 300 concurrent users and averages about 500,000 page views a day. To me, this seems like a reasonable amount of traffic for a single server to handle.But I am seeing, what I perceive to be, slow response times on most of the pages.Myself and the other developers have gone through each page on the site and optimized all of the cf and sql and html as much as we can, and things have only improved slightly. I was wondering if switching to CF Enterprise would make a difference? Or, if a switch to Enterprise with a different backend, besides JRun, would be faster?Or should I put the money into a new web server or 2, and start running a load balanced site? I am pretty sure that SQL Server is not the culprit in all of this. Its average time to return a query, at least according to the CF performance monitor, is around 35 msec.And IIS doesn't seem to be at fault since we are timing the CF code itself, and I can see that it is slow.And like I said earlier, we have gone through the code line by line pruning and tweaking, so I don't think (or I am hoping it isn't) the code is to blame. So I am left with it either being a hardware issue, or I am hitting the limits of CF Standard Edition. Thanks for any help you can give, JB McMichael [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
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 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 to 300 concurrent users and averages about 500,000 page views a day. To me, this seems like a reasonable amount of traffic for a single server to handle.But I am seeing, what I perceive to be, slow response times on most of the pages.Myself and the other developers have gone through each page on the site and optimized all of the cf and sql and html as much as we can, and things have only improved slightly. Do you have debugging enabled? I was wondering if switching to CF Enterprise would make a difference? Or, if a switch to Enterprise with a different backend, besides JRun, would be faster?Or should I put the money into a new web server or 2, and start running a load balanced site? How far have you optimized your CF settings? Did you tweak any of the Java parameters? I am pretty sure that SQL Server is not the culprit in all of this. Its average time to return a query, at least according to the CF performance monitor, is around 35 msec.And IIS doesn't seem to be at fault since we are timing the CF code itself, and I can see that it is slow.And like I said earlier, we have gone through the code line by line pruning and tweaking, so I don't think (or I am hoping it isn't) the code is to blame. Can you provide the 'worst case code' so we can have a look? What is the load on the system (CPU and I/O percentages)? Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Server performance
I too am loosing my system on a daily basis (CFMX 6.1, Win2k3, IIS, MS SQL Server).It seems like a memory leak, after awhile, the system just crashes down with a JRun Error Could not connect to JRun Server I have to restart my service .. if I wait until the system shuts itself down and produces the jrun error, the restart process takes multiple minutes with it erroring out saying it couldn't stop the service. I have to babysit the server now, restarting the service about every 3-4 hours. Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com - Original 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 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 to 300 concurrent users and averages about 500,000 page views a day. To me, this seems like a reasonable amount of traffic for a single server to handle.But I am seeing, what I perceive to be, slow response times on most of the pages.Myself and the other developers have gone through each page on the site and optimized all of the cf and sql and html as much as we can, and things have only improved slightly. Do you have debugging enabled? I was wondering if switching to CF Enterprise would make a difference? Or, if a switch to Enterprise with a different backend, besides JRun, would be faster?Or should I put the money into a new web server or 2, and start running a load balanced site? How far have you optimized your CF settings? Did you tweak any of the Java parameters? I am pretty sure that SQL Server is not the culprit in all of this. Its average time to return a query, at least according to the CF performance monitor, is around 35 msec.And IIS doesn't seem to be at fault since we are timing the CF code itself, and I can see that it is slow.And like I said earlier, we have gone through the code line by line pruning and tweaking, so I don't think (or I am hoping it isn't) the code is to blame. Can you provide the 'worst case code' so we can have a look? What is the load on the system (CPU and I/O percentages)? Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Monitoring SQL server and general server performance
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] [Fast Unsubscribe] [User Settings]
Server Performance
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). How can I log all requests for my intranet which are taking more than X time and also that would be great if I define time span as well. That logs TIME and NAME/URL for page which are taking more than 2 minutes from 28th Oct o 30th Oct and on 30th I'll check log file and sort it by time. Shahzad Butt (Development Engineer) JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7803 584 873 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Server Performance
Go look in the CF administrator under logging You should find a setting in there that allows you to Log slow pages taking longer than n seconds Tick the box and set the number of seconds to 120 seconds. Stephen - Original Message - From: Shahzad.Butt [EMAIL 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 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). How can I log all requests for my intranet which are taking more than X time and also that would be great if I define time span as well. That logs TIME and NAME/URL for page which are taking more than 2 minutes from 28th Oct o 30th Oct and on 30th I'll check log file and sort it by time. Shahzad Butt (Development Engineer) JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7803 584 873 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Server Performance
On CF5 (and cf4.4 I think- can't remember exactly) in the CF admin pages and go to 'logging settings' (under the tools option in the top left). On that page you can set the server to record pages which take longer that x seconds. hth, Alex -Original Message- 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) 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). How can I log all requests for my intranet which are taking more than X time and also that would be great if I define time span as well. That logs TIME and NAME/URL for page which are taking more than 2 minutes from 28th Oct o 30th Oct and on 30th I'll check log file and sort it by time. Shahzad Butt (Development Engineer) JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7803 584 873 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: SQL Server performance
It's not my area of expertise, but you might look at the recent long discussion on using the BLOCKFACTOR attribute of CFQUERY. It allows you to affect the efficiency of communication between CF and your db (in some situations). -Original Message- From: Joe Sheble aka Wizaerd [mailto:[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't played much with administration, just coding. I have a small performance issue that has only recently begun to be bothersome. I'm running CF 4.5.1 on NT4 in IIS 4 using SQL Server 7.0. The CF and IIS are on a dual PIII 450, 512MB RAM system and the SQL Server is on a DUAL PIII Xeon, 1 GIG RAM and the two are connected via a 100 megabit network connection. I have a simple database with 1400 records in it, all properly indexed... I run the following query in Enterprise Manager of SQL Server and it takes mere milliseconds... I run it through CF and it takes 1 minute 40 seconds. The data I'm looking at for this query has 1400 records... Ok, so first thing people will tell me is to retrieve a smaller set of records... well SQL Server is certainly capable of holding this much (and a whole lot more) data, and using it quite efficiently. A C++ program we have running on client machines accessing the same set of data take mere seconds to load. There is no additional processing being done on the page, just merely calling the CFQUERY... The OLEDB connection would be one optimization, but as I was reading through the OLEDB docs there seems to be major issues with missing functionality. Plus the messages in Allaire's own forums gives the impression that OLEDB is not quite up to snuff... So where should I be looking for performance tweaks? Oh, here's the query: CFQUERY NAME="qEmps" DATASOURCE="#DSN_Name#" USERNAME="#DSN_Username#" PASSWORD="#DSN_Password#" SELECT IDNumber, FirstName, LastName FROM dcp_Employees ORDER BY FirstName /CFQUERY Thanx! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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 server rooom) and ran, but I wondered if there were ways to optimize the travel of data back and forth between the machines themselves, or if this shouldn't be of concern. Not being a nethead, it seems strange to me that the signal has to get all routed around when the machines are physically only a few feet apart... c -BEGIN PGP SIGNATURE- Version: PGP 6.5.8 for message encryption and authentication: USE PGP! Comment: PGP KeyID: 0x51046CFD iQA/AwUBOc9679aLYehRBGz9EQJLJQCfW2+Z7D6qNJ4ojwid+m+7ptD9TC8AoN/w fpXnfhnMVoIrGOU4JRgTklyq =XUrM -END PGP SIGNATURE- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL Server performance with CF
you can install dual NICs on the web server and create a dedicated network connection btwn. the web server and the DB server (100mb or more pref.). If the web server is the only thing using SQL server, then you take that traffic off the general network, freeing up bandwidth. /s -Original 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 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 of data back and forth between the machines themselves, or if this shouldn't be of concern. Not being a nethead, it seems strange to me that the signal has to get all routed around when the machines are physically only a few feet apart... c -BEGIN PGP SIGNATURE- Version: PGP 6.5.8 for message encryption and authentication: USE PGP! Comment: PGP KeyID: 0x51046CFD iQA/AwUBOc9679aLYehRBGz9EQJLJQCfW2+Z7D6qNJ4ojwid+m+7ptD9TC8AoN/w fpXnfhnMVoIrGOU4JRgTklyq =XUrM -END PGP SIGNATURE- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL Server performance with CF
Are you noticing problems in this respect? Usually until you receive lots of traffic or are on a busy switch or hub, this isn't an issue. But as traffic grows, you may wish to make a few changes. -Original Message- From: Chris Lott [mailto:[EMAIL PROTECTED]] Sent: Monday, September 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 server rooom) and ran, but I wondered if there were ways to optimize the travel of data back and forth between the machines themselves, or if this shouldn't be of concern. Not being a nethead, it seems strange to me that the signal has to get all routed around when the machines are physically only a few feet apart... c -BEGIN PGP SIGNATURE- Version: PGP 6.5.8 for message encryption and authentication: USE PGP! Comment: PGP KeyID: 0x51046CFD iQA/AwUBOc9679aLYehRBGz9EQJLJQCfW2+Z7D6qNJ4ojwid+m+7ptD9TC8AoN/w fpXnfhnMVoIrGOU4JRgTklyq =XUrM -END PGP SIGNATURE- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.