I think there are a couple of different ways to connect to the MSSQL engines... Socket connections for example and a few flavors of drivers I believe. If I am correct you might try them to see what effect it has. I am connected to SQL2000 via a socket driver I think it was called.
for what its worth ;-( At 03:17 PM 11/27/02, you wrote: >There seems to be something to this issue.. Which we have noted in the >thread I mentioned in an earlier post from MM's forum. When SQL (2K or >7) is on the same box, this tends not to happen. However, I recall that >we had at least one instance of it occuring regardless of the fact that >SQL was on the same box. (Brook, can you confirm/deny this for me? I >thought you were involved in that convo.) At any rate, it DOES appear >to be DB/DB Driver related. How, specifically, I don't know. And so >far, neither does anyone else, from what I have heard/seen/read. > >If you missed my post of the thread location, here it is: > > >http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=143&thr >eadid=468954 > >HTH > > Lee > > >| -----Original Message----- >| From: Fitch, Tyler [mailto:[EMAIL PROTECTED]] >| Sent: Wednesday, November 27, 2002 3:10 PM >| To: CF-Talk >| Subject: RE: CFMX Server Crash #4 for the day.. >| >| >| We sure are. MSSQL 2k though. That's the only difference I've seen. >| >| t >| >| ********************************************************************** >| Tyler M. Fitch >| Certified Advanced ColdFusion 5 Developer http://isitedesign.com >| ********************************************************************** >| >| -----Original Message----- >| From: Brook Davies [mailto:[EMAIL PROTECTED]] >| Sent: Wednesday, November 27, 2002 3:06 PM >| To: CF-Talk >| Subject: RE: CFMX Server Crash #4 for the day.. >| >| >| I'm going to guess that your not running SQL Server on a >| separate box. Are you? >| >| At 04:00 PM 27/11/02 -0700, you wrote: >| >Brook, >| > >| >Since people only seem to mention CFMX when it does bad, I'm going to >| >mention when it does good. >| > >| >I've personally had atleast half dozen CFMX installs go fine. The >| >sites on the boxes run fine. Even under load. So I for one >| say 'CFMX >| >is ready for production. (just build your site to take advantage of >| >it)'. I would and do recommend it for anyone looking to build a web >| >app. >| > >| >We launched a pretty good site that was half CFMX, half CF5 >| less than a >| >| >month after CFMX's release date. No updater was available and we had >| >no problems. The network load-balancing solution our client had >| >selected went down before the CF servers did under load. >| > >| >We had 200 simulateous requests chugging along on our Win2k >| server with >| >| >IIS5. If your server is crashing at 6 I'd check your code first and >| >stop complaining about the server. Something bigger seems >| to be going >| >on. >| > >| >If you upgraded from 5, then did you test your app before hand? Any >| >load testing would have brought this problem up. >| > >| >Good luck, >| > >| >t >| > >| >************************************************************* >| ********* >| >Tyler M. Fitch >| >Certified Advanced ColdFusion 5 Developer http://isitedesign.com >| >************************************************************* >| ********* >| > >| >-----Original Message----- >| >From: Brook Davies [mailto:[EMAIL PROTECTED]] >| >Sent: Wednesday, November 27, 2002 2:45 PM >| >To: CF-Talk >| >Subject: CFMX Server Crash #4 for the day.. >| > >| > >| >Well, our CFMX server just crashed for the 4th time today. >| I've had the >| >| >perfmon open all day and have been watching the traffic. We had an >| >average of 12 connections when the running requests started >| to grow and >| >| >grow. As I >| >mentioned in my previous post, there were 3 running requests >| that had >| >not finished for hours. As far as the number of CFMX >| request, as I was >| >watching >| >it, it never went above 6. This really means there was a max of 3 >| >running >| >requests (on top of the 3 that were already dead), it would >| go up to 6 >| >and >| >then back down to 3. Those 3 threads weren't going anywhere. >| > >| >Then I noticed that the running requests was growing >| incrementally, so >| >I >| > >| >tried to make an HTTP request to the server....and it did >| not respond. >| >I >| > >| >checked the running requests, and there was one more. The server was >| >DEAD, HUNG, FINISHED - KAPUT. >| > >| >The Perfmon counter restarted jrun when the running requests reached >| >10, >| > >| >and the server came back to life. Thank you Lee Fuller for this >| >temporary fix. >| > >| >What is Macromedia doing about this? CFMX is not ready for >| production. >| >If your sales of CFMX are not what you expected, there's a fairly >| >obvious reason why. I certainly, based on my experience, would not >| >recommend (and I >| >think anyone running CFMX would agree) anyone to switch to >| CFMX anytime >| >soon. Unless you have plenty of spare time to baby sit your server. >| > >| >Brook >| > >| > >| > >| > >| > >| >| > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
