SQL-Watch does not count secondary not readable replicas

[hvoges]

Describe the bug
SQL-Watch does not count non-readable Replicas on Always On Clusters.

To Reproduce
Run select * from dbo.sqlwatch_meta_database on a secondary Replica with offline Replicas. There are no Entries for the Replicas, and as a result, they are not accounted for.

Expected behavior
Mirrored Offline-Databases should be counted, especially as they use diskspace.

Screenshots

Windows Server (please complete the following information):

• OS Version: Windows Server 2016

SQL Server (please complete the following information):

• SQL Version: SQL Server 2017
• SQL Edition: Enterprise

SQL Server Management Studio (SSMS -> about -> copy info):
SQL Server Management Studio 15.0.18424.0
SQL Server Management Objects (SMO) 16.100.47021.0+7eef34a564af48c5b0cf0d617a65fd77f06c3eb1
Microsoft Analysis Services-Clienttools 15.0.19750.0
Microsoft Data Access Components (MDAC) 10.0.14393.0
Microsoft MSXML 3.0 6.0
Microsoft .NET Framework 4.0.30319.42000
Betriebssystem 10.0.14393

SQLWATCH version (from DACPAC or from sysinstances)
4.4.0.523

[marcingminski]

Thanks for this. This behaviour was introduced by this fix: #107, and its currently by design. I suppose we could marry those two together.

[hvoges]

Thank you for your fast answer. The behaviour is a bit confusing as the count in the dashboard does not show the actual count.

[marcingminski]

I agree with you. I will keep this open and will think about how to address this.