It's in your Client Network Utility for your local machine and Server
Network Utility for the Server. Are you using MDAC 2.5? If so there is a
bug that might affect you that will make the server app really slow and
sometimes even timeout. You might want to check Microsoft for a hotfix on
your MDAC if you are using that version.
-----Original Message-----
From: Bruce, Rodney [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 10:34 AM
To: CF-Talk
Subject: RE: Way Slow web pages
Justin
Were is the option to choose between pipes and TCP/IP?
I'm looking in the SQL Manger properties but don't see it?
both are slow
-----Original Message-----
From: Justin Greene [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 24, 2001 5:56 PM
To: CF-Talk
Subject: RE: Way Slow web pages
Make sure to config the SQL client to use TCP/IP not named pipes (especially
if querying from a different machine), and try using SQL security rather
than NT security. Also what happens when you try to login using query
manager (using the same login the webserver uses) and run the query
manually. Login slow, query slow, both, neither?
Justin
-----Original Message-----
From: Bruce, Rodney [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 23, 2001 3:05 PM
To: CF-Talk
Subject: OT: Way Slow web pages
-- Spamex - Forums Now Available http://forums.spamex.com/forums/
-- Replies will be sent to [EMAIL PROTECTED]
-- Additional Info: http://www.spamex.com/i/?v=52
sorry about the very broad question.
but what are some things that could cause a web server to almost be 10times
slower.
web pages that were taking ~3,000ms are up to ~30,000. same with others that
were at ~200ms are at ~2,000.
is seems to be the query/db access time. it's affecting both Access and
SQL backed web pages.
Access itself seems to be running fine. but SQL Manager seems to be running
real slow. takes over 2 mins to just display a list of the tables when a db
is chosen. and then almost 4 mins to display the design table.
I have reviewed the logs, the only listing, but is not consistent is that
the administrator account fails on accessing \winlogon Object type:
desktop. EventID: 560 looks to be trying the access \winlogon once a sec.
but this is not going on all the time. This will happen for about 3 mins
then stop.
the changes to the server I can think of, MS office and SQL 7 have both been
reloaded. This is not an active server, once this problem gets fixed, it
will be, so work load is not a factor. It is a WINNT 4.0, 1 GB RAM, dual
800mhz CPUs. using CF 5.
I have tried to turn the different services off,(CF, WEB, SQL), but this
does not affect the problem.
I am at a loss. any suggestions will be appreciated.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
