Fix microsoft#58: Default sort order for DB size widget (microsoft#111)

Change default sort order for the DB size widget to descending
kod3r · Nov 20, 2017 · 1d89cb6 · 1d89cb6
1 parent ae7adad
commit 1d89cb6
Showing 1 changed file with 1 addition and 1 deletion.
diff --git a/extensions/insights-default/sql/db_size.sql b/extensions/insights-default/sql/db_size.sql
@@ -10,4 +10,4 @@ select top 10
     (select sum(size) from fs where type = 1 and fs.database_id = db.database_id) LogFileSizeMB
 from sys.databases db
 where database_id > 4
-order by DataFileSizeMB
+order by DataFileSizeMB desc