• Informix Memory Problem in Windows 2008 bits

    From abderrafi212@gmail.com@21:1/5 to All on Sun May 29 06:46:29 2016
    Hi, we have a performance issue in our production environement, when we've checked the online log we found that informix is allocating each time memory segment of 82223 kb to 82260 kb and so on, so we have change onconfig parameters to :
    SHMVIRTSIZE TO 20000000
    SHMADD TO 1000000
    SHMTOTAL TO 25000000

    our server is a Window 2008 64 bits with 53 GB and 16 cpu, but we restarted the informix server we have check the memory of the server and its consuming just 1.8 GB of resident memory even if we gave it 20 Gb in onconfig, so why Informix does not reserve
    the memory I gave in the onconfig wich is 20000000.

    is there any problem with window 2008 64 bits, my Informix is 11.70 TC5

    Thanks

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Mike Walker@21:1/5 to All on Sun May 29 08:23:54 2016
    To: informix-list@iiug.org

    Are there any messages in the Informix log on startup to show that
    SHMVIRTSIZE was changed, and why the setting may have been overridden?

    -----Original Message-----
    From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org]
    On Behalf Of abderrafi212@gmail.com
    Sent: Sunday, May 29, 2016 7:46 AM
    To: informix-list@iiug.org
    Subject: Informix Memory Problem in Windows 2008 bits

    Hi, we have a performance issue in our production environement, when we've checked the online log we found that informix is allocating each time memory segment of 82223 kb to 82260 kb and so on, so we have change onconfig parameters to :
    SHMVIRTSIZE TO 20000000
    SHMADD TO 1000000
    SHMTOTAL TO 25000000

    our server is a Window 2008 64 bits with 53 GB and 16 cpu, but we restarted
    the informix server we have check the memory of the server and its consuming just 1.8 GB of resident memory even if we gave it 20 Gb in onconfig, so why Informix does not reserve the memory I gave in the onconfig wich is
    20000000.

    is there any problem with window 2008 64 bits, my Informix is 11.70 TC5

    Thanks
    _______________________________________________
    Informix-list mailing list
    Informix-list@iiug.org
    http://www.iiug.org/mailman/listinfo/informix-list

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From abderrafi212@gmail.com@21:1/5 to All on Sun May 29 12:31:55 2016
    Hi, I have found how to fix the memory, in fact We have gave 6 Gb for SHMVIRTSIZE and thrue large query the informix has reach 17 GB but it was adding virtual segments for long time and here we are the performance has been impacted, I plan to fix the
    SHMVIRTSIZE to 20 GB snce I have 53 GB in my Windows, I have thought that its a Windows problem but its not, it was under estimaed in onconfig SHMVIRTSIZE parameter, but I have a quastion should I fix resident to -1 or let it 0 ? whats is the advantage
    of fixing Resident memory

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Mike Walker@21:1/5 to All on Sun May 29 11:06:45 2016
    To: informix-list@iiug.org

    I found this in the machine notes, which may describe the problem that you
    are having:


    2. Support maximum shared memory

    The database server can access shared-memory larger than two gigabytes
    on Windows. However, you must enable this feature with an entry in the
    Windows boot file.

    To add the entry, edit the boot.ini file (located in the top level, or
    root directory). You can either add a new boot option or use the
    currently
    existing boot option. To enable support for more than two gigabytes, add

    the following text to the end of the boot line:

    /3GB



    -----Original Message-----
    From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org]
    On Behalf Of Mike Walker
    Sent: Sunday, May 29, 2016 8:24 AM
    To: abderrafi212@gmail.com; informix-list@iiug.org
    Subject: RE: Informix Memory Problem in Windows 2008 bits

    Are there any messages in the Informix log on startup to show that
    SHMVIRTSIZE was changed, and why the setting may have been overridden?

    -----Original Message-----
    From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org]
    On Behalf Of abderrafi212@gmail.com
    Sent: Sunday, May 29, 2016 7:46 AM
    To: informix-list@iiug.org
    Subject: Informix Memory Problem in Windows 2008 bits

    Hi, we have a performance issue in our production environement, when we've checked the online log we found that informix is allocating each time memory segment of 82223 kb to 82260 kb and so on, so we have change onconfig parameters to :
    SHMVIRTSIZE TO 20000000
    SHMADD TO 1000000
    SHMTOTAL TO 25000000

    our server is a Window 2008 64 bits with 53 GB and 16 cpu, but we restarted
    the informix server we have check the memory of the server and its consuming just 1.8 GB of resident memory even if we gave it 20 Gb in onconfig, so why Informix does not reserve the memory I gave in the onconfig wich is
    20000000.

    is there any problem with window 2008 64 bits, my Informix is 11.70 TC5

    Thanks
    _______________________________________________
    Informix-list mailing list
    Informix-list@iiug.org
    http://www.iiug.org/mailman/listinfo/informix-list

    _______________________________________________
    Informix-list mailing list
    Informix-list@iiug.org
    http://www.iiug.org/mailman/listinfo/informix-list

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From abderrafi212@gmail.com@21:1/5 to All on Sun May 29 12:28:53 2016
    Le dimanche 29 mai 2016 18:06:53 UTC+1, Mike Walker a écrit :
    I found this in the machine notes, which may describe the problem that you are having:


    2. Support maximum shared memory

    The database server can access shared-memory larger than two gigabytes
    on Windows. However, you must enable this feature with an entry in the
    Windows boot file.

    To add the entry, edit the boot.ini file (located in the top level, or
    root directory). You can either add a new boot option or use the currently
    existing boot option. To enable support for more than two gigabytes, add

    the following text to the end of the boot line:

    /3GB



    -----Original Message-----
    From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Mike Walker
    Sent: Sunday, May 29, 2016 8:24 AM
    To: abderrafi212@gmail.com; informix-list@iiug.org
    Subject: RE: Informix Memory Problem in Windows 2008 bits

    Are there any messages in the Informix log on startup to show that SHMVIRTSIZE was changed, and why the setting may have been overridden?

    -----Original Message-----
    From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of abderrafi212@gmail.com
    Sent: Sunday, May 29, 2016 7:46 AM
    To: informix-list@iiug.org
    Subject: Informix Memory Problem in Windows 2008 bits

    Hi, we have a performance issue in our production environement, when we've checked the online log we found that informix is allocating each time memory segment of 82223 kb to 82260 kb and so on, so we have change onconfig parameters to :
    SHMVIRTSIZE TO 20000000
    SHMADD TO 1000000
    SHMTOTAL TO 25000000

    our server is a Window 2008 64 bits with 53 GB and 16 cpu, but we restarted the informix server we have check the memory of the server and its consuming just 1.8 GB of resident memory even if we gave it 20 Gb in onconfig, so why Informix does not reserve the memory I gave in the onconfig wich is
    20000000.

    is there any problem with window 2008 64 bits, my Informix is 11.70 TC5

    Thanks
    _______________________________________________
    Informix-list mailing list
    Informix-list@iiug.org
    http://www.iiug.org/mailman/listinfo/informix-list

    _______________________________________________
    Informix-list mailing list
    Informix-list@iiug.org
    http://www.iiug.org/mailman/listinfo/informix-list

    No, its obnly for Windows 2003, in 2008 there is o more boot.ini file

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)