Setting Optgoal for a session

Hello,

Just a curious question for which I haven't got a clear answer. If I change 
the optimization goal for a session, are the subsequently executed stored 
procedures recompiled before execution. Is it dependent on - if the stored 
procs are already in procedure cache or not.

Thanks
Amal 


0
Amal
9/6/2010 12:41:59 PM
sybase.ase.performance+tuning 2395 articles. 0 followers. Follow

2 Replies
546 Views

Similar Articles

[PageSpeed] 8

Should be relatively easy to see for yourself ...

- write a proc with a single query, a query you know will compile differently under different optgoals

- set showplan on

- run proc a few times under one optgoal, querying monCachedProcedures to make sure the CompileDate and PlanID values do 
not change (ie, proc is compiled once and re-used multiple times)  [also make note of the associated query plan]

- change the session's optgoal

- run proc a few times under the new optgoal, querying monCachedProcedures to see what happens for the first (and 
subsequent) runs under the new optgoal (eg, does the CompileDate and PlanID change for the first run?) [also make note 
of any changes in the associated query plan]

NOTE:  if running your tests in quick succession you'll probably want to do something like 
'convert(varchar,CompileDate,109)' in order to see if the secs/msecs change

Sooooo ... "When in doubt, try it out!"



Amal wrote:
> Hello,
> 
> Just a curious question for which I haven't got a clear answer. If I change 
> the optimization goal for a session, are the subsequently executed stored 
> procedures recompiled before execution. Is it dependent on - if the stored 
> procs are already in procedure cache or not.
> 
> Thanks
> Amal 
> 
> 
0
Mark
9/6/2010 1:42:01 PM
Hello,

I tried this with 15.5 earlier this year and noticed that you will have to 
clear the cache manually, otherwise it will use the cached queryplans.

-Kristian

"Amal" <amsharma AT abhikalakDOTcom> wrote in message 
news:4c84e197$1@forums-1-dub...
> Hello,
>
> Just a curious question for which I haven't got a clear answer. If I 
> change the optimization goal for a session, are the subsequently executed 
> stored procedures recompiled before execution. Is it dependent on - if the 
> stored procs are already in procedure cache or not.
>
> Thanks
> Amal
> 

0
Kristian
9/7/2010 5:13:49 AM
Reply:

Similar Artilces:

superreview requested: [Bug 230624] Rework cookie dialogs to allow setting session-only cookies/set session perm : [Attachment 142543] Patch with Allow/Allow for Session/Block options
Mike Connor <mconnor@myrealbox.com> has asked David Baron <dbaron@dbaron.org> for superreview: Bug 230624: Rework cookie dialogs to allow setting session-only cookies/set session perm http://bugzilla.mozilla.org/show_bug.cgi?id=230624 Attachment 142543: Patch with Allow/Allow for Session/Block options http://bugzilla.mozilla.org/attachment.cgi?id=142543&action=edit ...

superreview granted: [Bug 230624] Rework cookie dialogs to allow setting session-only cookies/set session perm : [Attachment 142543] Patch with Allow/Allow for Session/Block options
Johnny Stenback <jst@mozilla.jstenback.com> has granted Mike Connor <mconnor@myrealbox.com>'s request for superreview: Bug 230624: Rework cookie dialogs to allow setting session-only cookies/set session perm http://bugzilla.mozilla.org/show_bug.cgi?id=230624 Attachment 142543: Patch with Allow/Allow for Session/Block options http://bugzilla.mozilla.org/attachment.cgi?id=142543&action=edit ------- Additional Comments from Johnny Stenback <jst@mozilla.jstenback.com> sr=jst ...

superreview requested: [Bug 230624] Rework cookie dialogs to allow setting session-only cookies/set session perm : [Attachment 142543] Patch with Allow/Allow for Session/Block options #2
Mike Connor <mconnor@myrealbox.com> has asked Johnny Stenback <jst@mozilla.jstenback.com> for superreview: Bug 230624: Rework cookie dialogs to allow setting session-only cookies/set session perm http://bugzilla.mozilla.org/show_bug.cgi?id=230624 Attachment 142543: Patch with Allow/Allow for Session/Block options http://bugzilla.mozilla.org/attachment.cgi?id=142543&action=edit ------- Additional Comments from Mike Connor <mconnor@myrealbox.com> jst, since dbaron is in France and all, can you get to this one? ...

