We have several in-house web based apps that use many asp calls. We recently migrated these applications from MS Access to SQLServer only to find that some of the asp calls run even slower on SQLServer. After researching we found that this is due to how our queries are done and many of them need to be reworked. We want to identify the slow queries. We started doing this manually using an older tool from Microsoft call WAS (Web Application Stress Tool) and it does half of what we need perfectly. It reports all query times in ms and allows us to keep this data in Access or convert it to Excel for analysis. But we could not get WAS to automatically play back scripts after recording. So, we tried using Test Complete with WAS. Test complete was used to ensure that every time we run the tests, the same steps and conditions are repeated and WAS will record the response time in ms. We are not concerned about multiple user testing at this time. Just identifiying slow queries and scripts. Test Complete, on playback, kept stopping on objects it cannot find. We can correct these and it would be great if we had the time to devote to debugging, but we are not trying to automate testing of entire application. We are simply trying to hit each query once and return ms it took to process and output this data preferably to Excel. We will run this maybe 5 or 6 times and never use it again. Our next option is QTP and the WAS tool, but we are certian we will have the same results at Test Complete. Does anyone know of another application that will let us quickly record clicking through a web application and returning just ms response time and not whether steps Passed or Failed?
Perhaps the SQLQueryStress tool? You can find it at http://www.apress.com/book/downloadfile/3498 (if we noobs can post links). It's a tool that's referred to quite a bit in Expert SQL Server 2005 Development from Apress, which I'll also recommend.