?
Solved

web service bogging down

Posted on 2008-10-01
4
Medium Priority
?
298 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 2000 total points
ID: 22643194
I'd move the SQL server and CF server to different physical machines.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Periodically we have to update or add SSL certificates for customers. Depending upon your hosting plan you may be responsible for the installation and/or key generation. In the wake of Heartbleed many sites were forced to re-key. We will concen…
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

770 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