Improve company productivity with a Business Account.Sign Up

x
?
Solved

web service bogging down

Posted on 2008-10-01
4
Medium Priority
?
330 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 2000 total points
ID: 22643194
I'd move the SQL server and CF server to different physical machines.
0

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Lease-to-own eliminates the expenditure of hardware replacement and allows you to pay off the server over time. Usually, this is much cheaper than leasing servers. Think of lease-to-own as credit without interest.
This installment of Make It Better gives Media Temple customers the latest news, plugins, and tutorials to make their Grid shared hosting experience that much smoother.
Free Data Recovery software is an advanced solution from Kernel Tools to recover data and files such as documents, emails, database, media and pictures, etc. It supports recovery from physical & logical drive after a hard disk crash, accidental/inte…
From store locators to asset tracking and route optimization, learn how leading companies are using Google Maps APIs throughout the customer journey to increase checkout conversions, boost user engagement, and optimize order fulfillment. Powered …

595 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