MSSQL 2008 : Collecter l'espace alloué restant du groupe de fichiers de la base de données (\%)

Microsoft.SQLServer.2008.DBFileGroup.FileGroupAllocatedSpaceLeftPercent.Collection (Rule)

Quantité d'espace restant dans tous les fichiers pour ce groupe de fichiers en pourcentage. N'inclut pas l'espace restant sur le support qui héberge un fichier dont la croissance automatique est activée.

Knowledge Base article:

Element properties:

Member Modules:

Source Code:

<Rule ID="Microsoft.SQLServer.2008.DBFileGroup.FileGroupAllocatedSpaceLeftPercent.Collection" Target="SQL2008Core!Microsoft.SQLServer.2008.DBFileGroup" Enabled="true">

  <Category>PerformanceCollection</Category>

  <DataSources>

    <DataSource ID="DS" TypeID="Microsoft.SQLServer.2008.DBFileGroupSizeRawPerfProvider">

      <IntervalSeconds>900</IntervalSeconds>

      <SyncTime/>

      <ConnectionString>$Target/Host/Host/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ConnectionString$</ConnectionString>

      <ServerName>$Target/Host/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ServerName>

      <SqlInstanceName>$Target/Host/Host/Property[Type="SQL!Microsoft.SQLServer.ServerRole"]/InstanceName$</SqlInstanceName>

      <ObjectName>SQL DB File Group</ObjectName>

      <CounterName>DB File Group Allocated Space Left (%)</CounterName>

      <InstanceName/>

      <DatabaseName>$Target/Host/Property[Type="SQL!Microsoft.SQLServer.Database"]/DatabaseName$</DatabaseName>

      <DBFileGroupId>$Target/Property[Type="SQL!Microsoft.SQLServer.DBFileGroup"]/GroupID$</DBFileGroupId>

      <Value>$Data/Property[@Name='FreeSpaceAutoGrowPercent']$</Value>

      <TimeoutSeconds>300</TimeoutSeconds>

    </DataSource>

  </DataSources>

  <WriteActions>

    <WriteAction ID="WriteToDB" TypeID="SC!Microsoft.SystemCenter.CollectPerformanceData"/>

    <WriteAction ID="WriteToDW" TypeID="SCDW!Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData"/>

  </WriteActions>

</Rule>