Barry, I would just wonder if perhaps you're suffering the "death of a thousand cuts", where it's not that you have any (or many) long-running (or even moderately long-running queries), but instead maybe lots (and lots) of small-running requests. Just something to consider.
And as for using FR, I would recommend that you do NOT limit what is logged (and be aware that there is a separate setting on the JDBC settings page for first what is shown in the interface, and what is logged). And of course it's critical that you wrap *all* datasources being used-not just those that you think "might be a problem", as there could be requests coming in (again, perhaps from bots) going against a DB (and app) you think is otherwise insignificant. Finally, you should be sure to wrap (with FR) especially any DSN set to be a client variable datasource. Again, I find this is often a huge resource-suck, with ever page request generating multiple i/o's to the cglobal table. /charlie From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Barry Chesterman Sent: Sunday, November 28, 2010 5:14 PM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] Re: Microsoft SQL server CPU very high, close to 100% a lot of the time Thanks Charlie, It is SQL running on its own box, I'll get the DBA to check what else is running (such as antivirus). I'm pretty sure he checked the event logs and there was nothing odd there, he pretty much said that the query activity is normal, just that there is a very high volume of queries coming through. We did look at the queries coming through and there were no queries in particular that stood out as causing additional CPU usage, all the queries completed executing in a very quick time. The only SQL monitoring we have is on one of our 4 front end servers, and that's just FusionReactor monitoring at most 30 queries per request, and only queries above 2 miliseconds. I did have it on 50 queries and anything above 0ms for 10 or so minutes, but I haven't spotted anything (nor has our DBA) that looks out of place. We haven't got the validation query thing on. We haven't spied any kind of hack attacks in our http logs (I did disable one of our pages that gets hit a lot and does a decent number of queries, but the DBA said it pretty much had no effect). I'll check out the client variables setting, but I'm pretty sure that setting is all good as well. I did look up the updater notes and there was nothing I could find about database performance or anything similar. I'll find out if there are any SQL patches that may be required too. Cheers Barry. -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
