|
|
Home / Groups / ColdFusion Talk (CF-Talk)
Server slowly dying - Possibly a memory leak --- ColdFusion 7, MS SQL Server 2005 ExpressI suggested changing TCP port because someone might be hitting your SQL server from outside. It's easy to guess and target machines with default ports open. If you don't access SQL server remotely, I would suggest that you block remote access to the SQL server using a firewall. And yes, if you don't have a good antispyware and antivirus, install one now. Normally changing SQL server accounts passwords is a good practice. Server 2005 Express > As Dave stated, those services are consuming usual amount of memory. At > this > moment, in my development system, jrun.exe is consuming over 150 MB memory. > My system is still STABLE, I'm running multiple desktop apps, SQL and MySQL > services, Red5, AV, Anti-Spyware, over 4 different messenger apps, hosting > another OS in VmWare and multiple IE and FF windows. In past 9 years, I > have > never faced memory leaks problem with CF/Jrun. Everytime it went north of > 300-400 it was code related. Though consuming heavy WSDL services was an > issue few years back. > > Did you check your system for viruses and spywares? If no, I would suggest > running a proper check. > > Also change your SQL server's default TCP port. If you haven't done so > recently, change all passwords, including 'sa' account. > Are you suggesting this because the server might have spyware? > > Are you querying a large number of records? Try breaking them, use > pagination techniques. Did you add or change default JDBC drivers? Try > reverting them to shipped versions. I have not, they are the default. > > > - Sagar Gupta > > http://www.codecurry.com > > > Server > 2005 Express > > Hi All, > I'm hoping for a push in the right direction. My server's performance has > been slowing down lately only to finally come to a screeching for the last > 10 hours. I've turned off all other sites on the server and limited IIS to > my main site. I've also removed all the scheduled tasks, thinking that they > possibly were overlapping. > > The reason I believe I have a memory leak is bec when I restart the server > and/or the services everything works fine for a little while. Then SQL > Server and JRUN being to start eating up memory. > > Task Manager is currently showing: > SQLSERV.EXE 384,580 K > JRUN.EXR 105,016K > > The server is under very light load right now, anywhere between 1-3 request > per second. Can anyone please offer tips on steps I should take to resolve. > Does this sound like a memory leak to you? If so, what is the best tool > currently to use to find out what in my code is causing the memory leak? > > Thanks for any advice, > > Brett > > > > > |
Mailing Lists
|
Latest Fusion Authority Articles
|
