Solved

web service bogging down

Posted on 2008-10-01
4
290 Views
Last Modified: 2013-12-24
Web Services bog down during busy times, looking for ways to id the probelm
We run, servier 2003 sp2
Xeon 2ghz with 6 gb ram
runs IIS, Coldfusion 8 and ms Sql 2005

During month end we the server frequently slows down or stops serving up web pages. Sometimes i see SQL taking 80% of the processer and Jrun at 20%
what would you do first to track down the problem or what would u recommend doing to prevent the slowdown?

0
Comment
Question by:kleigh
  • 2
4 Comments
 
LVL 19

Expert Comment

by:erikTsomik
ID: 22614728
check the space on your hard drive make sure that it has space
Also check log files maybe they are busy so CF can not write into. SO it may reqired rotation.

THose are few think that I would think about it first.
0
 

Author Comment

by:kleigh
ID: 22617899
looks like MSSQl is the culpret, MSSQL takes all resources every 5 minutes or so...
0
 
LVL 19

Expert Comment

by:erikTsomik
ID: 22618022
check sql log files, maybe the backup files are full
0
 
LVL 4

Accepted Solution

by:
BSSupport earned 500 total points
ID: 22643194
I'd move the SQL server and CF server to different physical machines.
0

Featured Post

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question