Hi Paul, Use Tracing as well as use Profile like RedGate's ANTS Profiler or Jetbrains Profiler, they are both great and well worth the money, they will go to extent to even find our slowest lines of code.
Also have a close look at SQL Profiler, I think 90% of web pages unresponsiveness happens because of the incorrect database usage (like 15-20 db hits for a single page request). It may also happen that your tables are locked at times, to get a quick a dirty workaround you can try SELECT * from tablename(NOLOCK)...your query, if this brings result quickly but not without (NOLOCK), this means there are table locks. Best Regards, Parag C Mehta. iParag.com Paul Cowan wrote:
Hi all, I have am having a performance problem and would like some advice on how to best identify the bottle necks etc. It is an ASP.NET that is blazing fast locally but when I put it on the remote windows 2003 box, performance is really poor. Even taking into account that I am accessing the site remotely does not take into account the difference of speed. What profiling software do people use? The site is hosted and it is almost like some load balancer or something is getting in the way. Can anyone give me any tips on where to start my investigation. The page request time seems slow, once the page starts rendering it is quite quick but actually navigating takes time. Cheers [EMAIL PROTECTED] _________________________________________________________________ The next generation of MSN Hotmail has arrived - Windows Live Hotmail http://www.newhotmail.co.uk =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
=================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
