大网数据广告活动
启动与系统组件

The System Center Management service stops responding

· 52CE 我爱测

Fixes an issue where the System Center Management service stops responding after an instance of SQL Server disconnects, restarts, or fails.

This article helps you fix an issue where the System Center Management service stops responding after an instance of Microsoft SQL Server goes offline.

Original product version:   Microsoft System Center Service Manager 2010, System Center 2012 Service Manager, Microsoft System Center 2012 Service Manager Service Pack 1, Microsoft System Center 2012 Operations Manager, Microsoft System Center 2012 Operations Manager Service Pack 1, System Center 2012 R2 Operations Manager, System Center 2012 R2 Service Manager
Original KB number:   2913046

Symptoms

After an instance of SQL Server that hosts the OperationsManager database goes offline, the System Center Management service of the Microsoft System Center 2012 Operations Manager Service Pack 1 (SP1) management server stops responding.

For example, the System Center Management service stops responding after the instance of SQL Server disconnects, restarts, or fails. To recover from this issue after the instance of SQL Server is available again, you must restart the System Center Management service.

Resolution

Important: Before you modify the registry, follow the steps in this section carefully. Serious problems might occur if you modify the registry incorrectly. Before you modify the registry, back up the registry for restoration in case problems occur.

To resolve this issue, you can enable the automatic recovery feature in System Center 2012 Operations Manager SP1. By default, this automatic recovery feature is disabled.

To enable the automatic recovery feature on the management server, follow these steps:

  1. Start Registry Editor.

  2. Locate and then click the following registry subkey:

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\System Center\2010\Common\DAL

  3. Create the following two registry entries:

    • DALInitiateClearPool

      Type: DWORD
      Decimal value: 1

    • DALInitiateClearPoolSeconds

      Type: DWORD
      Decimal value: 60

      [!NOTE] The DALInitiateClearPoolSeconds setting controls when the management server drops the current connection pool and when the management server tries to reestablish an SQL Server connection. We recommend that you set this setting to 60 seconds or more to avoid performance issues.

  4. Restart the System Center Management service on the management server.

Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / IT Pro troubleshooting
适用范围
See source applicability · Source date 04/15/2024
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。