ASE 15 Performance and Tuning Guides
Greetings, Does anyone know when the updated ASE 15 versions of "Performance and Tuning Guides" will be released? The guides on sybooks are for ASE12.5.1 Thanks in advance. Alberto > Greetings, > > Does anyone know when the updated ASE 15 versions of > "Performance and Tuning Guides" will be released? I *think* that they were supposed to be released sometime later this year, but I don't have any clear information. Michael I'm not aware of when these will be released. I'm guessing some time after the 15.0.2 release. Ho...

Setting Session Variables from MasterPage...only want to call stored procedure once and set the Session Variables once
Using C#, VS2005, ASP.NET 2.0  I am getting a users Windows Identity and validating it against a database table for their UserID through a stored procedure. I am doing this through the Page_Init event from a MasterPage. I have tried using !IsPostback ,!Page.IsPostback, and !Master.Page.IsPostback to not have the Page_Init event called on every page. Is there somewhere or someway I can do this to only call the stored procedure once and set the session variables there? Kind of like a global variables (back in the VB6 days lol)...any help would be greatly appreciated.If you get an an...

Check List for ASE 11.9.2 Performance Tuning
Dear all, We need to troubleshoot the performance issue in an ASE 11.9.2 server. During the system in a slow response time state, about 20 Sh_page locks (Non Cursor Lock) found on the syslogins when I execute the sp_lock. Can anyone give me some advise on which areas I should check first (may be a check list) ? Cheers, Jack You might want to read through the Performance & Tuning guide for things like query performance management with things like sp_showplan and sp_sysmon. What you could consider is this. Any running task may be running with a bad query plan. Her...

superreview denied: [Bug 230624] Rework cookie dialogs to allow setting session-only cookies/set session perm : [Attachment 139172] with review comments
Darin Fisher <darin@meer.net> has denied Mike Connor <mconnor@myrealbox.com>'s request for superreview: Bug 230624: Rework cookie dialogs to allow setting session-only cookies/set session perm http://bugzilla.mozilla.org/show_bug.cgi?id=230624 Attachment 139172: with review comments http://bugzilla.mozilla.org/attachment.cgi?id=139172&action=edit ------- Additional Comments from Darin Fisher <darin@meer.net> please document change to nsICookiePermission. comments say that it returns true, but the type has been changed to boolean. i think you should d...

superreview requested: [Bug 230624] Rework cookie dialogs to allow setting session-only cookies/set session perm : [Attachment 139174] new patch
Mike Connor <mconnor@myrealbox.com> has asked Darin Fisher <darin@meer.net> for superreview: Bug 230624: Rework cookie dialogs to allow setting session-only cookies/set session perm http://bugzilla.mozilla.org/show_bug.cgi?id=230624 Attachment 139174: new patch http://bugzilla.mozilla.org/attachment.cgi?id=139174&action=edit ------- Additional Comments from Mike Connor <mconnor@myrealbox.com> all good points, addressed here, tested and working ...

superreview requested: [Bug 230624] Rework cookie dialogs to allow setting session-only cookies/set session perm : [Attachment 139172] with review comments
Mike Connor <mconnor@myrealbox.com> has asked Darin Fisher <darin@meer.net> for superreview: Bug 230624: Rework cookie dialogs to allow setting session-only cookies/set session perm http://bugzilla.mozilla.org/show_bug.cgi?id=230624 Attachment 139172: with review comments http://bugzilla.mozilla.org/attachment.cgi?id=139172&action=edit ...

superreview granted: [Bug 230624] Rework cookie dialogs to allow setting session-only cookies/set session perm : [Attachment 139174] new patch
Darin Fisher <darin@meer.net> has granted Mike Connor <mconnor@myrealbox.com>'s request for superreview: Bug 230624: Rework cookie dialogs to allow setting session-only cookies/set session perm http://bugzilla.mozilla.org/show_bug.cgi?id=230624 Attachment 139174: new patch http://bugzilla.mozilla.org/attachment.cgi?id=139174&action=edit ------- Additional Comments from Darin Fisher <darin@meer.net> sr=darin ...

