Eventually I'm going to want to solve these spikes.. I think SQL Profiler might help me figure stuff out but also having Cacti installed and monitoring network and disk and cpu activity more accurately than the task manager might help me debug some things to.
So, my server is experience fairly rhthmic request activity spikes where for 10 seconds or so, fusion reactor shows a whole bunch of active requests... while I'm normally cruising along at 5-10 requests per second, I'll suddenly get 20 active requests and FR will queue new requests. So far I've been unable to figure out what's going on. But one interesting thing I just noted while comparing my request activity, jdbc activity, cpu and memory graphs.... I had one of these spikes at 11:55 today... my active requests spiked to 20 for about 20 seconds, while competed requests dropped down to 0 per second for a good 10 seconds. at the same time, JDBC activity dropped to 1 active request and 0 completed requests per second for about 15 seconds. The normal is 30-50 completed JDBC queries per second. the memory graph shows nothing unusual. The CPU graph shows the overall and instance cpu dropping to almost nothing. Which strikes me as a little odd.. I mean, let's say there is some application.cfm code that uses an exclusive named lock, and it includes a query that hits the database. If that query, for some reason, ran for 15 seconds (god forbid), I could understand this happening.. all the other requests would have to sit and wait for the lock to be released, and it woudl explain why only one query was running Unless it *IS* the database, in which case the lock would hang up on all three instances at the same time But the thing is... it's rhythmic... but not so rhythmic it can be attributed to some kind of scheduled task on the database server... but it is relative to system activity.. ie, the busier the site is, the more often these spikes occur. So I'm thinking.. MAYBE SQL Server is doing something that's causing it to slow down for 15 seconds .. but it's not going along with any kind of database maintenance, scheduled tasks or scheduled backups, etc... OTHER Than my already intended plans of using SQL Profiler to do some more SQL monitoring... and cacti to monitor the servers via SNMP ... are there any other suggestions? Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318985 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
