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.
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.
Well, that's why need to work the developers to drill down the problem.
Have you able to trace down which page taking a long time to complete? and within the requested page what are those queries to SQL ?
Demitri-Mast...
2 Posts
How to know what .asp is executing a query on MSSQL
Oct 13, 2011 09:31 PM|LINK
Hello,
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.
qbernard
5016 Posts
MVP
Moderator
Re: How to know what .asp is executing a query on MSSQL
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.
Bernard Cheah
Demitri-Mast...
2 Posts
Re: How to know what .asp is executing a query on MSSQL
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.
qbernard
5016 Posts
MVP
Moderator
Re: How to know what .asp is executing a query on MSSQL
Oct 21, 2011 03:14 AM|LINK
Have you able to trace down which page taking a long time to complete? and within the requested page what are those queries to SQL ?
Bernard Cheah
HCamper
8048 Posts
Re: How to know what .asp is executing a query on MSSQL
Oct 30, 2011 03:43 PM|LINK
Hello,
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.
http://blogs.msdn.com/b/psssql/archive/2006/11/28/sql-server-becomes-sluggish-or-appears-to-stall-on-64-bit-installations.aspx .
Just a suggestion,
Martin
Community Member Award 2011