Portal Home > Knowledgebase > Articles Database > Web application testing tool
Posted by prashant1979, 03-22-2012, 06:07 AM One of my customers who develops websites in languages like asp and asp.net is facing performance issues with a few websites. Those websites always consume huge cpu resources. Whenever any of these websites is accessed, the w3wp.exe and SQL server process use major chunk of the Processor and the CPU usage is always 100%. He is not sure what optimization he needs to do in the websites so that the websites don't consume resources. Is there any tool available which can scan through all the scripts and suggest ways to optimize the same?
Posted by gotlivechat, 03-23-2012, 09:14 AM Not sure of one certain script that will cover ASP, ASP.NET and SQL. I would Google terms like ASP PERFORMANCE TIPS ASP.NET PERFORMANCE TIPS SQL PERFORMANCE TIPS so your customer can match their current programs with those recommended by others. Some basic tips?... 1) ensure database opened DB connections are then closed. This is common for programmers to not have closed DB connection in script. 2) if using SQL SERVER run performance/speed scripts within console - it may give some tips on optimizing reads/writes.
Add to Favourites 
Print this Article
