| Stored Procedure Running Continuously [message #356959] |
Mon, 03 November 2008 06:00  |
madhava.maganti
Messages: 4
Registered: February 2008
Location: Mumbai
|
Junior Member |
|
|
We have one preparation stored procedure with set of DDL (Insert,Update Delete) and TCL(Commit, Rollback) statements. This stored procedure is calling by one of the Informatica workflow. Now the problem is stored procedure sometimes will take long time(upto 6hrs) to finish the process and the same stored procedure sometimes will also finish the execution in between 15 to 20 mins.
We are having this issue from past 6 months but from past 6 months we have a temporary solution to rebuilding indexes and analyzing the statistics manually. But now we automate that process (Rebuilding Indexes) it in one stored procedure. Even though we are facing same problem(take long time to finish the process. Please advice how should I overcome this issue.
Thanks in Advacne!
Madhava
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
