IDS Forum

Re: IDS Growth vs Enterprise

Posted By: LARRY SORENSEN
Date: Monday, 11 July 2016, at 1:39 p.m.

In Response To: Re: IDS Growth vs Enterprise (Art Kagel)

Thank you for the information.

A related question - If I have two separate instances running on the same server, from the same $HOME directory installation, does that mean that they are sharing the 16 CPUs and the 16 GB of memory, or do they each get their own resources?

Larry

________________________________
From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel <art.kagel@gmail.com>
Sent: Monday, July 11, 2016 10:31 AM
To: ids@iiug.org
Subject: Re: IDS Growth vs Enterprise [37420]

Larry:

The things to look at would be:

- onstat -g rea -r 1 Are the same sessions in the ready queue for more

than a second and you are maxed out at 16 CPU VPS on 16 physical cores (not

hyper-threads)?

- onstat -g rea typically shows more than a couple of sessions waiting

for CPU resources and you are maxed out at 16 CPU VPS on 16 physical cores

(not hyper-threads)?

- message log messages about not being able to increase shared memory

beyond 16GB?

- You have tables approaching the 16million page limit and moving the

table to wider pages is not a good option (ie partitioning/fragmenting

would be better).

- You have tables on which your spend significant time purging older

time bound data that could take advantage of rolling window partitions to

simplify data management and reduce overhead.

- You want/need more than two secondaries.

- You need access to distributed data/distributed queries.

- You could take advantage of GRID/Sharding technology to distribute a

very large database across multiple servers.

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
This is the site for Art S. Kagel's consultancy. The soaring majesty and beauty in the image above hides the complex ecology and detail of its existence.

Blog: http://informix-myview.blogspot.com/

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 Mon, Jul 11, 2016 at 12:09 PM, LARRY SORENSEN <LSORENSEN25@msn.com>
wrote:

> I understand and know all of the points that you make.
>
> My question is, what kind of statistics can I look at to say that the
> bottleneck is Growth Edition, and the issue will be resolved by going to
> Enterprise Edition and gaining the additional resources (cpu and memory and
> parallelism)? We are already planning an Upgrading to a later version of
> Growth Edition.
>
> Larry
>
> ________________________________
> From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Carlton Doe
> <dbaresrc@xmission.com>
> Sent: Monday, July 11, 2016 9:37 AM
> To: ids@iiug.org
> Subject: Re: IDS Growth vs Enterprise [37415]
>
> There are two factors to consider. First =E2=80=94 11.5 has entered =
> end-of-life. Support will be withdrawn in April 2018 so you might want =
> to consider moving to a supported version.
>
> Second, moving from Workgroup to Enterprise should be based on =
> functionality and performance. WGE does not support parallelism, =
> fragmentation, parallel Bkup/Restore and other key components that will =
> enable the engine environment to run significantly faster.There are also =
> resource limitations built into the code that constrain the environment =
> as far as CPU power (num CPU VPs) and memory. There is limited HA/DR =
> support (2 secondaries) too. Finally distributed operations (query =
> to/from another instance) is not supported. Advanced functionality such =
> as compression and encryption are not available.
>
> That said, you can deploy and use timeseries, NoSQL. Whether any of this =
> is important to your environment is yours to decide. I=E2=80=99d =
> definitely vote for being on a supported version however! :)
>
> Carlton
>
> -------------------------------------------------
> Carlton Doe
> Flower Mound, TX
>
> No trees were killed in the transmission of this email, however a large =
> number of electrons were temporarily inconvenienced.=20
>
> > On Jul 11, 2016, at 10:03 AM, LARRY SORENSEN <LSORENSEN25@msn.com> =
> wrote:
> >=20
> > Solaris 10 Sparc=20
> >=20
> > IDS 11.50.FC7=20
> >=20
> > Are there any good statistics to run to determine when it is good to =
> graduate=20
> > to Enterprise Edition IDS from Growth Edition IDS?=20
> >=20
> > Larry=20
> >=20
> > ________________________________=20
> >=20
> >=20
> > =
> **************************************************************************=
> *****=20
> > Forum Note: Use "Reply" to post a response in the discussion forum.=20=
>
> >=20
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--001a1135b194e3e10205375eaf91

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

Messages In This Thread

• IDS Growth vs Enterprise
  LARRY SORENSEN -- Monday, 11 July 2016, at 11:03 a.m.
  • Re: IDS Growth vs Enterprise
    Carlton Doe -- Monday, 11 July 2016, at 11:37 a.m.
    • Re: IDS Growth vs Enterprise
      LARRY SORENSEN -- Monday, 11 July 2016, at 12:09 p.m.
      • Re: IDS Growth vs Enterprise
        Art Kagel -- Monday, 11 July 2016, at 12:31 p.m.
        • Re: IDS Growth vs Enterprise
          LARRY SORENSEN -- Monday, 11 July 2016, at 1:39 p.m.
          • Re: IDS Growth vs Enterprise
            Art Kagel -- Monday, 11 July 2016, at 2:46 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.