The Test Custom Counter window allows you to verify that the custom counter is what you want to collect on the SQL Server instances you have linked it to and that the value returned is the value expected. A successful test displays the value of the metric collected, while a failed test provides the associated failure details.
Common causes for failed custom counter tests include inaccurate counter information entered manually and counters that do not exist on a particular SQL Server instance.