How to calculate SQL Azure Database and Objects Size

来源:互联网 发布:js获取div纯文字内容 编辑:程序博客网 时间:2024/05/30 04:40


--DatabaseSELECT SUM(reserved_page_count) * 8.0 / 1024 AS 'Total Reserved Space (MB)' FROM   sys.dm_db_partition_stats --ObjectsSELECT name,        reserved_page_count * 8.0 / 1024 AS 'Total Reserved Space (MB)' FROM   sys.dm_db_partition_stats ps        JOIN sys.objects so          ON ps.object_id = so.object_id 


原创粉丝点击