September 29, 2008 at 4:50 am
Hi,
i have not drop procedure cache , sp's(stored procedure) also not starting with sp_ , executing the sp with owner name,data base and sp alos not having temp table and cursors .but sp were getting recompiled for some time in production server .i dont know the reason .
SQL Server : 2005 Enterprise Edtion(Clustering)
Sevice Pack : 2
Cumulative : 8
Ram : 16 GB
Give yours suggestion to resovle this issue.
Thanks in Advance.
September 29, 2008 at 5:12 am
Could be, especially if your environment is one where a lot of passthrough queries are sent to the system and these sp's are not run that often, that they're getting 'aged out'.
That's just a pretty random guess, tbh, though given how little info you've provided. Could you provide a little more information on the sp's themselves and the environment you're working in please - and I (or more likely one of the top dog gurus who frequent the forums) can suggest something more concrete - or at least provide some more focussed questions to home in on the issue(s)
cheers
Andrew
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply