In a recent environment I was working with the SQL administrators configured their servers to allocate up to approximately 95% of the available memory on the server. We have been using the SQL Computers group to apply memory overrides to all SQL servers to change their default percentage of committed memory level from 80% to 99%. Recently we started receiving alerts for memory utilization on a SQL server that the “Percentage of Committed Memory in Use is too high” but the threshold listed is 80 and the server is a SQL server. Digging into this we found that discoveries are done based upon “SQL Server Integration Services” which may or may not exist on cluster nodes since this is a locally installed service. To address this from a tuning perspective we created a group [SQL Cluster Nodes (not discovered)] for the SQL non-detected nodes – and then we applied the override to the group. To support this going forward we will need to add SQL servers which do not have the “SQL Server Integration Services” installed locally to this group so that they will be tuned appropriately.