Bert Dawson wrote: > I've got a SQL server box that ticks along quite happily at about 15% > CPU, but occasionally goes up to around 40% and stays there for > anything up to a minute. During these peaks the jrpp.delayMs can start > to climb, up to from a few seconds up to hundreds of seconds. I also > start getting a few timeouts in the application log. (timeout is se to > 35 seconds)
Do you get the same behaviour when using a manual checkpoint? > I ran a SQL profile trace and spotted that during the peaks there were > massive numbers of "SQLTransaction entries": over a 2.5 minute period > there are ussually about 12 SQLTransactions per second, but this hit a > maximm of 16283, which sounds like a lot to me! Are you using client variables? Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186167 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
