Sizing informix server

Posted in 2012

LICU GARCIA — Mon, 16 Jul 2012 18:38:23 — source: IIUG Forums & Mailing Lists

There is any way to estimate the size (CPU, RAM, disk space) of a infomix server taking number users, concurrent users, transactions and any other element. How much memory is required for determined users? How much users support one core? Thank you for your answers.

↪ replying to LICU GARCIA

Art Kagel — Mon, 16 Jul 2012 19:29:53 — source: IIUG Forums & Mailing Lists

That's very dependent on workload. I've seen thousands of users easily handled by a single or dual CPU system and I've seen 32 core machines struggle to handle less than one thousand users. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, 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 16, 2012 at 2:38 PM, LICU GARCIA <licu99@gmail.com> wrote: > There is any way to estimate the size (CPU, RAM, disk space) of a infomix > server taking number users, concurrent users, transactions and any other > element. > > How much memory is required for determined users? > How much users support one core? > > Thank you for your answers. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --e89a8f83a12906188904c4f774d8

↪ replying to LICU GARCIA

Marcus Haarmann — Tue, 17 Jul 2012 06:33:40 — source: IIUG Forums & Mailing Lists

Hi, there is no simple answer to that. It more or less depends on the behaviour of the application: - does it use a connection pool ? How many parallel connections to database are established ? - how many tables are involved in the main queries ? - how many records in the tables ? - how many parallel requests/transaction occur from application side ? - are there "big" queries which return a large number of records (and need to read a large amount of data for that) or mainly small queries which directly access over indexes ? - Is there one big database or many small databases ? - Are you starting with a small amount of users and growing or do you have a relatively stable amount of users ? Without knowing at least some answer to the questions, there can be no assumption for a good sizing. Hope this helps, Marcus ----- Ursprüngliche Mail ----- Von: "LICU GARCIA" <licu99@gmail.com> An: ids@iiug.org Gesendet: Montag, 16. Juli 2012 20:38:24 Betreff: Sizing informix server [27616] There is any way to estimate the size (CPU, RAM, disk space) of a infomix server taking number users, concurrent users, transactions and any other element. How much memory is required for determined users? How much users support one core? Thank you for your answers. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to LICU GARCIA

LICU GARCIA — Tue, 17 Jul 2012 18:02:46 — source: IIUG Forums & Mailing Lists

Thank you very much. I understand that you say. I've found a article that try resolve this situation but it's 10 years ago http://www.ibm.com/developerworks/data/zones/informix/library/techarticle/lurie/ 0201lurie.html#N105FA. My intention is to make a fast test taking the elements that I've mentioned to sizing of informix server. This exercise could help me to have a vision preliminar and after I could review and adjust the resources.