and set up a number of performance monitoring tasks (PerfMon) which will create
logs that should give you what you want.
There are so many log files created at the server level, it does get confusing
from time to time. There are the event logs, the CF server and application
logs, the PerfMon logs, mail logs and probably more.
Using the WLExpert application, you can schedule daily (or weekly) IIS log file
analysis that will generate probably more information that you will ever use,
but among them is the bandwidth on an hourly or daily basis for each site, and
viewable via your browser.
The most common problem we have seen on hosted sites is SQL queries that are
sloppily written and not optimized for performance. In my opinion running a
looping query, or a long running query, and then having to do sub-queries before
returning a web page, is very inefficient of a web server. Instead, well
written queries should be able to return the data requited for one displayed
page, and when the visitor clicks on next, then the query returns the nest
subset. If one will check out the very large web sites, such as Google, Amazon,
etc. one will see that query of query is not used, and the data is returned
promptly even though the sites are receiving millions of hits per day. One
should try to time any scheduled tasks for late night or other off-peak hours,
to minimize the server load, and interference with web visitors.
According to most SQL gurus I have been in contact with, writing queries is
almost an art form.
Another observation is that a single server should be able to support well over
a hundred CF sites, and more,with moderate activity. That is, not to the scale
of Google or Amazon, who use clustered server farm environments which cost in
the millions to set up and support.
My 0.02
Doug
======================================
Our Anti-spam solution works!!
http://www.clickdoug.com/mailfilter.cfm
For hosting solutions http://www.clickdoug.com
http://www.forta.com/cf/isp/isp.cfm?isp_id=1069
======================================
i'm trying to figure out a good reliable way to measure statistically
how much my server is being taxed with the multiple sites I have running
on it. The server has about 10 sites on it and a management system that
is CF intensive. Is there a program that I can set on the server to
give me some good feedback throughout the day or is it just best to
examine the IIS logs? I basically want to stay on top of the hardware
aspect as we're adding some larger sites with significantly more traffic
and I want to make sure that our clients get good hosting for their
money and i want to be able to plan on getting a second dedicated server
if the need should arise (before it's too late). Let me know if you
know of any tools or methods for keeping up on this.
John Burns________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
