Home
  •  

ConfigMgr 2007 站台系統摘要器:SMS SQL 資料庫僅剩不到 5\% 的可用資料檔空間，已無法再自動增加

SMSv4_Site_System_Summarizer__SMS_SQL_database_has_less_than_5__free_data_file_space_and_no_autogrow_15_Rule (Rule)

Knowledge Base article:

摘要

Configuration Manager 偵測到 Configuration Manager 站台資料庫僅剩不到 5% 的可用空間，且未設定為自動增加。這可能會造成站台效能降低，甚至於 Configuration Manager 功能停止。若要尋找資料庫可用空間不足的站台伺服器：

原因

解決方法

若要解決站台資料庫空間不足的問題：

其他

此警示最好交由 SQL Server 系統管理員與 Configuration Manager 系統管理員共同處理。

外部

請參閱 Configuration Manager 產品文件網頁 (英文) 的＜規劃與部署 Configuration Manager 2007 的伺服器基礎結構＞(英文)。

如需更多協助，請參閱 Configuration Manager 支援網站 (英文) 上，Configuration Manager 網站支援區段中的其他支援選項清單。

Element properties:

TargetMicrosoft.SystemCenter.ConfigurationManager.2007.Microsoft_SMSv4_Providers_Installation
CategoryEventCollection
EnabledTrue
Alert GenerateTrue
Alert SeverityInformation
Alert PriorityLow
RemotableTrue
Alert MessageSMSv4_Site_System_Summarizer__SMS_SQL_database_has_less_than_5__free_data_file_space_and_no_autogrow_15_Rule.AllertMessageBackwardCompatibility
CommentMom2005ID='{E43E22A6-25DF-4F3C-B36D-CEA5833F01C6}';MOM2005ComputerGroupID={9B811173-1E0F-43C1-B7D0-102B24FFFB7D}

Member Modules:

ID Module Type TypeId RunAs 
_F320DA51_13BF_11D3_B2CD_00A0C92A28B4_ DataSource System.Mom.BackwardCompatibility.FilteredEvent.DataProvider Default
GenerateAlert WriteAction System.Mom.BackwardCompatibility.AlertResponse Default

Source Code:

<Rule ID="SMSv4_Site_System_Summarizer__SMS_SQL_database_has_less_than_5__free_data_file_space_and_no_autogrow_15_Rule" Target="Microsoft.SystemCenter.ConfigurationManager.2007.Microsoft_SMSv4_Providers_Installation" Enabled="true" ConfirmDelivery="false" Comment="Mom2005ID='{E43E22A6-25DF-4F3C-B36D-CEA5833F01C6}';MOM2005ComputerGroupID={9B811173-1E0F-43C1-B7D0-102B24FFFB7D}">

  <Category>EventCollection</Category>

  <DataSources>

    <DataSource ID="_F320DA51_13BF_11D3_B2CD_00A0C92A28B4_" Comment="{F320DA51-13BF-11D3-B2CD-00A0C92A28B4}" TypeID="MomBackwardCompatibility!System.Mom.BackwardCompatibility.FilteredEvent.DataProvider">

      <Expression>

        <And>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

                <XPathQuery Type="Integer">EventDisplayNumber</XPathQuery>

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value>1108</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

                <XPathQuery Type="String">PublisherName</XPathQuery>

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value>ConfigMgr 2007 Monitor Site System Summarizer</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

        </And>

      </Expression>

    </DataSource>

  </DataSources>

  <WriteActions>

    <WriteAction ID="GenerateAlert" TypeID="MomBackwardCompatibility!System.Mom.BackwardCompatibility.AlertResponse">

      <AlertGeneration>

        <GenerateAlert>true</GenerateAlert>

        <Owner/>

        <Description>

            $Data/Params/Param[1]$

           - ConfigMgr 2007 Site System Summarizer: SMS SQL database has less than 5% free data file space and no autogrow.





            $Data/EventDescription$

          



Site system: 

            $Data/Params/Param[1]$

          

Site system role: 

            $Data/Params/Param[2]$

          

Site code: 

            $Data/Params/Param[3]$

          

Share: 

            $Data/Params/Param[4]$

          

Site object: 

            $Data/Params/Param[5]$

          </Description>

        <AlertLevel>20</AlertLevel>

        <ResolutionState/>

        <Source>

            $Data/PublisherName$

          </Source>

        <Name>ConfigMgr 2007 Site System Summarizer: SMS SQL database has less than 5% free data file space and no autogrow</Name>

      </AlertGeneration>

      <InvokerType>0</InvokerType>

    </WriteAction>

  </WriteActions>

</Rule>