pull sql query execution location from either the sql server or IIS

Posted by jon3laze on Server Fault See other posts from Server Fault or by jon3laze
Published on 2011-03-15T05:03:02Z Indexed on 2011/03/15 16:12 UTC
Read the original article Hit count: 326

I am working on restructuring the database for a project that has hundreds of classic asp pages. I need to be able to find out which pages are executing which queries so that I can analyze the data. I am hoping there is some way to accomplish this without having to manually open each asp page and copy/paste the queries into a spreadsheet. I would imagine this should be something I could pull from possibly logs? Any info is appreciated.

  • IIS 7
  • MSSQL 2008 R2
  • Windows Web Server 2008 build 6001

© Server Fault or respective owner

Related posts about windows-server-2008

Related posts about sql-server