July 7, 2011 at 6:50 am
Hi group,
I have 20-25 Select queries that run in a stored proc which fails with "Time out" error. This stored proc runs from a DTS package. There is no other detailed info to pinpoint which statement is failing. It does not fail every night but once or twice a week. My assumption is it is failing when the client and the stored proc is accessing the same table at the same time since the queries collect the info about the current day of work but I am not 100% sure.
Is there a way to find which query is failing in the stored proc ?. If I run it manually, it will not fail. Please don't ask to change the process since client request the output in a specific format.
Any help would be appreciated.
Thnaks
Calvin.
July 7, 2011 at 7:29 am
You could:
A) Add some debug info to the stored procedure (log to a table or print and capture the output)
B) Trace the process with a server side trace
Probabyl you have other options, but this is what comes to my mind at hand.
-- Gianluca Sartori
July 7, 2011 at 9:16 am
Thanks..........I think I'll try trace (Not server side) since I know exactly when the process fails and the workload of the server is light at that time.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply