Results 1 to 7 of 7

Thread: Very Slow Performance on Enterprise Server

  1. #1
    Guest

    Very Slow Performance on Enterprise Server

    Oneworld B733.2 NT 4.0 SQL Server 7.0.

    Twice over the past week our Enterprise server slowed to a crawl with the
    CPU running at 100%. The first time it took a couple of hours then it got
    back to normal. The second time I re-booted after having all users log off
    and shutting down JDE and SQL services did not work. On the NT TASK MANAGER
    I noticed two processes that were running on and off. They were CMD.EXE and
    CL.EXE. The CL.EXE is a C++ optimizing compiler but what ever it does , I do
    not know. Has anyone an idea where it is coming from?

    Thanks,

    Crawford Winter








  2. #2

    RE: Very Slow Performance on Enterprise Server

    You were doing a package build, weren't you?




  3. #3
    Senior Member
    Join Date
    Nov 2000
    Posts
    110

    Re: Very Slow Performance on Enterprise Server

    Upgrade to AS/400 Quad (64-bit) Processors and 16GB of memory.


    ----- Original Message -----
    From: "Crawford Winter" <Crawford.Winter@transamerica.com>
    To: <jdelistml@jdelist.com>
    Sent: Thursday, March 15, 2001 8:30 AM
    Subject: Very Slow Performance on Enterprise Server


    > Oneworld B733.2 NT 4.0 SQL Server 7.0.
    >
    > Twice over the past week our Enterprise server slowed to a crawl with the
    > CPU running at 100%. The first time it took a couple of hours then it got
    > back to normal. The second time I re-booted after having all users log off
    > and shutting down JDE and SQL services did not work. On the NT TASK
    MANAGER
    > I noticed two processes that were running on and off. They were CMD.EXE
    and
    > CL.EXE. The CL.EXE is a C++ optimizing compiler but what ever it does , I
    do
    > not know. Has anyone an idea where it is coming from?
    >
    > Thanks,
    >
    > Crawford Winter
    >
    >
    >
    >
    >
    >
    > --------------------------
    > To view this thread, visit the JDEList forum at:
    >
    http://198.144.193.139/cgi-bin/wwwth...ard=OW&Number=
    7364
    > + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +
    > This is the JDEList One World / XE Mailing List.
    > Archives and information on how to SUBSCRIBE, and
    > UNSUBSCRIBE can be found at http://www.JDELIST.com
    > + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +
    >
    >



    JD Nowell
    OW: B7332
    ES: AS400 V4R4 CO: DB2/400 SP: 11.2
    Users: 250 TSE Users: 100
    JD Nowell
    OW: B7332
    ES: AS400 V4R4 CO: DB2/400 SP: 11.2
    Users: 250 TSE Users: 100

  4. #4

    Re: Very Slow Performance on Enterprise Server

    I would say that builds were occurring. CL.exe is the
    C-Linker.


    --- Crawford Winter <Crawford.Winter@transamerica.com>
    wrote:
    > Oneworld B733.2 NT 4.0 SQL Server 7.0.
    >
    > Twice over the past week our Enterprise server
    > slowed to a crawl with the
    > CPU running at 100%. The first time it took a
    > couple of hours then it got
    > back to normal. The second time I re-booted after
    > having all users log off
    > and shutting down JDE and SQL services did not work.
    > On the NT TASK MANAGER
    > I noticed two processes that were running on and
    > off. They were CMD.EXE and
    > CL.EXE. The CL.EXE is a C++ optimizing compiler but
    > what ever it does , I do
    > not know. Has anyone an idea where it is coming
    > from?
    >
    > Thanks,
    >
    > Crawford Winter
    >
    >
    >
    >
    >
    >
    > --------------------------
    > To view this thread, visit the JDEList forum at:
    >
    http://198.144.193.139/cgi-bin/wwwth...OW&Number=7364
    >
    > + - - - - - - - - - - - - - - - - - - - - - - - - -
    > - - - - +
    > This is the JDEList One World / XE Mailing List.
    > Archives and information on how to SUBSCRIBE, and
    > UNSUBSCRIBE can be found at http://www.JDELIST.com
    > + - - - - - - - - - - - - - - - - - - - - - - - - -
    > - - - - +
    >


    __________________________________________________
    Do You Yahoo!?
    Get email at your own domain with Yahoo! Mail.
    http://personal.mail.yahoo.com/




  5. #5

    Re: Very Slow Performance on Enterprise Server

    Did you say upgrade or downgrade? :-)



    --- hotm6654 <hotm6654@hotmail.com> wrote:
    > Upgrade to AS/400 Quad (64-bit) Processors and 16GB
    > of memory.
    >
    >
    > ----- Original Message -----
    > From: "Crawford Winter"
    > <Crawford.Winter@transamerica.com>
    > To: <jdelistml@jdelist.com>
    > Sent: Thursday, March 15, 2001 8:30 AM
    > Subject: Very Slow Performance on Enterprise Server
    >
    >
    > > Oneworld B733.2 NT 4.0 SQL Server 7.0.
    > >
    > > Twice over the past week our Enterprise server
    > slowed to a crawl with the
    > > CPU running at 100%. The first time it took a
    > couple of hours then it got
    > > back to normal. The second time I re-booted after
    > having all users log off
    > > and shutting down JDE and SQL services did not
    > work. On the NT TASK
    > MANAGER
    > > I noticed two processes that were running on and
    > off. They were CMD.EXE
    > and
    > > CL.EXE. The CL.EXE is a C++ optimizing compiler
    > but what ever it does , I
    > do
    > > not know. Has anyone an idea where it is coming
    > from?
    > >
    > > Thanks,
    > >
    > > Crawford Winter
    > >
    > >
    > >
    > >
    > >
    > >
    > > --------------------------
    > > To view this thread, visit the JDEList forum at:
    > >
    >
    http://198.144.193.139/cgi-bin/wwwth...ard=OW&Number=
    > 7364
    > > + - - - - - - - - - - - - - - - - - - - - - - - -
    > - - - - - +
    > > This is the JDEList One World / XE Mailing List.
    > > Archives and information on how to SUBSCRIBE, and
    > > UNSUBSCRIBE can be found at http://www.JDELIST.com
    > > + - - - - - - - - - - - - - - - - - - - - - - - -
    > - - - - - +
    > >
    > >
    >
    >
    >
    > JD Nowell
    > OW: B7332
    > ES: AS400 V4R4 CO: DB2/400 SP: 11.2
    > Users: 250 TSE Users: 100
    >
    > --------------------------
    > To view this thread, visit the JDEList forum at:
    >
    http://198.144.193.139/cgi-bin/wwwth...OW&Number=7388
    >
    > + - - - - - - - - - - - - - - - - - - - - - - - - -
    > - - - - +
    > This is the JDEList One World / XE Mailing List.
    > Archives and information on how to SUBSCRIBE, and
    > UNSUBSCRIBE can be found at http://www.JDELIST.com
    > + - - - - - - - - - - - - - - - - - - - - - - - - -
    > - - - - +
    >


    __________________________________________________
    Do You Yahoo!?
    Get email at your own domain with Yahoo! Mail.
    http://personal.mail.yahoo.com/




  6. #6
    New Member
    Join Date
    Mar 2001
    Location
    Tennessee
    Posts
    27

    Re: Very Slow Performance on Enterprise Server

    You may be having a problem with SQL taking up all the available memory on your
    server. We had this issue and set the amount of memory available for SQL on the
    server to a fixed memory size. When you start up SQL server services on the
    enterprise server, it will automatically grab the amount of memory you've set for
    SQL and won't use any more.

    To do this, go into enterprise manager, under SQL server group and right click on
    the server name. Select properties. Go to the memory tab and select use fixed
    memory size (MB). It should display the min & max available. I have 2GB available
    on my servers and have set this to approx 1500 MB. I also have the reserve physical
    memory for SQL server checkbox checked, with the minimum query memory set to 1024.

    This resolved my problems. If it doesn't work for you, you can always change it
    back.

    B7332 / SP 11.2 / NT 4.0 / SQL 7.0 (W2K & SQL 2000 this week!)

    Susan Ferlita
    Hillsborough Co. Sheriff's Office
    Tampa, FL

    Crawford Winter wrote:

    > Oneworld B733.2 NT 4.0 SQL Server 7.0.
    >
    > Twice over the past week our Enterprise server slowed to a crawl with the
    > CPU running at 100%. The first time it took a couple of hours then it got
    > back to normal. The second time I re-booted after having all users log off
    > and shutting down JDE and SQL services did not work. On the NT TASK MANAGER
    > I noticed two processes that were running on and off. They were CMD.EXE and
    > CL.EXE. The CL.EXE is a C++ optimizing compiler but what ever it does , I do
    > not know. Has anyone an idea where it is coming from?
    >
    > Thanks,
    >
    > Crawford Winter




  7. #7
    Guest

    RE: Very Slow Performance on Enterprise Server

    Susan, a number of replies came back for my problem. Most of them identified
    that I was running a server package build at the time. Therefore, I will no
    long attempt it during the day. I will however take note on your suggestion
    of restricting memory on SQL.

    Thanks,

    Crawford Winter
    Transamerica Life Canada




Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.