Highlighted
Super Contributor.. Super Contributor..
Super Contributor..
140 views

UCMDB is causing a SQL Server performance issue

Starting several weeks ago, after upgrading to 2019.02, we started experiencing SQL server issues. Around 9:30 each morning the UCMDB database id starts the sys.sp_helpdistributor stored procedure against the master database.  This then spawns almost 600 distributor_admin processes which tie up all of the SQL server processes.  These distributor_admin processes time out after 30 minutes and then everything is fine again.  However for 30 minutes each morning SQL Server is essentially locked up.

Has anyone else run into this?

Thanks

 

0 Likes
2 Replies
Highlighted
Micro Focus Frequent Contributor
Micro Focus Frequent Contributor

Re: UCMDB is causing a SQL Server performance issue

Hello Paul.

i hope you are doing well.

 

on this case do you have any other job or management zone schedule for this time? .

based that this is an weird behavior we would like to suggest you to open a new case if needed so support can analyze the scenario

0 Likes
Highlighted
Super Contributor.. Super Contributor..
Super Contributor..

Re: UCMDB is causing a SQL Server performance issue

I opened case SD02533431.  We found that the issue is caused by the MSSQL Server Topology by SQL discovery job executing the sp_helpdistributor stored procedure.

We are still looking to figure why this started happening after our upgrade from 10.22 CP26 to 2019.02

Paul

 

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.