T
TaeHo Yoo
Hi all,
I have a asp scripts which runs a stored procedure which runs for about
30 seconds to generate a dataset. Somehow this page generates the
time-out error. To find out what is wrong with page, I used SQL Profiler
to monitor on when the request hits the database and discovered that it
takes about 10 mins before the request shows up.. A lot of other
requests from various scripts appear and then by the time my script
generates the time-out error, SQL Profiler shows the request. How to fix
it? Is there any way of telling the sql server to put a priority on this
query first?
The following is the details of the request that SQL Profiler shows up
eventclass : SQL:BatchCompleted
Textdata: exec myscript blah blah
Application Name: Microsoft¢ç Windows¢ç Operating System
NT username:
LoginName : my login name
CPU : 157875
Duration :6128
Any idea will be fantastic!!!
Thanks
I have a asp scripts which runs a stored procedure which runs for about
30 seconds to generate a dataset. Somehow this page generates the
time-out error. To find out what is wrong with page, I used SQL Profiler
to monitor on when the request hits the database and discovered that it
takes about 10 mins before the request shows up.. A lot of other
requests from various scripts appear and then by the time my script
generates the time-out error, SQL Profiler shows the request. How to fix
it? Is there any way of telling the sql server to put a priority on this
query first?
The following is the details of the request that SQL Profiler shows up
eventclass : SQL:BatchCompleted
Textdata: exec myscript blah blah
Application Name: Microsoft¢ç Windows¢ç Operating System
NT username:
LoginName : my login name
CPU : 157875
Duration :6128
Any idea will be fantastic!!!
Thanks