Yes, that's right: if it's set to registry (and any code is set to enable ClientManagement and doesn't specify a different ClientStorage, both settable in CFAPPLICATION or application.cfc), then yes, the i/o is to a file that simulates the registry (called registry.db, which I think is in the [cf]\lib directory on Linux.) If there's a lot of reading/writing there, it could be a real drain-but of course would not have any direct impact on SQL Server CPU being high.
But you say you "have yours set to registry", and by that I assume you mean it's selected as the default client storage (on the client variables page, for those trying to follow along). The question, though, is whether you have any DSNs listed on that page also. If you do, then even though the registry is the chosen default, again an application could change that by specifying it with the ClientStorage attribute (discussed above). In that case, requests to that app would use that DB. Again, if you have any at all, then I'd recommend you wrap it with FR and track what sort of I/O is going on, bringing things back to your original question. And if you want to know more about the whole matter of the potential performance impact of client variables, and how to analyze it and mitigate it, see the resources I've written, presented, or recorded on the matter: http://carehart.org/presentations/#sessclicrash http://www.carehart.org/blog/client/index.cfm/2006/10/4/bots_and_spiders_and_poor_CF_p erformance Hope that helps. /charlie From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Gavin Beau Baumanis Sent: Sunday, November 28, 2010 11:33 PM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] Re: Microsoft SQL server CPU very high, close to 100% a lot of the time As for the client settings / DSN. What is the recommendation then? We have ours set to registry. Though since we're on linux and we don;t have a registry - I am guessing it using some sort of text file.... but it is only a guess! Gavin "Beau" Baumanis -- 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.