Bert Dawson wrote: > We're not using client variables (default storage in cfadmin=none, > clientManagement="No", no DSNs are configured to use client variables, > or have the tables in them).
Are you sure the username is the one that is used from CF then? > How would you suggest i use a manual checkpoint? Just open up query > analyser and run CHECKPOINT? Yes. > Also, have just profiler again, over a period of about 10 minutes > when there appeared to be no abnormal activity (according to CPU > usage), and there are still times where the number of SQLtransactions > appear v high (up to 9,000 in a second), so i'm begining to wonder if > this level of SQLTransactions/second is unusual, or just normal > activity... I think it would be unusual > 0-99 SQLtransactions/second: 650 > 100-999 SQLTransactions/sec: 19 > 1000-1999: 6 > 2000-2999: 4 > 3000-3999: 2 > 4000-4999: 3 > 5000-5999: 1 > 6000-6999: 3 > 7000-7999: 0 > 8000-8999: 2 > 9000-9999: 1 > > AFAIK the only thing happening to the dBs apart from getting hit by CF > is a backup of the transaction logs every 10 minutes, and a full > back-up every hour. Do the periods of high activity coincide with the transaction log backups? Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186336 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