> So what is the consensus here that SQL server should be on seperate box or
> it can be on the
> same box as CF as long as the machine has plenty of ram and a fast
> processor?
It can be on the same box. Yes.
> -----Original Message-----
> From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, February 28, 2001 6:39 AM
> To: CF-Server
> Subject: RE: Hmmmm?
>
>
> Guys i'm a bit confused here am going to have to tell my boss to
> buy another
> box?
>
> So what is the consensus here that SQL server should be on seperate box or
> it can be on the
> same box as CF as long as the machine has plenty of ram and a fast
> processor?
>
> Kola
>
>
> -----Original Message-----
> From: Christian L. Watt [mailto:[EMAIL PROTECTED]]
> Sent: 27 February 2001 19:35
> To: CF-Server
> Subject: RE: Hmmmm?
>
>
> I have a similar setup with dual Xeon 933's and a gig of memory and run
> around 56,000 hits a day. No problems at all. Everything runs smooth as
> pie and no extensive memory usage and/or CPU usage. SQL and CF coincide
> wonderfully if you have a machine to handle it. I would not
> suggest putting
> a mail server on the same machine though. Just thought I would throw that
> out there since I have seen that in the past, and a mail server will hog a
> machine much quicker than anything else!
>
> CW
>
> -----Original Message-----
> From: Al Musella, DPM [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 27, 2001 12:31 PM
> To: CF-Server
> Subject: RE: Hmmmm?
>
>
>
>
> I recently put both sql server and cold fusion on the same server. I
> used to have them on separate boxes, but I found that having both together
> is working out much better than having them separate. Much faster, much
> more stable (I also went from windows NT to Windows 2000) - and much
> cheaper to co-locate:). Also - whenever the SQL server had to be
> rebooted,
> it also basically stopped the web serve from working - as most of my pages
> access the database. So there was 2 x as many chances of needing
> to reboot.
>
> My new box has dual 1,000 mhz pentium IIIs and a gig of memory. It
> has been about a month since it was booted, and the performance monitor
> shows 250megs free ram, so ram isn't a problem.. CPU is at about
> 4%. There are 140 current users on right now..
>
> Pages load much faster than under my old 2 computer system..
> so - what I am saying is that possibly adding enough memory and
> additional processor to 1 machine may be as good as having 2
> boxes with the
> same total amount of memory and processors. And memory is much cheaper
> than an internet connection, and you only need one copy of windows 2000
> advanced server.
>
>
>
> At 10:58 AM 2/27/2001 -0600, you wrote:
> > Actually, just like everything else, it depends on who is
> > administering and
> >writing the code for both. I've run over 50 websites that have over 100
> >sessions a day each on one server running CF and SQL. It just depends on
> >what your doing and what you need. If you write good DB
> Schema's and clean
> >CF code, then you can handle a lot with both. I just wouldn't suggest
> >putting 'Yahoo' on this setup. Again, limit SQL servers memory and you
> >shouldn't have problems of memory sharing violations. But if your just
> >launching a site or a couple of small sites, try it for a while
> before you
> >say those words that annoy me to death "throw hardware at it". You can
> save
> >a lot of money in hardware by having coders that know what their doing,
> >however you spend a lot of money paying these high end people:)
> >
> >-----Original Message-----
> >From: Ralph Stark [mailto:[EMAIL PROTECTED]]
> >Sent: Tuesday, February 27, 2001 4:01 PM
> >To: CF-Server
> >Subject: RE: Hmmmm?
> >
> >
> >According to an Allaire Certified Fast Track Trainer who I have
> spoken with
> >about this issue you should not have you SQL Server and your Cold Fusion
> >Server on the same box. It will work, but each service requires
> >CPU cycles an memory.
> >
> > >From: "Kola Oyedeji" <[EMAIL PROTECTED]>
> > >Reply-To: [EMAIL PROTECTED]
> > >To: CF-Server <[EMAIL PROTECTED]>
> > >Subject: RE: Hmmmm?
> > >Date: Tue, 27 Feb 2001 15:05:56 -0000
> > >
> > >Can i just ask is it recommended then not to have cold fusion and sql
> > >server
> > >on the same production box?
> > >
> > >-----Original Message-----
> > >From: Jacob Cameron [mailto:[EMAIL PROTECTED]]
> > >Sent: 27 February 2001 14:36
> > >To: CF-Server
> > >Subject: RE: Hmmmm?
> > >
> > >
> > > Sorry, that has not been my experience. There is no memory leak
> > in CF
> > >that
> > >I have found, just as there is no memory leak in ASP.
> However, in CF and
> > >ASP code can be written that does not release memory. In ASP, this is
> > >easy,
> > >in CF it's a little harder. I have ran an NT - CF Server
> getting over 1
> > >million hits a day for over 6 months without a reboot
> (nstorm.com). The
> > >only reason I had to reboot was my company got bought and we switched
> > >buildings. If your code is solid, there is no memory leak in CF 4.01 I
> > >know
> > >for sure. Currently all the sites I'm in charge of use cf
> 4.51 and they
> do
> > >not show signs of memory leaks. I'd suggest having the code
> looked at by
> a
> > >Senior developer in CF. They will be able to find the problem for you.
> > > TIPS: Don't store large amounts of information in
> application or
> > session
> > >variable
> > > Check for endless loops.
> > > Don't run large scheduled tasks on your production box.
> > > Lower session time.
> > >
> > >======================================
> > >Jacob Cameron
> > >Director of Information Technologies
> > >MultiMark Communications
> > >1801 Laws St.
> > >Dallas, TX 75202
> > >
> > >Tel: 214-871-9117 x104
> > >Fax: 214-303-0698
> > >
> > >E: [EMAIL PROTECTED]
> > >W: http://www.multimark.com/
> > >======================================
> > >
> > >-----Original Message-----
> > >From: Ralph Stark [mailto:[EMAIL PROTECTED]]
> > >Sent: Tuesday, February 27, 2001 2:07 PM
> > >To: CF-Server
> > >Subject: Re: Hmmmm?
> > >
> > >
> > >Yes you are correct. There is a memory leak with Cold Fusion. We
> currently
> > >run our server with 4GB of ram on each and have not had "many"
> problems.
> I
> > >have spoken with a couple of people at Albany CF Users group and found
> that
> > >they do not suggest running a production CF Server with less than 512MB
> of
> > >ram. Event then I would keep an eye on the memory usage. As it was
> > >explained
> > >to me the server is grabbing memory to use when it access your queries.
> > >Then
> > >the server holds on to this memory in the event you may need it again.
> Some
> > >helpful things I have been told are;
> > >
> > >1) Make sure your databases are not on the CF server.
> > >2) Scheduled reboots.
> > >3) Structures such as cfloops eat up memory fast.
> > >4) Make sure no session variables are just hanging out on the server.
> > >
> > >These few thing have made the memory leak less of an issue,
> but it still
> > >becomes a problem every once and a while.
> > >
> > >Hope this helps you out.
> > >
> > >
> > >
> > >
> > > >From: [EMAIL PROTECTED]
> > > >Reply-To: [EMAIL PROTECTED]
> > > >To: CF-Server <[EMAIL PROTECTED]>
> > > >Subject: Hmmmm?
> > > >Date: Mon, 26 Feb 2001 15:59:25 -0700
> > > >
> > > >I was wondering if anybody could offer any suggestions. We have 2
> > >servers
> > > >running cold fusion server 4.5.2, and one server running 4.0. When I
> > >check
> > > >the memory usage of the 4.0 machine it is somewhere around
> 4MB, when I
> > > >check
> > > >the 4.5.2 machines it is upwards of 16MB, and always increasing. The
> 4.0
> > > >machine has been up longer, but probably only gets about
> 40-50% of the
> > >hits
> > > >of the 4.5.2 servers. I was wondering if this looked normal
> to people.
> > > >The
> > > >one machine was rebooted after an upgrade about a week ago, and it's
> > >memory
> > > >usage has increased about 100% in that week. I am pretty new to CF
> > >Server,
> > > >and have an NT background, and this looks like a memory leak to me,
> with
> > >CF
> > > >Server not letting go of memory it takes.
> > > >Any thoughts anybody?
> > > >
> > > >Thanks,
> > > >
> > > >Thomas.
> > > >
> > > >
> > >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
