External sybase performance for 2000 users

Have 10.3.1 ón 3 primaries and an external sybase server with 2000 devices.
Performance and response in zcc is slow and has become worse as devices were added.
Top ok the sybase server is beysen 90 and 100 % opad most of the time and dbser10 is the hog
When zcc reports it is waiting for zenserver the cpu shoots up indicating it is sybase that is the bottle neck not zcm server
Would 10.3.2 help ?
And dó we need anything updated ok the sybase
External server
And finally - are we in need of the full sybase or oracle or mssql instead ?
  • There are things that can be done to help.

    #1 - How Big is your DB file for Sybase?
    This will give us an idea if there are tables that can be cleaned up.
    We can move on to identifying those tables if the DB appears to be large.

    #2 - How Big is your Transaction Log? This will confirm the actions are
    being properly committed.

    #3 - Is the External Server "Virtual"? If So, there may need to be
    tweaks there for performance.

    #4 - A Rebuild of the DB can really help restore some performance, but
    until we determine if cleanup of the DB is necessary, I would wait on
    that part.

    On 1/27/2011 3:36 AM, bkelsen wrote:
    >
    > Have 10.3.1 ón 3 primaries and an external sybase server with 2000
    > devices.
    > Performance and response in zcc is slow and has become worse as devices
    > were added.
    > Top ok the sybase server is beysen 90 and 100 % opad most of the time
    > and dbser10 is the hog
    > When zcc reports it is waiting for zenserver the cpu shoots up
    > indicating it is sybase that is the bottle neck not zcm server
    > Would 10.3.2 help ?
    > And dó we need anything updated ok the sybase
    > External server
    > And finally - are we in need of the full sybase or oracle or mssql
    > instead ?
    >
    >



    --
    Craig Wilson - MCNE, MCSE, CCNA
    Novell Knowledge Partner

    Novell does not officially monitor these forums.

    Suggestions/Opinions/Statements made by me are solely my own.
    These thoughts may not be shared by either Novell or any rational human.
  • craig_wilson;2069157 wrote:
    There are things that can be done to help.

    #1 - How Big is your DB file for Sybase?
    This will give us an idea if there are tables that can be cleaned up.
    We can move on to identifying those tables if the DB appears to be large.

    #2 - How Big is your Transaction Log? This will confirm the actions are
    being properly committed.

    #3 - Is the External Server "Virtual"? If So, there may need to be
    tweaks there for performance.

    #4 - A Rebuild of the DB can really help restore some performance, but
    until we determine if cleanup of the DB is necessary, I would wait on
    that part.

    On 1/27/2011 3:36 AM, bkelsen wrote:
    >
    > Have 10.3.1 ón 3 primaries and an external sybase server with 2000
    > devices.
    > Performance and response in zcc is slow and has become worse as devices
    > were added.
    > Top ok the sybase server is beysen 90 and 100 % opad most of the time
    > and dbser10 is the hog
    > When zcc reports it is waiting for zenserver the cpu shoots up
    > indicating it is sybase that is the bottle neck not zcm server
    > Would 10.3.2 help ?
    > And dó we need anything updated ok the sybase
    > External server
    > And finally - are we in need of the full sybase or oracle or mssql
    > instead ?
    >
    >



    --
    Craig Wilson - MCNE, MCSE, CCNA
    Novell Knowledge Partner

    Novell does not officially monitor these forums.

    Suggestions/Opinions/Statements made by me are solely my own.
    These thoughts may not be shared by either Novell or any rational human.
  • craig_wilson;2069157 wrote:
    There are things that can be done to help.

    #1 - How Big is your DB file for Sybase?
    This will give us an idea if there are tables that can be cleaned up.
    We can move on to identifying those tables if the DB appears to be large.

    #2 - How Big is your Transaction Log? This will confirm the actions are
    being properly committed.

    #3 - Is the External Server "Virtual"? If So, there may need to be
    tweaks there for performance.
    PHYSICAL :-)

    #4 - A Rebuild of the DB can really help restore some performance, but
    until we determine if cleanup of the DB is necessary, I would wait on
    that part.

    For the others - please direct to proper doc on how to extract info requested - cant seem to nail it :-)
  • Update...
    Servers updated to 10.3.2 zOSTARGET table in sybase was seriously bloated, now back to normal.

    Performance better - but when uploading content like Adobe Photoshop CS4 looking a 2GB in 15.000 files thing slow down in a bad manner....
    however zipping the many file and only uploading 1 zipped file to content works like a charm - howver then you have to unzip in an action before you can use the files :-(

    Any insights are still appreciated :-)
  • The 15K Files in an action will need to be packaged into an MSI or
    Self-Extracting Zip or simalar solution get them quickly from the
    content-repo. There is simply overhead in tracking each file
    individually.

    You might try an "Enhancement Request" for a "Blob Option" where all of
    the files are stored and tracked as one unit instead of 15,000 separate
    units.

    Also simply having this bundle installed on a device will cause some
    issues on the client. The 'AppState' files for each associated bundle
    are re-written on each refresh. They are an XML representation of the
    bundle. If there are 15,000 pieces of content in a bundle, that is
    quite a bit of information to re-parse each time.

    On 2/1/2011 9:36 AM, bkelsen wrote:
    >
    > Update...
    > Servers updated to 10.3.2 zOSTARGET table in sybase was seriously
    > bloated, now back to normal.
    >
    > Performance better - but when uploading content like Adobe Photoshop
    > CS4 looking a 2GB in 15.000 files thing slow down in a bad manner....
    > however zipping the many file and only uploading 1 zipped file to
    > content works like a charm - howver then you have to unzip in an action
    > before you can use the files :-(
    >
    > Any insights are still appreciated :-)
    >
    >



    --
    Craig Wilson - MCNE, MCSE, CCNA
    Novell Knowledge Partner

    Novell does not officially monitor these forums.

    Suggestions/Opinions/Statements made by me are solely my own.
    These thoughts may not be shared by either Novell or any rational human.