Check Disk (DBCC)
Microsoft.SQLServer.2017.Linux.Task.Database.DBCCCheckAlloc (Task)
Checks the consistency of disk space allocation structures for a specified database.
Element properties:
Member Modules:
Source Code:
<Task ID="Microsoft.SQLServer.2017.Linux.Task.Database.DBCCCheckAlloc" Target="SQL2017LD!Microsoft.SQLServer.2017.Linux.Database" Accessibility="Internal" Enabled="true">
<Category>Maintenance</Category>
<ProbeAction ID="WA" TypeID="Microsoft.SQLServer.2017.Linux.ProbeAction.DBCCCommandExecutor" RunAs="GPMP!Microsoft.SQLServer.TaskAccount">
<MachineName>$Target/Host/Property[Type="SQL2017L!Microsoft.SQLServer.2017.Library.DBEngine"]/MachineName$</MachineName>
<InstanceName>$Target/Host/Property[Type="SQL2017L!Microsoft.SQLServer.2017.Library.DBEngine"]/InstanceName$</InstanceName>
<ConnectionString>$Target/Host/Property[Type="SQL2017L!Microsoft.SQLServer.2017.Library.DBEngine"]/ConnectionString$</ConnectionString>
<Login>$RunAs[Name="GPMP!Microsoft.SQLServer.SqlCredentialsProfile"]/UserName$</Login>
<Password>$RunAs[Name="GPMP!Microsoft.SQLServer.SqlCredentialsProfile"]/Password$</Password>
<CommandName>CHECKALLOC</CommandName>
<DatabaseName>$Target/Property[Type="SQL2017L!Microsoft.SQLServer.2017.Library.Database"]/DatabaseName$</DatabaseName>
<SqlTimeoutSeconds>15</SqlTimeoutSeconds>
<TimeoutSeconds>300</TimeoutSeconds>
<Publisher>SQL2017MonitoringLinux</Publisher>
<ManagementGroupName>$Target/ManagementGroup/Name$</ManagementGroupName>
</ProbeAction>
</Task>