Roger's BI Blog

For those who use MDW and complain about the bug in the report Disk Usage Collection Set - Database, I updated the query so that it shows now the correct data. The bug is very consistent: it's in there from 2008 R2 and still there. Take a look at the report: As you can see the report shows more than 8 GB but in the data below you can see that the database size is no more than 4,3 GB.  Someone just made a programming error at Microsoft and unknown on what the field values mean in MDW just mixed up some numbers. I have to admit that it is not easy :-) I rewrote the query after comparing the values with a real database and added the log value. Now it is to Microsoft to add it.  Here's the code (I highlighted the changes): exec sp_executesql @stmt = N'BEGIN TRY DECLARE @snapshot_id int SELECT TOP 1 @snapshot_id = snapshot_id FROM ( SELECT DISTINCT TOP 100 d.snapshot_id FROM snapshots.disk_usage d, core.snapshots ss WHERE ss.instance_name = @S