IDS Forum

Re: Question on tuning

Posted By: LARRY SORENSEN
Date: Tuesday, 2 May 2017, at 11:18 a.m.

In Response To: Re: Question on tuning (Art Kagel)

The thing that is the most irritating is that the server looks like it is sitting there idle.

________________________________
From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel <art.kagel@gmail.com>
Sent: Tuesday, May 2, 2017 8:53 AM
To: ids@iiug.org
Subject: Re: Question on tuning [39089]

SSD drives and LOTS of buffer cache are the main things that can offset the
processing deficit. I would also try overclocking the CPU VPs. Run 4 or 5
per core to get better overall throughput, but since the server is
competing with the Java apps for cycles, that may not help. Maybe move the
applications to another box to free up cycles for the server to use.

One thing that's probably exacerbating the problem is that your Java apps
are running better on the new platform so they are putting more stress on
the database server and leaving fewer cycles free for the oninits to use.

Art

Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com<http://www.askdbmgt.com>
ASK Database Management - Home<http://www.askdbmgt.com/>
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's consultancy. The soaring majesty and beauty in the image above hides the complex ecology and ...

Blog: http://informix-myview.blogspot.com/
Informix - My view<http://informix-myview.blogspot.com/>
informix-myview.blogspot.com
A place to share my views and ideas which may be of interest to the Informix user Community.

Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do
those opinions reflect those of other individuals affiliated with any
entity with which I am affiliated nor those of the entities themselves.

On Tue, May 2, 2017 at 10:35 AM, LARRY SORENSEN <LSORENSEN25@msn.com> wrote:

> Thank you for the unfortunate news. Is there anything that can be done to
> at
> least offset the issue a little?
>
> Larry
>
> ________________________________
> From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
> <art.kagel@gmail.com>
> Sent: Tuesday, May 2, 2017 8:28 AM
> To: ids@iiug.org
> Subject: Re: Question on tuning [39084]
>
> Larry:
>
> That's what I was afraid of. The T5240 is a dual socket system sporting
> UltraSparc T2+ processors. These T-class processors were designed in the
> last days of Sun Microsystems with the specific purpose of running Web apps
> and Java programs quickly. These highly threaded processes were choking
> modern multipath SMP processors like the UltraSparc M-class processors
> because their threads executed only a few hundred instructions before
> passing control to another thread. This behavior caused performance
> problems because long instruction queues, caches, translation pre-fetch
> buffers, and multi-path predictive circuits had to be flushed of unneeded
> instructions causing many-cycle delays every few hundred cycles.
>
> To offset that problem the Niagra processors (T1) were developed without
> these "unnecessary" optmizations. The T2 & T2+ processors took the design
> even further in the same direction. For web apps and Java programs, and
> even some heavily threaded C++ applications, the strategy worked. The T*
> processors shone out in Java based web service benchmarks. However, larger
> more traditional processes - like database servers - suffered extreme
> performance degradation on these processors as opposed to how they ran on
> the earlier M-class. Informix is highly threaded, however, because it was
> developed before the four competing thread library versions resolved
> themselves to a single winner in the late '90s, Informix uses its own
> threading library and its own thread scheduling. To the OS and to the
> processors each oninit process behaves as a massive single threaded
> application. Informix on T1 through T3 is a technology mismatch.
>
> It wasn't until the T4 & T5 processors, developed by Oracle after it
> acquired Sun, as they tried to get their own unthreaded database servers to
> perform on the hardware they now built and sold under their name, that the
> missing pieces of a modern optimized processor were restored to the
> T-class. Only the T5 is marginally successful in this way.
>
> Your old system is outperforming your new one because the old system, which
> is probably an M15 system, is MUCH more powerful than the new one is.
>
> Art
>
> Art S. Kagel, President and Principal Consultant
> ASK Database Management
> www.askdbmgt.com<http://www.askdbmgt.com>
> ASK Database Management - Home<http://www.askdbmgt.com/>
> www.askdbmgt.com<http://www.askdbmgt.com>
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> Blog: http://informix-myview.blogspot.com/
> Informix - My view<http://informix-myview.blogspot.com/>
> informix-myview.blogspot.com
> A place to share my views and ideas which may be of interest to the
> Informix
> user Community.
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and do not reflect on the IIUG, nor any other organization with which I am
> associated either explicitly, implicitly, or by inference. Neither do
> those opinions reflect those of other individuals affiliated with any
> entity with which I am affiliated nor those of the entities themselves.
>
> On Tue, May 2, 2017 at 8:04 AM, LARRY SORENSEN <LSORENSEN25@msn.com>
> wrote:
>
> > The new server is a T5240. I am trying to get the model of the older
> > server,
> > but it is offline at the moment. I will send it soon.
> >
> > Larry
> >
> > ________________________________
> > From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Frank
> > Langelage
> > <frank@lafr.de>
> > Sent: Tuesday, May 2, 2017 1:11 AM
> > To: ids@iiug.org
> > Subject: Re: Question on tuning [39070]
> >
> > On 02.05.17 05:37, LARRY SORENSEN wrote:
> > > Solaris 10
> > >
> > > IDS 11.50.FC5 Workgroup
> > >
> > > SPARC 64 bit
> > >
> > > I have two servers, one older server and one newer server. The newer
> > server
> > is
> > > obviously more powerful.
> > >
> > Which server models you're using?
> >
> >
> > ************************************************************
> > *******************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> > ************************************************************
> > *******************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --001a1145e9389d692e054e8b5b0d
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--94eb2c13edd6d2ce58054e8bb087

