统计数据库表使用的情况

最新推荐文章于 2023-09-21 17:22:32 发布

IT小卜

最新推荐文章于 2023-09-21 17:22:32 发布

阅读量541

点赞数

文章标签：数据库

本文链接：https://blog.csdn.net/bubuyaya/article/details/18957605

版权

SELECT  o.name ,
        SUM(p.reserved_page_count) AS '(kb)reserved_page_count' ,
        SUM(p.used_page_count) AS '(kb)used_page_count' ,
        SUM(CASE WHEN ( p.index_id < 2 )
                 THEN ( p.in_row_data_page_count + p.lob_used_page_count
                        + p.row_overflow_used_page_count )
                 ELSE p.lob_used_page_count + p.row_overflow_used_page_count
            END) AS '(kb)Datapages' ,
        SUM(CASE WHEN p.index_id < 2 THEN p.row_count
                 ELSE 0
            END) AS rowCounts
FROM    sys.dm_db_partition_stats p
        INNER JOIN sys.objects o ON p.object_id = o.object_id
GROUP BY o.name
ORDER BY SUM(p.reserved_page_count) DESC