0c175e9e-b9ab-4c5f-85a6-c3261a06a8db
61.0.0.0
WlasnySQL
Użycie bazy danych przez tabele
true
true
false
false
a1.data THEN
(a1.used + ISNULL(a4.used,0)) - a1.data ELSE 0 END) * 8/1024.0 AS 'wielkość indeksu [MB]',
(CASE WHEN (a1.reserved + ISNULL(a4.reserved,0)) > a1.used THEN
(a1.reserved + ISNULL(a4.reserved,0)) - a1.used ELSE 0 END) * 8/1024.0 AS 'nieużywane [MB]'
FROM
(SELECT
ps.object_id,
SUM (
CASE
WHEN (ps.index_id < 2) THEN row_count
ELSE 0
END
) AS [rows],
SUM (ps.reserved_page_count) AS reserved,
SUM (
CASE
WHEN (ps.index_id < 2) THEN
(ps.in_row_data_page_count + ps.lob_used_page_count + ps.row_overflow_used_page_count)
ELSE (ps.lob_used_page_count + ps.row_overflow_used_page_count)
END
) AS data,
SUM (ps.used_page_count) AS used
FROM sys.dm_db_partition_stats ps
GROUP BY ps.object_id) AS a1
LEFT OUTER JOIN
(SELECT
it.parent_id,
SUM(ps.reserved_page_count) AS reserved,
SUM(ps.used_page_count) AS used
FROM sys.dm_db_partition_stats ps
INNER JOIN sys.internal_tables it ON (it.object_id = ps.object_id)
WHERE it.internal_type IN (202,204)
GROUP BY it.parent_id) AS a4 ON (a4.parent_id = a1.object_id)
INNER JOIN sys.all_objects a2 ON ( a1.object_id = a2.object_id )
INNER JOIN sys.schemas a3 ON (a2.schema_id = a3.schema_id)
WHERE a2.type <> 'S' and a2.type <> 'IT'
--ORDER BY a3.name, a2.name
--ORDER BY a1.rows desc
ORDER BY data desc
end try
begin catch
select
-100 as l1
, 1 as schemaname
, ERROR_NUMBER() as tablename
, ERROR_SEVERITY() as row_count
, ERROR_STATE() as reserved
, ERROR_MESSAGE() as data
, 1 as index_size
, 1 as unused
end catch]]>
false
1.0
979ca4a61bcabf65ed99c1baee7f1de7
System.Int64
Liczbowa
0
l1
l1
true
50
0
None
System.String
Tekstowa
1
tabela
tabela
true
100
System.Int64
Liczbowa
2
liczba wierszy
liczba wierszy
true
50
0
None
System.Decimal
Liczbowa
3
zarezerwowane [MB]
zarezerwowane [MB]
true
50
6
Sum
System.Decimal
Liczbowa
4
dane [MB]
dane [MB]
true
50
6
Sum
System.Decimal
Liczbowa
5
wielkość indeksu [MB]
wielkość indeksu [MB]
true
50
6
Sum
System.Decimal
Liczbowa
6
nieużywane [MB]
nieużywane [MB]
true
50
6
Sum
0
System.Int64
l1
true
1
System.String
tabela
false
2
System.Int64
liczba wierszy
true
3
System.Decimal
zarezerwowane [MB]
true
6
4
System.Decimal
dane [MB]
true
6
5
System.Decimal
wielkość indeksu [MB]
true
6
6
System.Decimal
nieużywane [MB]
true
6