Take a look at New Relic. You can configure it to monitor both the hardware side of things (CPU, Ram, Paging, Disk use), web servers (IIS/Apache) and application servers like ColdFusion including SQL monitoring. It's a little pricy and for multiple sites would take a more advanced config but you'd be notified of server issues and can zero in on the offending app. I used it recently with a client running .NET and SQL server. The evolution of the site by a Ukranian dev meant sprawling, poorly optimized code. Within 4 hours I optimized the top 10 SQL queries and located the top 3 slowest running .NET page requests (and methods) not prohibited by slow SQL (without knowing much .NET).
On Mon, Jun 28, 2004 at 11:30 AM, Doug White <d...@clickdoug.com> wrote: > On a Windows 2003 server, running IIS 6.0, you can go into "computer > management" > 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 <http://www.houseoffusion.com/lists.cfm/link=t:4>] [This > Message <http://www.houseoffusion.com/lists.cfm/link=i:4:168249>] [ > Subscription <http://www.houseoffusion.com/lists.cfm/link=s:4>] [Fast > Unsubscribe<http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13357.12082.4>] > [User Settings <http://www.houseoffusion.com/signin/>] [Donations and > Support<https://www.paypal.com/cgi-bin/webscr?amount=&item_name=House+of+Fusion&business=donations%40houseoffusion.com&undefined_quantity=&cmd=_xclick>] > > ------------------------------ > <http://www.houseoffusion.com/banners/view.cfm?bannerid=11> > -- ~~~~~~~~~~~~~~~~~~~~~~~ Adam Howitt 312.714.9229 http://www.walkjogrun.net http://walkjogrun.net/iphone/go.cfm?m=earnshavian_em_ft ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357899 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
