title: Classic ASP Bottlenecks
body: <p>I have 2 websites connecting to the same instance of MSSQL via classic ASP. Both websites are similar in nature and run similar queries.</p>
  
  <p>One website chokes up every once in a while, while the other website is fine. This leads me to believe MSSQL is not the problem, otherwise I would think the bottleneck would occur in both websites simultaneously.</p>
  
  <p>I've been trying to use Performance Monitor in Windows Server 2008 to locate the problem, but since everything is in aggregate form, it's hard to find the offending asp page.</p>
  
  <p>So I am looking for some troubleshooting tips...</p>
  
  <p>Is there a simple way to check all recent ASP pages and the see amount of time they ran for?</p>
  
  <p>Is there a simple way to see live page requests as they happen? </p>
  
  <p>I basically need to track down this offending code, but I am having a hard time seeing what happening in real-time through IIS.</p>