How are the "DBSS - File Group Utilization" and "DBSS - Log Files Utilization" rules calculated? (4373360)

There are two possible use cases:

OS monitoring is not enabled for the monitored SQL Server instance.

In this example the definitions of the parameters: “AutoGrow” and “MaxSize” will not be taken into consideration even they are enabled.

Only following parameters will be taken into consideration during the calculation:

1. total file group’s data files used space
2. total file group’s data files allocated size
3. total file group’s data files free space = (total file group’s data files allocated size - total file group’s data files used space)

OS monitoring is enabled for the monitored SQL Server instance.

In this example the definitions of the parameters: AutoGrow and MaxSize will be taken into consideration if they are enabled.

When If  AutoGrow= ”Yes”  and Max Size= ”unlimited size”

The following parameters will be taken into consideration during the calculation:

1. total file group’s data files used space
2. total file group’s data files allocated size
3. total file group’s data files free space = (total file group’s data files allocated size - total file group’s data files used space)
4. sum of free space of OS disks where data files are located
5. total available free space = (total file group’s data files free space + sum of free space of OS disks where data files are located)

If  AutoGrow=”Yes”  and MaxSize=”limited size”

The following parameters will be taken into consideration during the calculation:

1. total file group’s data files used space
2. total file group’s data files allocated size
3. total file group’s data files free space = (total file group’s data files allocated size - total file group’s data files used space)
4. Find for each data file in the file group and summarize:

          4.1   min((MaxSize of data file - data file allocated size), free space of OS disk where data file is allocated)

      5. total available free space = (total file group’s data files free space + sum of #4)

The alarm “DBSS - Log Files Utilization” has the same logic.