July 17, 2002 at 11:15 am
SQL Server 2000
Win2000
We have two plans cached for a stored procedure. It may depend on different setopts which we have found in syscacheobjects.
The trouble is that we do not know what setopts&512=512 and setopts&1024=1024 mean. The procedure is called from two different applications one with dblib and the other with odbc. The one with odbc has a setopts of 1026, which is unknown to us.
As this means inefficient use of the memory, any ideas of finding a way of to correct this. Or is it not possible to share plans between odbc and dblib, or for that matter other libs.
Thank you for any thoughts about this.
October 8, 2004 at 11:02 am
I'm having this same issue, (more than 2 years later I realize) but did you figure this out? Can you tell me how to analyze the value of setopts?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply