Skip to content

Commit 3251a06

Browse files
author
sql-williamd
committed
Implemented "max size of datastore"
1 parent 05ebcf8 commit 3251a06

3 files changed

Lines changed: 550 additions & 518 deletions

File tree

Dashboards/OpenQueryStoreDashboard.rdl

Lines changed: 5 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -154,13 +154,11 @@ ORDER BY TimeDate;</CommandText>
154154
<DataSet Name="QS_Storage_Size">
155155
<Query>
156156
<DataSourceName>LocalServer</DataSourceName>
157-
<CommandText>SELECT OBJECT_NAME(object_id) AS 'Table' ,
158-
( reserved_page_count * 8 ) AS 'Size'
159-
FROM sys.dm_db_partition_stats
160-
WHERE OBJECT_NAME(object_id) IN ( 'Intervals', 'PlanDBID', 'Plans' ,
161-
'Queries' ,'Query_Runtime_Stats' ,
162-
'Wait_Stats' ,'Activity_Log','excluded_queries'
163-
);</CommandText>
157+
<CommandText>SELECT
158+
[object_name] AS [Table],
159+
[space_used_kb] AS [Size]
160+
FROM oqs.object_catalog
161+
WHERE space_used_kb IS NOT NULL;</CommandText>
164162
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
165163
</Query>
166164
<Fields>

0 commit comments

Comments
 (0)