tags:

views:

110

answers:

1

I found this site from MS:

Tracing Requests (IIS 6.0) - Microsoft TechNet

I set it up on my server as per the article and then used this to try and generate the report, but it keeps stating that RequestID cannot be found

My website seems to slow down during the day and all SQL inserts start taking 20 seconds to complete. I created an app which just flooded the SQL database with the inserts and those seem to work and used Empirix as well to flood the db.

Now I want to see the request in the worker process and why they seem to take long, but MS has left me abandoned...any other ideas/suggestions?

A: 

Instead of trying to trace the web requests, it might be easier to just run a SQL Profiler trace on your site when it starts getting slow.

David
david, that is running as well. I executed the sp in ? a few thousand times and it seems to work well when called froma c# test project. But when same library is called by the web project, the site slows down at diff times of the day. IIS logs keep showing Connection_Dropped
ltech