IIS 5 & IIS 6
How to know what .asp is executing a query on MSSQL
Last post Oct 30, 2011 03:43 PM by HCamper
Oct 13, 2011 09:31 PM|LINK
It`s possible knows what file .asp executing a query on MSSQL ?
I need to troubleshoot the locks on tables and the programmer asked me to get this information.
Oct 14, 2011 03:37 AM|LINK
Maybe debug diag...
or FREB at request tracing for IIS 7.
Can you tell from SQL end ? i mean from the executing queries running based on the query statement, not able to link back to which asp file?
in the past, I used to dig into IIS log, then find those ASP pages that take a looooongg time to complete (time-taken), then dig into the ASP file, try to do time stamping within the code itself to see which routine/function/procedures call spent most of
the time, then dig further down to that section then all the way down to sql.
Oct 20, 2011 11:37 AM|LINK
Some querys on SQL like simples selects begin stucked on MSSQL with a wainting command or sleeping, after all day, the queries start to slowdown the system and users experiencing time-outs.
I think the programmer won`t put points to rollback or commit a transaction if the user close the page or something else.
Oct 21, 2011 03:14 AM|LINK
Oct 30, 2011 03:43 PM|LINK
To trouble shoot locks on tables and other performance problems for SQL Server.
You or the Programmer should look at "Microsoft Customer Service and Support (CSS) SQL Support." Blog.
Just a suggestion,