Re: Tuning for IIS and ADOMD.NET

I am not sure if this will work or not try running parallel queries, using
multiple threads.

"Tim Chapla" wrote:

> I added the dispose call in my closeConnection function, good advice Akshai.
>
> Are there some good ways sto push the load on to the Analysis Server?
> Execution Location=3;
> Default Isolation Mode=1;
> This pushes some of the processing over to the Analysis Server, but my IIS
> machine is still getting crushed.
>
> I am running simple mdx queries against the Analysis Server, but I am
> running 20 mdx queries per page using a single connection object. Are there
> some best practices involving using a single ADOMD.NET Connection object to
> make 20 calls to an Analysis Services Cube? It seems to really bog the IIS
> machine.
>
> thanks,
> tim
>
> "Akshai Mirchandani [MS]" <akshaim@xxxxxxxxxxxxxxxxxxxx> wrote in message
> news:u$8TGEFyFHA.3236@xxxxxxxxxxxxxxxxxxxxxxx
> > With ADOMD.NET using IXMLA to connect to an AS2000 server, most of the
> load
> > will be on the ADOMD.NET machine -- this is the machine that needs most of
> > the resources. PTS (the OLE DB for OLAP driver) does a lot of the work in
> > AS2000 and it will be running in the same process as ADOMD.NET.
> >
> > PTS can also use a lot of memory and so you should take a look at the
> memory
> > usage of that process. 1GB RAM is probably not enough for 200 active
> > connections...
> >
> > Also, it appears that ASP.NET is raising the errors so perhaps you are
> > hitting some limits there -- I suggest splitting up the web site into
> > multiple application pools and sharing the load among them.
> >
> > Another issue to check is that the code you use to execute your ADOMD.NET
> > connections "disposes" the command and connection as quickly as
> possible --
> > if you let the GC clean up the connections, then they may stick around for
> a
> > long time and hold on to lots of resources in the meantime.
> >
> > HTH,
> > 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.
> >
> > "Tim Chapla" <tchapla@xxxxxxxxxxxxxxxxxxx> wrote in message
> > news:uBL0EFDyFHA.3312@xxxxxxxxxxxxxxxxxxxxxxx
> > > Web Machine
> > > Microsoft Windows 2000 Advanced Server SP4
> > > Dual proc 550 mhz
> > > 1 gig ram
> > > .NET Framework 1.1.4332
> > >
> > > Analysis Server/SQL Server Machine
> > > Microsoft Windows 2003 (no service pack due to some
> incompatibilities
> > > with other software)
> > > Quad Proc 2ghz
> > > 4 gig ram
> > > SQL Server 2000 SP4
> > > Analysis Services SP4
> > >
> > > We are running a .NET application that connects to an Analysis Services
> > > Database using ADOMD.NET. When I record a test in Application Center
> Test
> > > to load test this app (200 connections for 20 iterations), it will spike
> > > around 400 RPS in the first 10 seconds and then start throwing 'The
> > service
> > > is overloaded' errors. The web box is getting crushed, while the
> Analysis
> > > Services machine is practically asleep. If I hit the site manually, it
> > > works fine, but under load, these connections seem to be crushing the
> web
> > > box.
> > >
> > > I have played with the following settings of the connection string:
> > > Restricted Client=2; -- (is not recognized)
> > > Client Cache Size=100;
> > > Auto Synch Period=100000;
> > > Execution Location=3;
> > > Large Level Threshold=100;
> > > Connect Timeout=120;
> > >
> > > My current connection string:
> > > Provider=MSOLAP.2;data source=ASComputerName;INITIAL
> > > CATALOG=ASDatabaseName;Client Cache Size=150;ConnectTo=8.0;
> > >
> > > I cannot get this app to perform. We have seen several errors, mostly
> > http
> > > timeouts from the web box, or service overloaded errors. Does anyone
> have
> > > any specific advice or any avenues I might begin to explore to try to
> get
> > > this web machine to perform?
> > >
> > > thank you for any info,
> > > tim
> > >
> > >
> >
> >
>
>
>
.

Relevant Pages

  • Re: Performance issues
    ... but you can take a look at the usage based optimization wizard to identify which user produce the slowest queries and ask them to send to you the excel file to diagnose in depth. ... This server is windows 2000 with analysis server 2000 and sp4. ...
    (microsoft.public.sqlserver.olap)
  • Analysis Server "Hung" (sort of)
    ... there are current locks, but I can no longer see any queries, or any cache ... queries, or tuning your Analysis Server -- something like the Hitchhiker's ... I would really like cut these long-running query times ...
    (microsoft.public.sqlserver.olap)
  • Re: Invalid bracketing of name&#8230;
    ... You cannot in Access 97 have a subquery that has brackets in it. ... You will have to do this in two queries, since you say you cannot change the ... Save that query as VT ... Tim wrote: ...
    (microsoft.public.access.queries)
  • Re: Invalid bracketing of name....;
    ... Tim. ... >I haven't got A97 to test but the easiest way is to use ... >Queries as John Spencer suggested (and so did I in the ... >>error FROM clause. ...
    (microsoft.public.access.queries)