Document ID: TEC1516536
Last Modified Date: 01/09/2017
Show Technical Document Details
How to determine if QOS data is being updated for all tables.
A given customer noticed that one their tables for a given probe only contained QOS data for the last 24 hours each and every day and this was unexpected. Therefore they requested a means to check the data in their tables.
This will display a list of all QOS tables that have data for only the last 24 hours.
EXEC sp_executesql @sql, N'@sampletime DATETIME OUTPUT', @sampletime = @sampletime OUTPUT; IF @sampletime IS NULL FETCH NEXT FROM CurQosList INTO @table_id, @qos, @source, @target, @v_table