setting session timeout ? what are the ways to set it ?
hi ,In my application i am setting the sessiontimeout property in codebehind in Loginpage itself like   Session.Timeout = 10. . I dont how to set in web.config file .Which one is better .   Can anybody  tell me how to set sessiontimeout in web.config file. I came to know that global.asax file is using in asp.net application . What is it using for . Is it a must for the better performance of the asp.net appliaction.  thanks & regards  nevviin  Thanks & Regards  write it like this  <system.web><compilation debug=&qu...

Session Expiry – the session expired after a number of hours of inactivity, although Session Expiry was set to 24 hours
Hi,  I had created a web application where Session expiry was set to 2,000 minutes in IIS. in web config i had given like this but MY web application was left logged in at 18:00 15th Oct, but on the following day 08:30 16th Oct, the session expired as soon as MY web application was used. It was also noted that during the day, MY web application occasionally got session expiry when it was constantly being used.Does the session expiry need to be set up anywhere else? There are no Error logs created. Will you please help me to resolve this issue. i expect your reply soon . With Thanks ...

Session variable set in .ashx file not being set
Hello,I have a captcha implemented on my registration screen. The captcha is generated by setting an asp.net image tag's src value to an image handler file (Captcha.ashx). <asp:Image ID="cptImg" runat="server" AlternateText="" ImageUrl="~/Captcha.ashx" /> In this ashx file, a session variable is saved and later checked against the value a user entered in an adjacent textbox on the registration page.Public Class Captcha Implements IHttpHandler Implements IRequiresSessionState Public ReadOnly Property IsReuseable() As Boo...

Is there a way to set session a variable by session ID?
I have a .Net 2.0 web page that hosts a Java applet.  The applet will post information to a different .Net web page (that the applet hosts, kind of like a frame).  This second page is in the same application as the first page, so it can share session info.  However, since the second page is hosted by the java applet it does not have the same session as the parent page.  I can pass the sessionID from the parent page to the applet, and then pass the ID from the applet to the hosted page (via querystring), however, I cannot figure out a way to set a session variable ...

Web resources about - Setting Optgoal for a session - sybase.ase.performance+tuning

Help:Contents/Account settings and maintenance - Wikipedia, the free encyclopedia
Wikipedia® is a registered trademark of the Wikimedia Foundation, Inc. , a non-profit organization.

Campaign setting - Wikipedia, the free encyclopedia
A campaign setting is usually a fictional world which serves as a setting for a role-playing game or wargame campaign. A campaign is a series ...

Privacy Setting For New Facebook Users Aged 13-17 Now Defaults To ‘Friends’
Facebook is changing the initial default privacy setting for users aged 13 through 17 to friends, from friends of friends, but those teen users ...

Facebook changes default privacy settings for new users to friends-only
Facebook announced today a shift in privacy settings for new users. Now, when someone signs up for a profile, their default posting status is ...

In praise of boredom, setting us free from the trials of endless distraction
We live in a world petrified of boredom but maybe a little ennui is not such a bad thing.

North Korea has had a "complete success" setting of a hydrogen bomb.
Or so it says. The North’s announcement came about an hour after detection devices around the world had picked up a 5.1 seismic event along ...

What Matters Is the Decision-Making Setting
... Rather, our skepticism of allowing democratically made collective “choices” to supersede choices made privately in private-property settings ...

Tiffany Reminds Consumers (And Costco) That Their Brand Isn’t Just A Setting Name
... $10 million worth of rings were sold at Costco, but the global brand is worth more than that. If “Tiffany” becomes simply the name of a setting ...

‘Scream Queens’ Renewed For Season 2 By Fox, Jamie Lee Curtis Expected To Return, New Setting Revealed ...
The Fox leadership have reaffirmed their confidence in Ryan Murphy . After giving the prolific creator a straight-to-series order for Scream ...

PC market finishes 2015 as expected, hopefully setting the stage for a more stable future, says IDC
Worldwide PC shipments totaled 71.9 million units in the fourth quarter of 2015, an on-year decline of 10.6%, according to the IDC Worldwide ...

Resources last updated: 1/17/2016 8:42:49 PM