Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

procedure performance

Status
Not open for further replies.
cbsm

cbsm

Programmer
Oct 3, 2002
229
0
0
FR
Hi,
a procedure (among others ...) is executed - every 10 mins.
Sometimes (nothing special happens) - the performance decreases (usualy takes less than 1 minute -> 6 minutes).
If I recompile the procedure - it works fine again.

Does anyone has an idea what the problem can be ?

Thank you !
 
Status
Not open for further replies.

Similar threads

raphael75
  • Locked
  • Question
trying to call Sybase stored procedure with parameters from PHP
Replies
0
Views
55
raphael75
raphael75
vipinhcl
  • Locked
  • Question
Immediate not found error when running this procedure. Please help!
Replies
1
Views
43
PDreyer
PDreyer
mandogon
  • Locked
  • Question
90 Day Procedure
Replies
0
Views
27
mandogon
mandogon
holdahl
  • Locked
  • Question
output from sp_sysmon: I/O performance
Replies
0
Views
35
holdahl
holdahl
paraglidersd
  • Locked
  • Question
temp table traversal in stored procedure
Replies
1
Views
38
PDreyer
PDreyer

Part and Inventory Search

Sponsor

Back
Top