Re: Caching of Data in IIS / PTS

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Akshai Mirchandani [MS] (akshaim_at_online.microsoft.com)
Date: 10/21/04


Date: Thu, 21 Oct 2004 11:14:24 -0700

Yes, it should help.

Note that every time you created a new session it would have a new PTS
connection with a clean cache -- this can be good and bad. Good for getting
the latest data but worse for performance -- now a session cannot share
previous PTS connections so lots of metadata will need to be re-fetched.

Also, if you use sessions, please make sure that you explicitly end them as
early as possible because otherwise the load on the server would keep
growing...

Thanks,
Akshai

--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.
"Marcus" <Marcus@discussions.microsoft.com> wrote in message
news:6D0B539D-57B5-4046-A45A-E038D660D226@microsoft.com...
> Hi Akshai,
>
> Thanks for your response. I will experiment with the MDX sample.
>
> I feel this is also related to an earlier post in which a new virtual cube
> added to Analysis Services was not listed in XML/A Sample Appliction until
> after IIS & Analysis Services were restarted.
>
> The solution in this case was to use named sessions. Would this help in
this
> case?
>
> Kind regards,
>
> Marcus
>


Relevant Pages

  • Re: APPN Connection z/os - AHHC / LLC2.
    ... implied that you session stopped for a while and then continued. ... the ANNC link is a type 2.1 connection. ... I would suggest trying to limit the request unit size used over the type 2.1 ... MAXDATA operand when defining a PU statement for an adjacent link station ...
    (bit.listserv.ibm-main)
  • Re: Remote desktop deadlock on XP SP2
    ... the TS connection is frozen, even if I specify a wait timeout. ... TermSrv.dll creates a new session for the purpose of displaying the logon ... lives on a DPC routine for the network miniport ... the network packets are encapsulated and decapsulated in UDP. ...
    (microsoft.public.win32.programmer.kernel)
  • Re: JES-APPL
    ... Then there has been a session initiation request - which can only happen over an available session path - this isn't any of your flaky IP, ... Unless the NJE application on the AS/400 has consistently been caught in the middle of being activated in some way - highly unlikely I would expect - this is not a timing problem. ... Since the connection is necessarily in place, there is no problem with the connection - just in case a modem is involved - which, given a "switched" definition is used, is not impossible, but unlikely. ...
    (bit.listserv.ibm-main)
  • Re: os users, sessions, and connections.
    ... From what I've read a session is a logged connection. ... do the following (paddr is the address of the process ... select sid, serial#, paddr, username from v$session ...
    (comp.databases.oracle.server)
  • Re: Some outstanding ASP .NET questions
    ... Typically, we store the connection in the ... Session and use a Singleton pattern to retrieve it back later: ... Is it appropriate to store table key information in the session? ... I was referring to primary keys in database tables. ...
    (microsoft.public.dotnet.languages.csharp)