Is the load just really huge, or do you suspect a self-inflicted injury? See Mike's comments about well-indexed tables, etc.
The last time I saw something like this, there was clearly something going haywire on the database server. It turned out that someone had written a query which, under certain conditions, was creating a Cartesian product. Get 3 or four of those threads running on your SQL Server and you kill the whole site, but the first obvious sign will be CF starting to time out everything because it can't get any answers from the database. Start by running SQL Trace, and check current activity in Enterprise Manager to see if there are any very long-running threads. If you have a problem like this, the site will be humming along just fine, then SQL Server will suddenly just spike to 100% usage and stay there. If the growth is more gradual, you might just need to take a hard look at your overall data access strategy. More caching of queries, more stored procs, more careful coding to only return data you need in a query (hint, no more SELECT * statements). There are a hundred ways you can improve a site's performance, but once you get past the quick hits like proper indexing, it can take time to make the changes you need. >Yep, SQL Server 2000. Got any juicy tid-bits of info like "well, if you >click this button, everything works great"? > >At 04:04 PM 1/13/2005, you wrote: > > >-- >Jeffry Houser, Web Developer, Writer, Songwriter, Recording Engineer >AIM: Reboog711 | Phone: 1-203-379-0773 >-- >My Books: <http://www.instantcoldfusion.com> >My Recording Studio: <http://www.fcfstudios.com> >My Energetic Acoustic Rock Band: <http://www.farcryfly.com> >-- >When did Reality Become TV ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:5:142473 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