*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• Question on tuning
  LARRY SORENSEN -- Monday, 1 May 2017, at 11:37 p.m.
  • Re: Question on tuning
    Frank Langelage -- Tuesday, 2 May 2017, at 3:11 a.m.
    • Re: Question on tuning
      LARRY SORENSEN -- Tuesday, 2 May 2017, at 8:04 a.m.
      • Re: Question on tuning
        Art Kagel -- Tuesday, 2 May 2017, at 10:28 a.m.
        • Re: Question on tuning
          LARRY SORENSEN -- Tuesday, 2 May 2017, at 10:35 a.m.
          • Re: Question on tuning
            Art Kagel -- Tuesday, 2 May 2017, at 10:53 a.m.
            • Re: Question on tuning
              LARRY SORENSEN -- Tuesday, 2 May 2017, at 11:18 a.m.
  • Re: Question on tuning
    Fernando Nunes -- Tuesday, 2 May 2017, at 6:29 a.m.
    • Re: Question on tuning
      david@smooth1.co.uk -- Tuesday, 2 May 2017, at 6:43 a.m.
    • Re: Question on tuning
      LARRY SORENSEN -- Tuesday, 2 May 2017, at 8:06 a.m.
      • Re: Question on tuning
        Andreas Legner -- Tuesday, 2 May 2017, at 8:27 a.m.
      • Re: Question on tuning
        Marcus Haarmann -- Tuesday, 2 May 2017, at 8:34 a.m.
        • Re: Question on tuning
          LARRY SORENSEN -- Tuesday, 2 May 2017, at 8:49 a.m.
      • Re: Question on tuning
        Fernando Nunes -- Tuesday, 2 May 2017, at 9:29 a.m.
  • Re: Question on tuning
    Art Kagel -- Tuesday, 2 May 2017, at 6:47 a.m.
    • Re: Question on tuning
      LARRY SORENSEN -- Tuesday, 2 May 2017, at 8:22 a.m.
      • Re: Question on tuning
        Art Kagel -- Tuesday, 2 May 2017, at 10:39 a.m.
        • Re: Question on tuning
          Fernando Nunes -- Tuesday, 2 May 2017, at 11:06 a.m.
          • Re: Question on tuning
            Art Kagel -- Tuesday, 2 May 2017, at 11:14 a.m.
            • Re: Question on tuning
              Marcus Haarmann -- Tuesday, 2 May 2017, at 11:30 a.m.
              • Re: Question on tuning
                david@smooth1.co.uk -- Tuesday, 2 May 2017, at 12:16 p.m.
  • Re: Question on tuning
    Madison Pruet -- Tuesday, 2 May 2017, at 9:45 a.m.
    • Re: Question on tuning
      Marcus Haarmann -- Tuesday, 2 May 2017, at 9:50 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.