100% CPU
Hi all, We're running a CFMX 6.1 / SQL server 2000 app on a 1.6GHz AMD server with 1.5Gb of RAM. The app gets about 2.5 million page requests a month, peaking at about 7000 page requests per hour. Since yesterday morning it's suddenly started to misbehave, with the processor regularly maxing out at 100%. It will run clean an fast for 20 minutes or so, then suddenly requests will start to queue up and the whole thing grinds to a halt. Usually it recovers, but sometimes the service needs restarting to get it back. The app is well behaved, with most requests taking about half a second. There seem to be no particular long running requests that trigger it. This happened a couple of months ago and I restricted the amount of memory SQL server used and increased the RAM on the box to 1.5Gb. It currently appears to have about 3-400Mb free. I've installed the CFMX updater (released a few days ago), reinstalled ColdFusion, scandisked the drive and defragged. I wonder if anyone can give me any clues on what else to look for. Surely we should be able to get more traffic out of this spec machine? Many thanks Ian Buzer [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: 100% CPU
hi jrun.xml Jrun.xml file can be found in Jrun\server\server_instance_name\server-inf\jrun.xml in the SchedulerService section overwrite this code true 25 1000 20 180 600 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: 100% CPU
Hi vishnu, Thanks for the reply. Just to understand what this does Am I right in thinking this controls the cf scheduler? I'm fairly confident that our load problems are not related to scheduled requests as these occur overnight. Or does the scheduler have other implications? Thanks Ian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: 100% CPU
> I wonder if anyone can give me any clues on what else to look for. Surely we > should be able to get more traffic out of this spec machine? You can try and get a stack trace to see what's happenning with CF when the problem occurs. http://www.macromedia.com/support/coldfusion/ts/documents/tn18339.htm -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: 100% CPU
Ian, We have seen this behavior as well. When we start experiencing the page slowdowns and notice the jrun CPU very high we will stop and restart the CF Application Server, this "fixes" the problem. Yes the pages are down for a few seconds but in our environment this is not as big a problem as having the slow page response, or the page never coming up at all. __ Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com __ -Original Message- From: Ian Buzer [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 5:00 AM To: CF-Talk Subject: 100% CPU Hi all, We're running a CFMX 6.1 / SQL server 2000 app on a 1.6GHz AMD server with 1.5Gb of RAM. The app gets about 2.5 million page requests a month, peaking at about 7000 page requests per hour. Since yesterday morning it's suddenly started to misbehave, with the processor regularly maxing out at 100%. It will run clean an fast for 20 minutes or so, then suddenly requests will start to queue up and the whole thing grinds to a halt. Usually it recovers, but sometimes the service needs restarting to get it back. The app is well behaved, with most requests taking about half a second. There seem to be no particular long running requests that trigger it. This happened a couple of months ago and I restricted the amount of memory SQL server used and increased the RAM on the box to 1.5Gb. It currently appears to have about 3-400Mb free. I've installed the CFMX updater (released a few days ago), reinstalled ColdFusion, scandisked the drive and defragged. I wonder if anyone can give me any clues on what else to look for. Surely we should be able to get more traffic out of this spec machine? Many thanks Ian Buzer _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: 100% CPU
Hi Ian. We have had this problem as well, on both Windows 2003 and Redhat Linux servers. There doesn't seems to be any logic cause of the problem and therefore no fix. The only way to work around the problem is to restart the server regularly. We have a scheduled task on both Windows and Linux to restart the service once a day, which seems in the most part to have fixed the problem, but it still happens from time to time. Best Regards Andrew. _ From: Ian Buzer [mailto:[EMAIL PROTECTED] Sent: 31 August 2004 10:00 To: CF-Talk Subject: 100% CPU Hi all, We're running a CFMX 6.1 / SQL server 2000 app on a 1.6GHz AMD server with 1.5Gb of RAM. The app gets about 2.5 million page requests a month, peaking at about 7000 page requests per hour. Since yesterday morning it's suddenly started to misbehave, with the processor regularly maxing out at 100%. It will run clean an fast for 20 minutes or so, then suddenly requests will start to queue up and the whole thing grinds to a halt. Usually it recovers, but sometimes the service needs restarting to get it back. The app is well behaved, with most requests taking about half a second. There seem to be no particular long running requests that trigger it. This happened a couple of months ago and I restricted the amount of memory SQL server used and increased the RAM on the box to 1.5Gb. It currently appears to have about 3-400Mb free. I've installed the CFMX updater (released a few days ago), reinstalled ColdFusion, scandisked the drive and defragged. I wonder if anyone can give me any clues on what else to look for. Surely we should be able to get more traffic out of this spec machine? Many thanks Ian Buzer _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: 100% CPU
Hi Mack, >You can try and get a stack trace to see what's happenning with CF when the problem >occurs. >http://www.macromedia.com/support/coldfusion/ts/documents/tn18339.htm Good info - I'll check this out. Thanks Ian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: 100% CPU
Hi Andrew, Bill, We've been running ServersAlive for the last couple of years, which has been cycling the service automatically everytime the system slows and like you say, this has worked well as a backup. Trouble is, it was doing this about every 10 minutes when we had our recent problems - not really acceptable! I've been doing my sums - 7000 requests per hour is on average 2 requests per second. I guess in real life this could increase to say 4 requests per second for a few minutes at a time. Maybe this is as much as a single processor can handle? What other loads are people getting out of a single processor machine? Thanks Ian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: 100% CPU
Bill, I went through a similar process with a client of ours. We did several things to mitigate this issue. 1. Eliminate Access dbs. If you have anything running on Access get rid of it. 2. Make sure and use the JDBC Merant 3.3 drivers for SQL - this is an update from 6.1. 3. Check out long running db requests - maintenance tasks, utility tasks, data imports, exports and dumps ect. Create a separate datasource for these, restrict the number of connections and deselect the "maintain db connections" for that db resource in cf admin. 4. Fiddle with the JVM maxperm memory, and heap sizes. Try to get them large enough so that the heap is not being constantly resized and garbage collection is efficient. There are a ton more JVM settings depending on the JVM you are using. 5. Use Perfmon to figure out which resource is hanging. 6. Consider increasing the process isolation in IIS for the application - it can tell you if IIS is having conflicts with other processes outside the ap. 7. Check the web logs for a burst of http requests at the point of failure. One customer I know created a dynamic publishing system with constantly updated content - then he used google adsense to serve ads and make himself money. But every time a new page was published (new to google) the googlebots attack to figure out which ads to serve. Since his server was near capacity this sometimes surfaced as a denial of service type attack (much like you are seeing) - and since many of his pages were driven by database calls it looked like a possible db problem - or connection issue etc. 8. Consider moving the SQL server Off of the web server. 9. Make sure and use a FQDN for the server name in the database administrator. In other words, don't use "127.0.0.1" or any other IP address. use "sql.mydomain.com" type syntax. In fact, put the domain in the HOST file if you have a default win server configuration. Windows will check the host file first to resolve the domain - which saves a dns request. JDBC will attempt to resolve an ip into a domain name using reverse lookup before making a connection. In many cases this results in a lengthy initial connection request. Having a guaranteed resolution to a flqn (a la the host file) eliminates this problem. That's my short list - anyone else? Mark A. Kruger, CFG, MSCE www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com -Original Message- From: Bill Grover [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 8:11 AM To: CF-Talk Subject: RE: 100% CPU Ian, We have seen this behavior as well. When we start experiencing the page slowdowns and notice the jrun CPU very high we will stop and restart the CF Application Server, this "fixes" the problem. Yes the pages are down for a few seconds but in our environment this is not as big a problem as having the slow page response, or the page never coming up at all. __ Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com __ -Original Message- From: Ian Buzer [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 5:00 AM To: CF-Talk Subject: 100% CPU Hi all, We're running a CFMX 6.1 / SQL server 2000 app on a 1.6GHz AMD server with 1.5Gb of RAM. The app gets about 2.5 million page requests a month, peaking at about 7000 page requests per hour. Since yesterday morning it's suddenly started to misbehave, with the processor regularly maxing out at 100%. It will run clean an fast for 20 minutes or so, then suddenly requests will start to queue up and the whole thing grinds to a halt. Usually it recovers, but sometimes the service needs restarting to get it back. The app is well behaved, with most requests taking about half a second. There seem to be no particular long running requests that trigger it. This happened a couple of months ago and I restricted the amount of memory SQL server used and increased the RAM on the box to 1.5Gb. It currently appears to have about 3-400Mb free. I've installed the CFMX updater (released a few days ago), reinstalled ColdFusion, scandisked the drive and defragged. I wonder if anyone can give me any clues on what else to look for. Surely we should be able to get more traffic out of this spec machine? Many thanks Ian Buzer _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: 100% CPU
One more I forgot We have noted that the docs say the the "simultaneous requests" number in CF admin should be roughly 2x the number of procs. While this number works well on a busy cf 5 machine. It seems to be quite low for a cfmx platform. We've increased this number to between 8 and 13 on a dual proc machine and seen significant results. On a single proc machine I would try 6 and see what you get. -Mark -Original Message- From: Andrew Dixon [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 8:21 AM To: CF-Talk Subject: RE: 100% CPU Hi Ian. We have had this problem as well, on both Windows 2003 and Redhat Linux servers. There doesn't seems to be any logic cause of the problem and therefore no fix. The only way to work around the problem is to restart the server regularly. We have a scheduled task on both Windows and Linux to restart the service once a day, which seems in the most part to have fixed the problem, but it still happens from time to time. Best Regards Andrew. _ From: Ian Buzer [mailto:[EMAIL PROTECTED] Sent: 31 August 2004 10:00 To: CF-Talk Subject: 100% CPU Hi all, We're running a CFMX 6.1 / SQL server 2000 app on a 1.6GHz AMD server with 1.5Gb of RAM. The app gets about 2.5 million page requests a month, peaking at about 7000 page requests per hour. Since yesterday morning it's suddenly started to misbehave, with the processor regularly maxing out at 100%. It will run clean an fast for 20 minutes or so, then suddenly requests will start to queue up and the whole thing grinds to a halt. Usually it recovers, but sometimes the service needs restarting to get it back. The app is well behaved, with most requests taking about half a second. There seem to be no particular long running requests that trigger it. This happened a couple of months ago and I restricted the amount of memory SQL server used and increased the RAM on the box to 1.5Gb. It currently appears to have about 3-400Mb free. I've installed the CFMX updater (released a few days ago), reinstalled ColdFusion, scandisked the drive and defragged. I wonder if anyone can give me any clues on what else to look for. Surely we should be able to get more traffic out of this spec machine? Many thanks Ian Buzer _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: 100% CPU
Great info Mark, Didn;t knwo the ahile don't use IP for database bit. I want to stress on he one Mark almost forgot. At the machine in question's current proc speed I'd say 6 MAX and since you figure 4 max request ever I would lower it to 5. Even if you get 10 requests if the average load time is 1/2 second the longest wait would be about maybe 1 second Adam H > -Original Message- > From: Andrew Dixon [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 31, 2004 8:21 AM > To: CF-Talk > Subject: RE: 100% CPU > > Hi Ian. > > We have had this problem as well, on both Windows 2003 and Redhat Linux > servers. There doesn't seems to be any logic cause of the problem and > therefore no fix. The only way to work around the problem is to restart > the > server regularly. We have a scheduled task on both Windows and Linux to > restart the service once a day, which seems in the most part to have fixed > the problem, but it still happens from time to time. > > Best Regards > > Andrew. > > _ > > From: Ian Buzer [mailto:[EMAIL PROTECTED] > Sent: 31 August 2004 10:00 > To: CF-Talk > Subject: 100% CPU > > Hi all, > > We're running a CFMX 6.1 / SQL server 2000 app on a 1.6GHz AMD server with > 1.5Gb of RAM. The app gets about 2.5 million page requests a month, > peaking > > at about 7000 page requests per hour. > > Since yesterday morning it's suddenly started to misbehave, with the > processor regularly maxing out at 100%. It will run clean an fast for 20 > minutes or so, then suddenly requests will start to queue up and the > whole thing grinds to a halt. Usually it recovers, but sometimes the > service needs restarting to get it back. > > The app is well behaved, with most requests taking about half a second. > There seem to be no particular long running requests that trigger it. > > This happened a couple of months ago and I restricted the amount of memory > SQL server used and increased the RAM on the box to 1.5Gb. It currently > appears to have about 3-400Mb free. > > I've installed the CFMX updater (released a few days ago), reinstalled > ColdFusion, scandisked the drive and defragged. > > I wonder if anyone can give me any clues on what else to look for. Surely > we > should be able to get more traffic out of this spec machine? > > Many thanks > Ian Buzer > _ > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: 100% CPU
Thanks for the response. I'll work on this list and see if it doesn't help. Here is some responses to a few of your points. 1. On the server in question we don't have any access. Just SQL Server 2. I'll try the updated drivers. 8. SQL is not on the web server. Both boxes are separate servers. 9. Our names are not FQDN but are not IP addresses either. We just use the server name (sql-server). I'll play with the host file. __ Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com __ -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 9:41 AM To: CF-Talk Subject: RE: 100% CPU Bill, I went through a similar process with a client of ours. We did several things to mitigate this issue. 1. Eliminate Access dbs. If you have anything running on Access get rid of it. 2. Make sure and use the JDBC Merant 3.3 drivers for SQL - this is an update from 6.1. 3. Check out long running db requests - maintenance tasks, utility tasks, data imports, exports and dumps ect. Create a separate datasource for these, restrict the number of connections and deselect the "maintain db connections" for that db resource in cf admin. 4. Fiddle with the JVM maxperm memory, and heap sizes. Try to get them large enough so that the heap is not being constantly resized and garbage collection is efficient. There are a ton more JVM settings depending on the JVM you are using. 5. Use Perfmon to figure out which resource is hanging. 6. Consider increasing the process isolation in IIS for the application - it can tell you if IIS is having conflicts with other processes outside the ap. 7. Check the web logs for a burst of http requests at the point of failure. One customer I know created a dynamic publishing system with constantly updated content - then he used google adsense to serve ads and make himself money. But every time a new page was published (new to google) the googlebots attack to figure out which ads to serve. Since his server was near capacity this sometimes surfaced as a denial of service type attack (much like you are seeing) - and since many of his pages were driven by database calls it looked like a possible db problem - or connection issue etc. 8. Consider moving the SQL server Off of the web server. 9. Make sure and use a FQDN for the server name in the database administrator. In other words, don't use "127.0.0.1" or any other IP address. use "sql.mydomain.com" type syntax. In fact, put the domain in the HOST file if you have a default win server configuration. Windows will check the host file first to resolve the domain - which saves a dns request. JDBC will attempt to resolve an ip into a domain name using reverse lookup before making a connection. In many cases this results in a lengthy initial connection request. Having a guaranteed resolution to a flqn (a la the host file) eliminates this problem. That's my short list - anyone else? Mark A. Kruger, CFG, MSCE www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com -Original Message- From: Bill Grover [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 8:11 AM To: CF-Talk Subject: RE: 100% CPU Ian, We have seen this behavior as well. When we start experiencing the page slowdowns and notice the jrun CPU very high we will stop and restart the CF Application Server, this "fixes" the problem. Yes the pages are down for a few seconds but in our environment this is not as big a problem as having the slow page response, or the page never coming up at all. __ Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com __ -Original Message- From: Ian Buzer [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 5:00 AM To: CF-Talk Subject: 100% CPU Hi all, We're running a CFMX 6.1 / SQL server 2000 app on a 1.6GHz AMD server with 1.5Gb of RAM. The app gets about 2.5 million page requests a month, peaking at about 7000 page requests per hour. Since yesterday morning it's suddenly started to misbehave, with the processor regularly maxing out at 100%. It will run clean an fast for 20 minutes or so, then suddenly requests will start to queue up and the whole thing grinds to a halt. Usually it recovers, but sometimes the service needs restarting to get it back. The app is well behaved, with most reques
RE: 100% CPU
> We have noted that the docs say the the "simultaneous > requests" number in CF admin should be roughly 2x the number > of procs. While this number works well on a busy cf 5 > machine. It seems to be quite low for a cfmx platform. > We've increased this number to between 8 and 13 on a dual > proc machine and seen significant results. On a single proc > machine I would try 6 and see what you get. Unfortunately, finding the optimal value for this parameter really requires load testing. I do agree that the optimal value for CFMX is usually higher than it was for CF 5, based on the load tests I've seen. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: 100% CPU
Thanks for the response. I'll work on this list and see if it doesn't help. Here is some responses to a few of your points. 1. On the server in question we don't have any access. Just SQL Server 2. I'll try the updated drivers. 8. SQL is not on the web server. Both boxes are separate servers. 9. Our names are not FQDN but are not IP addresses either. We just use the server name (sql-server). I'll play with the host file. __ Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com __ -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 9:41 AM To: CF-Talk Subject: RE: 100% CPU Bill, I went through a similar process with a client of ours. We did several things to mitigate this issue. 1. Eliminate Access dbs. If you have anything running on Access get rid of it. 2. Make sure and use the JDBC Merant 3.3 drivers for SQL - this is an update from 6.1. 3. Check out long running db requests - maintenance tasks, utility tasks, data imports, exports and dumps ect. Create a separate datasource for these, restrict the number of connections and deselect the "maintain db connections" for that db resource in cf admin. 4. Fiddle with the JVM maxperm memory, and heap sizes. Try to get them large enough so that the heap is not being constantly resized and garbage collection is efficient. There are a ton more JVM settings depending on the JVM you are using. 5. Use Perfmon to figure out which resource is hanging. 6. Consider increasing the process isolation in IIS for the application - it can tell you if IIS is having conflicts with other processes outside the ap. 7. Check the web logs for a burst of http requests at the point of failure. One customer I know created a dynamic publishing system with constantly updated content - then he used google adsense to serve ads and make himself money. But every time a new page was published (new to google) the googlebots attack to figure out which ads to serve. Since his server was near capacity this sometimes surfaced as a denial of service type attack (much like you are seeing) - and since many of his pages were driven by database calls it looked like a possible db problem - or connection issue etc. 8. Consider moving the SQL server Off of the web server. 9. Make sure and use a FQDN for the server name in the database administrator. In other words, don't use "127.0.0.1" or any other IP address. use "sql.mydomain.com" type syntax. In fact, put the domain in the HOST file if you have a default win server configuration. Windows will check the host file first to resolve the domain - which saves a dns request. JDBC will attempt to resolve an ip into a domain name using reverse lookup before making a connection. In many cases this results in a lengthy initial connection request. Having a guaranteed resolution to a flqn (a la the host file) eliminates this problem. That's my short list - anyone else? Mark A. Kruger, CFG, MSCE www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: 100% CPU
Bill, FYI In regard to point 9 below. When you use a regular "server name" instead of a FLQN name you cause the JDBC server system to do the following: First it uses the unc service... check the host file for that string to resolve (no dice) check dns (also no dice) .move to rnc service (windows locator - basically a handoff to windows) check lmhosts file (if enabled and configured to do so)... check active directory created flqn on the nearest dc if you are on a domain ([EMAIL PROTECTED]) check Active dir on the master domain controller if nearest dc fails.. try to resolve the name using windows locator broadcasting It's a lot of hoops just for a friendlier naming scheme. Mostly, you just don't want windows to have to do this work for you. Windows networking is more dns based, but it still has a locator service with a fairly complicated heirarchy of resolution attempts. Instead, you want the JDBC service to bypass the application layer and get that name resolved prior to it arriving at the windows locator service. Simply ask yourself - "how is the server going to resolve this name". Mark Minasi's "mastering windows server 200x" books have some great information on how windows goes about this process. Mark A. Kruger, CFG, MSCE www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com -Original Message- From: Bill Grover [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 9:34 AM To: CF-Talk Subject: RE: 100% CPU Thanks for the response. I'll work on this list and see if it doesn't help. Here is some responses to a few of your points. 1. On the server in question we don't have any access. Just SQL Server 2. I'll try the updated drivers. 8. SQL is not on the web server. Both boxes are separate servers. 9. Our names are not FQDN but are not IP addresses either. We just use the server name (sql-server). I'll play with the host file. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: 100% CPU
Thanks for the info. I agree 100% not to make the system do all that work. I'm going to change the datasource definitions on my development server today. Since they will continue to work I'll change my live server tomorrow. __ Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com __ -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 11:02 AM To: CF-Talk Subject: RE: 100% CPU Bill, FYI In regard to point 9 below. When you use a regular "server name" instead of a FLQN name you cause the JDBC server system to do the following: First it uses the unc service... check the host file for that string to resolve (no dice) check dns (also no dice) .move to rnc service (windows locator - basically a handoff to windows) check lmhosts file (if enabled and configured to do so)... check active directory created flqn on the nearest dc if you are on a domain ([EMAIL PROTECTED]) check Active dir on the master domain controller if nearest dc fails.. try to resolve the name using windows locator broadcasting It's a lot of hoops just for a friendlier naming scheme. Mostly, you just don't want windows to have to do this work for you. Windows networking is more dns based, but it still has a locator service with a fairly complicated heirarchy of resolution attempts. Instead, you want the JDBC service to bypass the application layer and get that name resolved prior to it arriving at the windows locator service. Simply ask yourself - "how is the server going to resolve this name". Mark Minasi's "mastering windows server 200x" books have some great information on how windows goes about this process. Mark A. Kruger, CFG, MSCE www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com -Original Message- From: Bill Grover [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 9:34 AM To: CF-Talk Subject: RE: 100% CPU Thanks for the response. I'll work on this list and see if it doesn't help. Here is some responses to a few of your points. 1. On the server in question we don't have any access. Just SQL Server 2. I'll try the updated drivers. 8. SQL is not on the web server. Both boxes are separate servers. 9. Our names are not FQDN but are not IP addresses either. We just use the server name (sql-server). I'll play with the host file. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: 100% CPU
Hi all, An interesting update to this thread. I posted a message to the forums on the Macromedia site, and it got picked up by someone at Macromedia. Anyway, after sending him the contents of a few log files, it looks like he's traced it to a bug in the ColdFusion client variable purging system. Apparently there are bugs in this that cause connection leaks and it's slow which can cause a backup of requests. There is a hotfix for this at: http://www.macromedia.com/support/coldfusion/ts/documents/client_purge_hotfix.htm Apparently this wasn't included in the Updater? Also, there is a bug in the hotfix (!) which appears to mean that client variables are not deleted at all. This is to be fixed by another hotfix in the next few days but I am told it is better to apply the original hotfix in the mean time. So, if you are getting unexplained surges in CPU on an hourly basis (hourly from when the service is started) then this could be your problem. Ian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: 100% CPU
got a link to the thread on MM forums so we can monitor that as well? - Original Message - From: Ian Buzer <[EMAIL PROTECTED]> Date: Wed, 01 Sep 2004 12:36:15 -0400 Subject: Re: 100% CPU To: CF-Talk <[EMAIL PROTECTED]> Hi all, An interesting update to this thread. I posted a message to the forums on the Macromedia site, and it got picked up by someone at Macromedia. Anyway, after sending him the contents of a few log files, it looks like he's traced it to a bug in the ColdFusion client variable purging system. Apparently there are bugs in this that cause connection leaks and it's slow which can cause a backup of requests. There is a hotfix for this at: http://www.macromedia.com/support/coldfusion/ts/documents/client_purge_hotfix.htm Apparently this wasn't included in the Updater? Also, there is a bug in the hotfix (!) which appears to mean that client variables are not deleted at all. This is to be fixed by another hotfix in the next few days but I am told it is better to apply the original hotfix in the mean time. So, if you are getting unexplained surges in CPU on an hourly basis (hourly from when the service is started) then this could be your problem. Ian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: 100% CPU
>got a link to the thread on MM forums so we can monitor that as well? Sorry - all the diagnosis happened via email. Ian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Jrunsvc 100% cpu process
Hello everybody, I've a real big problem on my server side. In fact I've Coldfusion 6.1 Mx installed on, and IIS 6.0 under Windows 2003 Server std Edition, width mysql 4.1. Every 60 minutes jrunsvc takes 100 % cpu time, I've already patch the connector to the last updates, I've try to use JRUN updater 5, and a lot of other things, but nothing work good. On my server side I've more than 10 web entries, for multiple clients. I can't find any explaination about this problem, someone have an idea please ? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210078 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
CF7 100% CPU usage
Just installed CF7 on our Win2003 server a couple of days ago. Since then we've been having trouble with our site running slowly and certain large threads on our (in-house developed) discussion board timing out completely. I checked the CPU usage and, after a little experimentation, realized that accessing the large threads on our discussion board is what was killing the CPU with 100% usage. In 6.1 we never had this problem. I have to conclude that something on that page isn't working as efficiently in 7 as it was in 6.1. Is anyone aware of issues with 7 that would cause certain code that ran just fine in 6.1 to suddenly come to a screeching halt? Or perhaps someone might have an idea of something else it could be? Thanks! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234045 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
CFInsert and 100%CPU bug
I know Allaire denied it ever existed but in some circumstances CFUPDATE and CFINSERT can cause a 100%CPU usage problem. I'm wondering if anyone who has experienced this has solved it by applying CF4.5 Service pack or moving to CF5.0 I'm hoping to avoid the hassle of replacing 15 lines of code with an approx 140 lines in a CFQUERY Tristram Charnley ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Jrunsvc 100% cpu process
Long running SQL is no doubt the cause which is backing up requests. Do you have any long running requests? Reports, select * from large tables... ? -Original Message- From: Jean-Michel DE FILIPPI [mailto:[EMAIL PROTECTED] Sent: 21 June 2005 13:36 To: CF-Talk Subject: Jrunsvc 100% cpu process Hello everybody, I've a real big problem on my server side. In fact I've Coldfusion 6.1 Mx installed on, and IIS 6.0 under Windows 2003 Server std Edition, width mysql 4.1. Every 60 minutes jrunsvc takes 100 % cpu time, I've already patch the connector to the last updates, I've try to use JRUN updater 5, and a lot of other things, but nothing work good. On my server side I've more than 10 web entries, for multiple clients. I can't find any explaination about this problem, someone have an idea please ? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210079 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 : Jrunsvc 100% cpu process
I've a lot of long requests, but I never use select * FROM .. I'm using for example, SELECT cp.mycolumn, cv.lastname FROM c_particule cp, c_vector cv WHERE cp.id_c_table1 = cv.id_c_table2 Sometimes with a UNION command not more ... Do you think I need make something else ? I've read maybe jrunsvc donÂt like IIS 6.0 on windows server 2003 ?? -Message d'origine- De : Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] EnvoyÉ : mardi 21 juin 2005 15:04 : CF-Talk Objet : RE: Jrunsvc 100% cpu process Long running SQL is no doubt the cause which is backing up requests. Do you have any long running requests? Reports, select * from large tables... ? -Original Message- From: Jean-Michel DE FILIPPI [mailto:[EMAIL PROTECTED] Sent: 21 June 2005 13:36 To: CF-Talk Subject: Jrunsvc 100% cpu process Hello everybody, I've a real big problem on my server side. In fact I've Coldfusion 6.1 Mx installed on, and IIS 6.0 under Windows 2003 Server std Edition, width mysql 4.1. Every 60 minutes jrunsvc takes 100 % cpu time, I've already patch the connector to the last updates, I've try to use JRUN updater 5, and a lot of other things, but nothing work good. On my server side I've more than 10 web entries, for multiple clients. I can't find any explaination about this problem, someone have an idea please ? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210080 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: CF7 100% CPU usage
Do you have any CFC's which u are instantiating inside session scope ? -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 03 March 2006 14:40 To: CF-Talk Subject: CF7 100% CPU usage Just installed CF7 on our Win2003 server a couple of days ago. Since then we've been having trouble with our site running slowly and certain large threads on our (in-house developed) discussion board timing out completely. I checked the CPU usage and, after a little experimentation, realized that accessing the large threads on our discussion board is what was killing the CPU with 100% usage. In 6.1 we never had this problem. I have to conclude that something on that page isn't working as efficiently in 7 as it was in 6.1. Is anyone aware of issues with 7 that would cause certain code that ran just fine in 6.1 to suddenly come to a screeching halt? Or perhaps someone might have an idea of something else it could be? Thanks! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234059 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: CF7 100% CPU usage
> Do you have any CFC's which u are instantiating inside session scope ? Nope. Thanks for trying to help, though! Anybody else? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234068 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: CF7 100% CPU usage
>Just installed CF7 on our Win2003 server a couple of days ago. Since then >we've been having trouble with our site running slowly and certain large >threads on our (in-house developed) discussion board timing out completely. > >I checked the CPU usage and, after a little experimentation, realized that >accessing the large threads on our discussion board is what was killing the >CPU with 100% usage. In 6.1 we never had this problem. I have to conclude >that something on that page isn't working as efficiently in 7 as it was in >6.1. > >Is anyone aware of issues with 7 that would cause certain code that ran >just fine in 6.1 to suddenly come to a screeching halt? Or perhaps someone >might have an idea of something else it could be? Thanks! We've been having an issue with Verity eating up CPU cycles since upgrading, so if you've got any code relating to Verity in your code, you may check that. I'd recommend downloading the trial of SeeFusion (http://www.seefusion.com/) SeeFusion has a trace() method that you can invoke to dump messages to a SeeFusion Debug window. This is a very handy way of debugging templates in production--since the trace statements do not show up in the generated output. It also puts the execution millisecond timestamp next to each statement, so you have an idea of where things are slowing down at. -Dan ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234072 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: CF7 100% CPU usage
> SeeFusion has a trace() method that you can invoke to dump messages to a SeeFusion Debug window. Neat. I'll check that out. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234093 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: CF7 100% CPU usage
We had and still have a similar issue. We moved from a mixed CF 6/7 on windows 2000 to all cf 7 on windows 2003 and since the move performance has degraded. -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, March 03, 2006 1:42 PM To: CF-Talk Subject: Re: CF7 100% CPU usage > SeeFusion has a trace() method that you can invoke to dump messages to a SeeFusion Debug window. Neat. I'll check that out. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234101 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 : RE : Jrunsvc 100% cpu process
I've a lot of long requests, but I never use select * FROM .. I'm using for example, SELECT cp.mycolumn, cv.lastname FROM c_particule cp, c_vector cv WHERE cp.id_c_table1 = cv.id_c_table2 Sometimes with a UNION command not more ... Do you think I need make something else ? I've read maybe jrunsvc donÂt like IIS 6.0 on windows server 2003 ?? -Message d'origine- De : Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] EnvoyÉ : mardi 21 juin 2005 15:04 : CF-Talk Objet : RE: Jrunsvc 100% cpu process Long running SQL is no doubt the cause which is backing up requests. Do you have any long running requests? Reports, select * from large tables... ? -Original Message- From: Jean-Michel DE FILIPPI [mailto:[EMAIL PROTECTED] Sent: 21 June 2005 13:36 To: CF-Talk Subject: Jrunsvc 100% cpu process Hello everybody, I've a real big problem on my server side. In fact I've Coldfusion 6.1 Mx installed on, and IIS 6.0 under Windows 2003 Server std Edition, width mysql 4.1. Every 60 minutes jrunsvc takes 100 % cpu time, I've already patch the connector to the last updates, I've try to use JRUN updater 5, and a lot of other things, but nothing work good. On my server side I've more than 10 web entries, for multiple clients. I can't find any explaination about this problem, someone have an idea please ? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210081 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: RE : Jrunsvc 100% cpu process
It will run happily on IIS and 2003. There are many things you can do to improve performance. I always start at the configuration level and work back to the code - unless I "know" there is something in the code that is causing the problem. Start with: Server stuff - ram, processor, unecessary services, network card and card configuration etc. CF Ap Server stuff - settings in the CF Admin, jrun.xml and jvm.config files - Tuning the JVM can be especially helpful with an error like this. IIS Stuff - try separate application pools or web gardens. Now I'd look at the code. As a rule - all of the stuff above should be handled on the installation of a new production server. It's amazing to me how many production servers are tooling along using the default installation parameters. Remember, default installation of windows, iis, Coldfusion and the like is designed to cover the maximum number of installation scenarios - not to be the optimal configuration :) -Mark -Original Message- From: Jean-Michel DE FILIPPI [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 21, 2005 8:17 AM To: CF-Talk Subject: RE : Jrunsvc 100% cpu process I've a lot of long requests, but I never use select * FROM .. I'm using for example, SELECT cp.mycolumn, cv.lastname FROM c_particule cp, c_vector cv WHERE cp.id_c_table1 = cv.id_c_table2 Sometimes with a UNION command not more ... Do you think I need make something else ? I've read maybe jrunsvc donÂt like IIS 6.0 on windows server 2003 ?? -Message d'origine- De : Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] EnvoyÉ : mardi 21 juin 2005 15:04 : CF-Talk Objet : RE: Jrunsvc 100% cpu process Long running SQL is no doubt the cause which is backing up requests. Do you have any long running requests? Reports, select * from large tables... ? -Original Message- From: Jean-Michel DE FILIPPI [mailto:[EMAIL PROTECTED] Sent: 21 June 2005 13:36 To: CF-Talk Subject: Jrunsvc 100% cpu process Hello everybody, I've a real big problem on my server side. In fact I've Coldfusion 6.1 Mx installed on, and IIS 6.0 under Windows 2003 Server std Edition, width mysql 4.1. Every 60 minutes jrunsvc takes 100 % cpu time, I've already patch the connector to the last updates, I've try to use JRUN updater 5, and a lot of other things, but nothing work good. On my server side I've more than 10 web entries, for multiple clients. I can't find any explaination about this problem, someone have an idea please ? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210088 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: RE : Jrunsvc 100% cpu process
If you're using MS SQL, you could have bad drivers. Get the latest ones (3.4) from the hotfixes page. -nathan strutz Jean-Michel DE FILIPPI wrote: > I've a lot of long requests, but I never use select * FROM .. > > I'm using for example, SELECT cp.mycolumn, cv.lastname FROM c_particule > cp, c_vector cv WHERE cp.id_c_table1 = cv.id_c_table2 > > Sometimes with a UNION command not more ... > > Do you think I need make something else ? > > I've read maybe jrunsvc dont like IIS 6.0 on windows server 2003 ?? > > > -Message d'origine- > De : Robertson-Ravo, Neil (RX) > [mailto:[EMAIL PROTECTED] > EnvoyÉ : mardi 21 juin 2005 15:04 > : CF-Talk > Objet : RE: Jrunsvc 100% cpu process > > Long running SQL is no doubt the cause which is backing up requests. > Do > you have any long running requests? Reports, select * from large > tables... > > ? > > > > -Original Message- > From: Jean-Michel DE FILIPPI [mailto:[EMAIL PROTECTED] > Sent: 21 June 2005 13:36 > To: CF-Talk > Subject: Jrunsvc 100% cpu process > > Hello everybody, > > I've a real big problem on my server side. In fact I've Coldfusion 6.1 > Mx installed on, and IIS 6.0 under Windows 2003 Server std Edition, > width mysql 4.1. > > Every 60 minutes jrunsvc takes 100 % cpu time, I've already patch the > connector to the last updates, I've try to use JRUN updater 5, and a lot > of other things, but nothing work good. > On my server side I've more than 10 web entries, for multiple clients. > > I can't find any explaination about this problem, someone have an idea > please ? > > > > > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210119 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 : RE : Jrunsvc 100% cpu process
I'm using My SQL 4.01 and I've try with the latest drivers from macromedia, and it's continuing every 60 minutes JRUNSVC take 100% cpu time It's incredible !!! -Message d'origine- De : Nathan Strutz [mailto:[EMAIL PROTECTED] EnvoyÉ : mardi 21 juin 2005 17:45 : CF-Talk Objet : Re: RE : Jrunsvc 100% cpu process If you're using MS SQL, you could have bad drivers. Get the latest ones (3.4) from the hotfixes page. -nathan strutz Jean-Michel DE FILIPPI wrote: > I've a lot of long requests, but I never use select * FROM .. > > I'm using for example, SELECT cp.mycolumn, cv.lastname FROM c_particule > cp, c_vector cv WHERE cp.id_c_table1 = cv.id_c_table2 > > Sometimes with a UNION command not more ... > > Do you think I need make something else ? > > I've read maybe jrunsvc donÂt like IIS 6.0 on windows server 2003 ?? > > > -Message d'origine- > Deà : Robertson-Ravo, Neil (RX) > [mailto:[EMAIL PROTECTED] > Envoyà : mardi 21 juin 2005 15:04 > : CF-Talk > Objetà : RE: Jrunsvc 100% cpu process > > Long running SQL is no doubt the cause which is backing up requests. > Do > you have any long running requests? Reports, select * from large > tables... > > ? > > > > -Original Message- > From: Jean-Michel DE FILIPPI [mailto:[EMAIL PROTECTED] > Sent: 21 June 2005 13:36 > To: CF-Talk > Subject: Jrunsvc 100% cpu process > > Hello everybody, > > I've a real big problem on my server side. In fact I've Coldfusion 6.1 > Mx installed on, and IIS 6.0 under Windows 2003 Server std Edition, > width mysql 4.1. > > Every 60 minutes jrunsvc takes 100 % cpu time, I've already patch the > connector to the last updates, I've try to use JRUN updater 5, and a lot > of other things, but nothing work good. > On my server side I've more than 10 web entries, for multiple clients. > > I can't find any explaination about this problem, someone have an idea > please ? > > > > > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210130 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
CFStudio 5.0 takes up 100% CPU Utilization
Windows 2000 Professional CFStudio 5.0 The splash screen disappears and then the cpu utilization hits 99% and stays there. This just started happening and I have no idea what has caused this. Any ideas? Thanks, Jason - Jason Dowdell IM-AES Web Developer 321.799.6845 [EMAIL PROTECTED] - ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: RE : RE : Jrunsvc 100% cpu process
I would look at some of the JVM settings if I were you - heap size, max perm and the type of garbage collection in particular. -Mark -Original Message- From: Jean-Michel DE FILIPPI [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 21, 2005 11:48 AM To: CF-Talk Subject: RE : RE : Jrunsvc 100% cpu process I'm using My SQL 4.01 and I've try with the latest drivers from macromedia, and it's continuing every 60 minutes JRUNSVC take 100% cpu time It's incredible !!! -Message d'origine- De : Nathan Strutz [mailto:[EMAIL PROTECTED] EnvoyÉ : mardi 21 juin 2005 17:45 : CF-Talk Objet : Re: RE : Jrunsvc 100% cpu process If you're using MS SQL, you could have bad drivers. Get the latest ones (3.4) from the hotfixes page. -nathan strutz Jean-Michel DE FILIPPI wrote: > I've a lot of long requests, but I never use select * FROM .. > > I'm using for example, SELECT cp.mycolumn, cv.lastname FROM c_particule > cp, c_vector cv WHERE cp.id_c_table1 = cv.id_c_table2 > > Sometimes with a UNION command not more ... > > Do you think I need make something else ? > > I've read maybe jrunsvc donÂt like IIS 6.0 on windows server 2003 ?? > > > -Message d'origine- > Deà : Robertson-Ravo, Neil (RX) > [mailto:[EMAIL PROTECTED] > Envoyà : mardi 21 juin 2005 15:04 > : CF-Talk > Objetà : RE: Jrunsvc 100% cpu process > > Long running SQL is no doubt the cause which is backing up requests. > Do > you have any long running requests? Reports, select * from large > tables... > > ? > > > > -Original Message- > From: Jean-Michel DE FILIPPI [mailto:[EMAIL PROTECTED] > Sent: 21 June 2005 13:36 > To: CF-Talk > Subject: Jrunsvc 100% cpu process > > Hello everybody, > > I've a real big problem on my server side. In fact I've Coldfusion 6.1 > Mx installed on, and IIS 6.0 under Windows 2003 Server std Edition, > width mysql 4.1. > > Every 60 minutes jrunsvc takes 100 % cpu time, I've already patch the > connector to the last updates, I've try to use JRUN updater 5, and a lot > of other things, but nothing work good. > On my server side I've more than 10 web entries, for multiple clients. > > I can't find any explaination about this problem, someone have an idea > please ? > > > > > > > ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210135 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: CFStudio 5.0 takes up 100% CPU Utilization
Check out your server connections in the file browser. Every so often the FTP or RDS connection would get screwy on me, and would end up in memory loss. Although restarting the app would fix it. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Dowdell, Jason G [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 9:24 AM To: CF-Talk Subject: CFStudio 5.0 takes up 100% CPU Utilization Windows 2000 Professional CFStudio 5.0 The splash screen disappears and then the cpu utilization hits 99% and stays there. This just started happening and I have no idea what has caused this. Any ideas? Thanks, Jason - Jason Dowdell IM-AES Web Developer 321.799.6845 [EMAIL PROTECTED] - ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: CFStudio 5.0 takes up 100% CPU Utilization
Yeah, restarting the app isn't working at all because it won't restart. I was using the ftp functionality within cfstudio and I thought maybe a process got hung... So I restarted the pc but it didn't fix anything. ~Jason -Original Message- From: Adrocknaphobia Jones [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 9:30 AM To: CF-Talk Subject: RE: CFStudio 5.0 takes up 100% CPU Utilization Check out your server connections in the file browser. Every so often the FTP or RDS connection would get screwy on me, and would end up in memory loss. Although restarting the app would fix it. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Dowdell, Jason G [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 9:24 AM To: CF-Talk Subject: CFStudio 5.0 takes up 100% CPU Utilization Windows 2000 Professional CFStudio 5.0 The splash screen disappears and then the cpu utilization hits 99% and stays there. This just started happening and I have no idea what has caused this. Any ideas? Thanks, Jason - Jason Dowdell IM-AES Web Developer 321.799.6845 [EMAIL PROTECTED] - ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 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: CFStudio 5.0 takes up 100% CPU Utilization
Had the same thing happen before and in my case I had Startup configuration options set to start up in the last folder opened in the file dialog. In my case, that happened to be an RDS site which was not accessible any longer. Changing that path to a local drive within the registry level cured the problem. Ken -Original Message- From: Dowdell, Jason G [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 9:32 AM To: CF-Talk Subject: RE: CFStudio 5.0 takes up 100% CPU Utilization Yeah, restarting the app isn't working at all because it won't restart. I was using the ftp functionality within cfstudio and I thought maybe a process got hung... So I restarted the pc but it didn't fix anything. ~Jason -Original Message- From: Adrocknaphobia Jones [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 9:30 AM To: CF-Talk Subject: RE: CFStudio 5.0 takes up 100% CPU Utilization Check out your server connections in the file browser. Every so often the FTP or RDS connection would get screwy on me, and would end up in memory loss. Although restarting the app would fix it. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Dowdell, Jason G [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 9:24 AM To: CF-Talk Subject: CFStudio 5.0 takes up 100% CPU Utilization Windows 2000 Professional CFStudio 5.0 The splash screen disappears and then the cpu utilization hits 99% and stays there. This just started happening and I have no idea what has caused this. Any ideas? Thanks, Jason - Jason Dowdell IM-AES Web Developer 321.799.6845 [EMAIL PROTECTED] - ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: CFStudio 5.0 takes up 100% CPU Utilization
Where in the registry are those entries? That could definitely be it. ~Jason -Original Message- From: Ken Wilson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 10:19 AM To: CF-Talk Subject: RE: CFStudio 5.0 takes up 100% CPU Utilization Had the same thing happen before and in my case I had Startup configuration options set to start up in the last folder opened in the file dialog. In my case, that happened to be an RDS site which was not accessible any longer. Changing that path to a local drive within the registry level cured the problem. Ken -Original Message- From: Dowdell, Jason G [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 9:32 AM To: CF-Talk Subject: RE: CFStudio 5.0 takes up 100% CPU Utilization Yeah, restarting the app isn't working at all because it won't restart. I was using the ftp functionality within cfstudio and I thought maybe a process got hung... So I restarted the pc but it didn't fix anything. ~Jason -Original Message- From: Adrocknaphobia Jones [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 9:30 AM To: CF-Talk Subject: RE: CFStudio 5.0 takes up 100% CPU Utilization Check out your server connections in the file browser. Every so often the FTP or RDS connection would get screwy on me, and would end up in memory loss. Although restarting the app would fix it. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Dowdell, Jason G [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 9:24 AM To: CF-Talk Subject: CFStudio 5.0 takes up 100% CPU Utilization Windows 2000 Professional CFStudio 5.0 The splash screen disappears and then the cpu utilization hits 99% and stays there. This just started happening and I have no idea what has caused this. Any ideas? Thanks, Jason - Jason Dowdell IM-AES Web Developer 321.799.6845 [EMAIL PROTECTED] - ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: CFStudio 5.0 takes up 100% CPU Utilization
WooHoo!!! That was it. I just changed it to the temp directory and I'm back up and running. Thanks for the tip! ~Jason -Original Message- From: Ken Wilson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 10:19 AM To: CF-Talk Subject: RE: CFStudio 5.0 takes up 100% CPU Utilization Had the same thing happen before and in my case I had Startup configuration options set to start up in the last folder opened in the file dialog. In my case, that happened to be an RDS site which was not accessible any longer. Changing that path to a local drive within the registry level cured the problem. Ken -Original Message- From: Dowdell, Jason G [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 9:32 AM To: CF-Talk Subject: RE: CFStudio 5.0 takes up 100% CPU Utilization Yeah, restarting the app isn't working at all because it won't restart. I was using the ftp functionality within cfstudio and I thought maybe a process got hung... So I restarted the pc but it didn't fix anything. ~Jason -Original Message- From: Adrocknaphobia Jones [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 9:30 AM To: CF-Talk Subject: RE: CFStudio 5.0 takes up 100% CPU Utilization Check out your server connections in the file browser. Every so often the FTP or RDS connection would get screwy on me, and would end up in memory loss. Although restarting the app would fix it. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Dowdell, Jason G [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 9:24 AM To: CF-Talk Subject: CFStudio 5.0 takes up 100% CPU Utilization Windows 2000 Professional CFStudio 5.0 The splash screen disappears and then the cpu utilization hits 99% and stays there. This just started happening and I have no idea what has caused this. Any ideas? Thanks, Jason - Jason Dowdell IM-AES Web Developer 321.799.6845 [EMAIL PROTECTED] - ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: CFStudio 5.0 takes up 100% CPU Utilization
Wish I could point you to it easily but it's been a year now. All I recall is that they were buried reeeaaalll deep in it but once found it was obvious what to change. Sorry not to be more specific. Ken -Original Message- From: Dowdell, Jason G [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 10:30 AM To: CF-Talk Subject: RE: CFStudio 5.0 takes up 100% CPU Utilization Where in the registry are those entries? That could definitely be it. ~Jason -Original Message- From: Ken Wilson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 10:19 AM To: CF-Talk Subject: RE: CFStudio 5.0 takes up 100% CPU Utilization Had the same thing happen before and in my case I had Startup configuration options set to start up in the last folder opened in the file dialog. In my case, that happened to be an RDS site which was not accessible any longer. Changing that path to a local drive within the registry level cured the problem. Ken -Original Message- From: Dowdell, Jason G [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 9:32 AM To: CF-Talk Subject: RE: CFStudio 5.0 takes up 100% CPU Utilization Yeah, restarting the app isn't working at all because it won't restart. I was using the ftp functionality within cfstudio and I thought maybe a process got hung... So I restarted the pc but it didn't fix anything. ~Jason -Original Message- From: Adrocknaphobia Jones [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 9:30 AM To: CF-Talk Subject: RE: CFStudio 5.0 takes up 100% CPU Utilization Check out your server connections in the file browser. Every so often the FTP or RDS connection would get screwy on me, and would end up in memory loss. Although restarting the app would fix it. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Dowdell, Jason G [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 9:24 AM To: CF-Talk Subject: CFStudio 5.0 takes up 100% CPU Utilization Windows 2000 Professional CFStudio 5.0 The splash screen disappears and then the cpu utilization hits 99% and stays there. This just started happening and I have no idea what has caused this. Any ideas? Thanks, Jason - Jason Dowdell IM-AES Web Developer 321.799.6845 [EMAIL PROTECTED] - ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: CFStudio 5.0 takes up 100% CPU Utilization
Already found it... Thanks for pointing it out. ~Jason -Original Message- From: Ken Wilson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 10:41 AM To: CF-Talk Subject: RE: CFStudio 5.0 takes up 100% CPU Utilization Wish I could point you to it easily but it's been a year now. All I recall is that they were buried reeeaaalll deep in it but once found it was obvious what to change. Sorry not to be more specific. Ken -Original Message- From: Dowdell, Jason G [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 10:30 AM To: CF-Talk Subject: RE: CFStudio 5.0 takes up 100% CPU Utilization Where in the registry are those entries? That could definitely be it. ~Jason -Original Message- From: Ken Wilson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 10:19 AM To: CF-Talk Subject: RE: CFStudio 5.0 takes up 100% CPU Utilization Had the same thing happen before and in my case I had Startup configuration options set to start up in the last folder opened in the file dialog. In my case, that happened to be an RDS site which was not accessible any longer. Changing that path to a local drive within the registry level cured the problem. Ken -Original Message- From: Dowdell, Jason G [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 9:32 AM To: CF-Talk Subject: RE: CFStudio 5.0 takes up 100% CPU Utilization Yeah, restarting the app isn't working at all because it won't restart. I was using the ftp functionality within cfstudio and I thought maybe a process got hung... So I restarted the pc but it didn't fix anything. ~Jason -Original Message- From: Adrocknaphobia Jones [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 9:30 AM To: CF-Talk Subject: RE: CFStudio 5.0 takes up 100% CPU Utilization Check out your server connections in the file browser. Every so often the FTP or RDS connection would get screwy on me, and would end up in memory loss. Although restarting the app would fix it. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Dowdell, Jason G [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 9:24 AM To: CF-Talk Subject: CFStudio 5.0 takes up 100% CPU Utilization Windows 2000 Professional CFStudio 5.0 The splash screen disappears and then the cpu utilization hits 99% and stays there. This just started happening and I have no idea what has caused this. Any ideas? Thanks, Jason - Jason Dowdell IM-AES Web Developer 321.799.6845 [EMAIL PROTECTED] - ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
OT: SQL-7-Server piking to 100% CPU
Hi everybody, we have a MS-SQL-7 server piking (+ plateaus) to 100% CPU. It is caused by mssqlserver.exe. How can we find out, what database access is causing this, since I have about 20 DBs running on them ? All DBs are powering ColdFusion shop-systems. We have Win2000 server, SP4. Thanks for ideas. Uwe ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235847 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: SQL-7-Server piking to 100% CPU
Try experimenting with trace logs, there you should also be able to see how much cpu different actions/access takes. It can be hard to wade through all though. Some info here, for instance, or try google or the MSSQl help. http://www.databasejournal.com/features/mssql/article.php/10894_2239461_ 1 -- Hugo Ahlenius - Hugo Ahlenius E-Mail: [EMAIL PROTECTED] Project OfficerPhone: +46 8 412 1427 UNEP GRID-Arendal Fax:+46 8 723 0348 Stockholm Office Mobile: +46 733 467111 WWW: http://www.grida.no Skype:callto:fraxxinus - ### This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange. For more information, connect to http://www.f-secure.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235848 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
100% CPU on CF5 - but patch has already applied!
Hello all... I thought I would post this to the list, since my attempts to solve the problem have failed. I have run into an old problem. Well, sort of. I have the developer version of CF5 installed on my desktop at work, which is running XP Pro on a 2.8 GHz P4... and I am running into the 100% CPU usage caused by NTconsoleJava.exe - the ColdFusion Management Repository Server. But... here's the problem: I have applied the patches from Macromedia and deleted the logs, as according to: http://www.macromedia.com/support/coldfusion/ts/documents/tn18000.htm BUT I STILL HAVE THE PROBLEM!!! It's still doing it! Other than disabling the service, is there anything I can do to fix the problem? Has anyone run into this problem AFTER applying the patch? Is there another patch that I can't find? Sincerely, Brian Meloche, 4th Floor, ITO - 414 CSS (304) 759-0585 x448 Macromedia Certified Advanced ColdFusion 5.0 Developer 130 pounds lost and counting! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
100% CPU on CF5 - but patch has already applied!
It's not a coding issue. There wasn't any code running. This happens on startup. >Brian, > >Don't take this the wrong way. > >Have you checked your cf code and any queries that you are running? I have >had problems of 100% usage and generally it was due to a coding error or >very poorly written query. Since it is developer edition, you should know >which templates are running when it occurs, so I would start there. > >Steve > > >-Original Message- >From: BRIAN MELOCHE [mailto:[EMAIL PROTECTED] >Sent: Friday, July 18, 2003 11:35 AM >To: CF-Talk >Subject: 100% CPU on CF5 - but patch has already applied! > > >Hello all... > >I thought I would post this to the list, since my attempts to solve the >problem have failed. > >I have run into an old problem. Well, sort of. I have the developer >version of CF5 installed on my desktop at work, which is running XP Pro on a >2.8 GHz P4... and I am running into the 100% CPU usage caused by >NTconsoleJava.exe - the ColdFusion Management Repository Server. > >But... here's the problem: I have applied the patches from Macromedia and >deleted the logs, as according to: > >http://www.macromedia.com/support/coldfusion/ts/documents/tn18000.htm > >BUT I STILL HAVE THE PROBLEM!!! It's still doing it! > >Other than disabling the service, is there anything I can do to fix the >problem? Has anyone run into this problem AFTER applying the patch? Is >there another patch that I can't find? > >Sincerely, > >Brian Meloche, >4th Floor, ITO - 414 >CSS >(304) 759-0585 x448 >Macromedia Certified Advanced ColdFusion 5.0 Developer >130 pounds lost and counting! > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: SQL-7-Server piking to 100% CPU
[EMAIL PROTECTED] wrote: > Hi everybody, we have a MS-SQL-7 server piking (+ plateaus) to 100% CPU. > > It is caused by mssqlserver.exe. How can we find out, what database access is > causing this, > since I have about 20 DBs running on them ? All DBs are powering > ColdFusion shop-systems. Use Enterprise Manager... go to your database -> Management -> Current Activity -> Process Info That'll show you current queries that are running and stuff like that... it can be ver helpful for debugging issues. Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235852 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: OT: SQL-7-Server piking to 100% CPU
Probably your most effective tool to debug this is going to be the sql profiler. I would do a google on something like "sql profiler optimize long running query" to get some ideas on how best to set up the trace. With that tool, you can have sql keep a log of all kinds of statistics, and then use the Index Tuning Wizard to analyze the trace. I've seen a single index change make a query that would churn away for minutes (using 100% CPU), go down to something that ran in under a second. Also, the query optimization routines that SQL Server uses are not always perfect...and I've had them change query times drastically from SP to SP (especially when we were using SQL 7)so it's a good idea to run traces like this regularly, and make sure that your indexes are optimized. Make sure you run the tools on another machine...as there is quite a bit of overhead associated with them. On 3/21/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hi everybody, we have a MS-SQL-7 server piking (+ plateaus) to 100% CPU. > > It is caused by mssqlserver.exe. How can we find out, what database access is > causing this, > since I have about 20 DBs running on them ? All DBs are powering > ColdFusion shop-systems. > > We have Win2000 server, SP4. > > Thanks for ideas. > > Uwe > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235856 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[2]: SQL-7-Server piking to 100% CPU
Hi Hugo, and everybody who answered on my question. I will try most of the hints. Thanks a lot ! Uwe HA> Try experimenting with trace logs, there you should also be able to see HA> how much cpu different actions/access takes. It can be hard to wade HA> through all though. HA> Some info here, for instance, or try google or the MSSQl help. HA> http://www.databasejournal.com/features/mssql/article.php/10894_2239461_ HA> 1 HA> -- HA> Hugo Ahlenius HA> - HA> Hugo Ahlenius E-Mail: [EMAIL PROTECTED] HA> Project OfficerPhone: +46 8 412 1427 HA> UNEP GRID-Arendal Fax:+46 8 723 0348 HA> Stockholm Office Mobile: +46 733 467111 HA>WWW: http://www.grida.no HA>Skype:callto:fraxxinus HA> - HA> ### HA> This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange. HA> For more information, connect to http://www.f-secure.com/ HA> ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235893 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: 100% CPU on CF5 - but patch has already applied!
Brian, Don't take this the wrong way. Have you checked your cf code and any queries that you are running? I have had problems of 100% usage and generally it was due to a coding error or very poorly written query. Since it is developer edition, you should know which templates are running when it occurs, so I would start there. Steve -Original Message- From: BRIAN MELOCHE [mailto:[EMAIL PROTECTED] Sent: Friday, July 18, 2003 11:35 AM To: CF-Talk Subject: 100% CPU on CF5 - but patch has already applied! Hello all... I thought I would post this to the list, since my attempts to solve the problem have failed. I have run into an old problem. Well, sort of. I have the developer version of CF5 installed on my desktop at work, which is running XP Pro on a 2.8 GHz P4... and I am running into the 100% CPU usage caused by NTconsoleJava.exe - the ColdFusion Management Repository Server. But... here's the problem: I have applied the patches from Macromedia and deleted the logs, as according to: http://www.macromedia.com/support/coldfusion/ts/documents/tn18000.htm BUT I STILL HAVE THE PROBLEM!!! It's still doing it! Other than disabling the service, is there anything I can do to fix the problem? Has anyone run into this problem AFTER applying the patch? Is there another patch that I can't find? Sincerely, Brian Meloche, 4th Floor, ITO - 414 CSS (304) 759-0585 x448 Macromedia Certified Advanced ColdFusion 5.0 Developer 130 pounds lost and counting! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: 100% CPU on CF5 - but patch has already applied!
> It's not a coding issue. There wasn't any code running. > This happens on startup. No, the management service doesn't have anything to do with code. I know you asked for ways to fix the problem, but unless you're actually using the service, I'd just recommend that you turn it off. Perhaps you've enabled a server probe? I think that's handled by the management service, but don't recall for sure. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
dll to correct 100%CPU due to messages in /mail/spool/
I recall a while ago there was a .dll which was supposed to correct a problem with undelivered messages in C:\CFUSION\\mail\spool\ causing CFServer to use use 100% of the CPU time. Can someone point me to it? I tried searching the archives to no avail _ Get your FREE download of MSN Explorer at http://explorer.msn.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists