Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Hommer
Aged Yak Warrior
808 Posts |
 Posted - 2005-04-15 : 09:49:22
|
| I know it is a bad idea to have SQL Server and Web server on the same machine, but in this case it is just a test/dev box, and at any given time, it will only have handful of testers access it.Ok, here is the problem statement. In the last two days, the test web site is awfully slow, and some time, it is home page is not coming up at all. Instead, following message shows after maybe 20 minutes of trying to fetch the html page. Server ErrorThe server encountered an internal error and was unable to complete your request. JRun closed connection.In task Manager, sqlservr.exe process shows CPU 99%, Mem usage 699,000K. Also, restart the sql server could temporally relieve the problem. Nothing (software/hardware) has been added for the last couple days, and the site worked fine for the last two weeks.The SQL Server has a default mem of 2g, and the box has 4g of ram.I’d appreciate any help! |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-04-15 : 10:20:23
|
| yeah it is a bad idea. so is having developers developing on a box being used for testing. But a handfull (depending on you concept of handful) of users and developers should be OK.I suspect some young developer has a horrible query running or an infinite loop in his code or some recursion without a proper exit code or has some objects not being destroyed or .....(fill in the blank with your favorite JV mistake) Have checked for blocking issues?Have your tried running a profiler trace from another machine to capture all sql hitting the sql server?Sean Roussy |
 |
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-04-15 : 13:47:10
|
| What is 'JRun'? |
|
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2005-04-15 : 13:59:46
|
| Some kind of Java Runtime. The web site is hosted in IIS6, but uses Micromedia ColdFusion as server script. |
|
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-04-15 : 14:08:27
|
| Not familiar with it, but I googled this:http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19300 |
|
|
|
|
|
|
|
|
sql server took away too much system resource?