Highlighted
bkelsen Absent Member.
Absent Member.
1506 views

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 ?
Labels (2)
0 Likes
5 Replies
CRAIGDWILSON Acclaimed Contributor.
Acclaimed Contributor.

Re: External sybase performance for 2000+ users

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.
--
Please give a hearty thumbs up to any post you find helpful!
To find articles by Craig Wilson simply follow the link: Craig Wilson's Tips!
0 Likes
bkelsen Absent Member.
Absent Member.

Re: External sybase performance for 2000+ users

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.
0 Likes
bkelsen Absent Member.
Absent Member.

Re: External sybase performance for 2000+ users

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 🙂
0 Likes
bkelsen Absent Member.
Absent Member.

Re: External sybase performance for 2000+ users

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 🙂
0 Likes
CRAIGDWILSON Acclaimed Contributor.
Acclaimed Contributor.

Re: External sybase performance for 2000+ users

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.
--
Please give a hearty thumbs up to any post you find helpful!
To find articles by Craig Wilson simply follow the link: Craig Wilson's Tips!
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.