loomansj Absent Member.
Absent Member.
765 views

SQL 2005 sessions & ZCM 10.0.3.2

Hello,
I have noticed that there are in excess of 30 SQL sessions running between
ZCM 10.0.3.2 (across three primary servers) and its database on Microsoft
SQL 2005 SP2. As a result, our SQL database server has experienced high CPU
usage and the sqlservr.exe process is experiencing high memory usage.

How many SQL sessions are the norm? Is there additional background
information someone can provide. For additional information, we have 1500
workstations in our ZCM system.

thanks,
Jason



Jason L.
Labels (2)
0 Likes
2 Replies
Anonymous_User Absent Member.
Absent Member.

Re: SQL 2005 sessions & ZCM 10.0.3.2

Jason,

It appears that in the past few days you have not received a response to your
posting. That concerns us, and has triggered this automated reply.

Has your problem been resolved? If not, you might try one of the following options:

- Visit http://support.novell.com and search the knowledgebase and/or check all
the other self support options and support programs available.
- You could also try posting your message again. Make sure it is posted in the
correct newsgroup. (http://forums.novell.com)

Be sure to read the forum FAQ about what to expect in the way of responses:
http://support.novell.com/forums/faq_general.html

If this is a reply to a duplicate posting, please ignore and accept our apologies
and rest assured we will issue a stern reprimand to our posting bot.

Good luck!

Your Novell Product Support Forums Team
http://support.novell.com/forums/

0 Likes
tvandael Absent Member.
Absent Member.

Re: SQL 2005 sessions & ZCM 10.0.3.2

loomansj;1664953 wrote:
Hello,
I have noticed that there are in excess of 30 SQL sessions running between
ZCM 10.0.3.2 (across three primary servers) and its database on Microsoft
SQL 2005 SP2. As a result, our SQL database server has experienced high CPU
usage and the sqlservr.exe process is experiencing high memory usage.

How many SQL sessions are the norm? Is there additional background
information someone can provide. For additional information, we have 1500
workstations in our ZCM system.

thanks,
Jason

Hey, we are facing the same CPU problem you see.
Any fix/reason found about this?

Tim
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.