Sizing informix server
Licu Garcia asked how to estimate CPU, RAM and disk for an Informix server from users and transactions. Art Kagel said it depends entirely on workload, with thousands of users on one or two CPUs in some cases and 32 cores struggling with under a thousand in others. Marcus Haarmann listed the application details needed first. Licu wanted a rough preliminary estimate and cited an old IBM article. No formula given.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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.
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
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.
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.