On Fri, Feb 6, 2009 at 8:36 AM, Gaulin, Mark <mgau...@globalspec.com> wrote: > > If you have SQL Server you can run the SQL profiler to watch for slow > queries; I've used this to isolate the queries that were actually slow > (lots of read/writes or cpu, for example) from the queries that were > slow because they were waiting for the other query to finish. This can > be much more effective than looking at the queries on slow pages because > you never really know why the page (or even the query that the page > does) is slow.
That's an excellent idea. I've never used SQL Profiler before... 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:318981 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4