查询 SQL Server 某个数据库下所有对象的大小
时间: 2024-03-05 07:51:53 浏览: 30
可以使用以下 SQL 查询语句查询 SQL Server 某个数据库下所有对象的大小,包括表、视图、存储过程、函数等:
```
USE YourDatabaseName;
SELECT
OBJECT_NAME(object_id) AS ObjectName,
type_desc AS ObjectType,
SUM(reserved_page_count) * 8 AS TotalSpaceKB,
CAST(ROUND(((SUM(reserved_page_count) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS TotalSpaceMB,
SUM(used_page_count) * 8 AS UsedSpaceKB,
CAST(ROUND(((SUM(used_page_count) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS UsedSpaceMB,
(SUM(reserved_page_count) - SUM(used_page_count)) * 8 AS UnusedSpaceKB,
CAST(ROUND(((SUM(reserved_page_count) - SUM(used_page_count)) * 8) / 1024.00, 2) AS NUMERIC(36, 2)) AS UnusedSpaceMB
FROM
sys.dm_db_partition_stats
WHERE
OBJECT_NAME(object_id) IS NOT NULL
GROUP BY
object_id, type_desc
ORDER BY
TotalSpaceMB DESC, UsedSpaceMB DESC;
```
你只需要将 "YourDatabaseName" 替换为你要查询的数据库名称即可。
相关推荐
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)