Monitored Server SQL Server Collection Execution failure Collection Files Failed Error 8134 Level 16 State 1 Procedure Line 100 Message Divide by zero error encountered 50000
This issue is caused when the SQL Server performance counters report 0 for log file size but accurately for log file used.
The performance counters did not get updated straight away. In this case the counter wasn't updated until a long time later.
Executing the following select to check the performance counter, the value returned is 0:
SELECT counter_name, instance_name, cntr_value
FROM sys.dm_os_performance_counters pc
WHERE counter_name IN ('Log File(s) Size (KB)', 'Log File(s) Used Size (KB)')
AND instance_name != '_Total'
STATUS:
Issue fixed in version Spotlight 11.1. The latest version of Spotlight on SQL Server Enterprise can be downloaded at https://support.quest.com/spotlight-on-sql-server-enterprise/download-new-releases
