I am using MS-Web Application stress test tool(WAST)to test the performace of my website. when my script hits the website,i would like to track down the database activities.
Is there any performance counter avaliable to track the database activities when a POST request in a script interacts with database.
I too use the SQL server profiler, however it needs to be noted that the overall performance observed when the SQL server profiler is running is a lot slower than normal due to the big sized foot print of the SQL server profiler. We usually run the SQL server profiler only to fine tune database performance by rebuilding indexes, and so on.