T-SQL script to find the highly populated tables in database

DBA SQL Advanced SQL Server
Sometimes we need to check which tables of our database is highly populated. Below is the T-SQL Script which we can use to find out that.

SELECT 
    t.NAME AS TableName,
    i.name as indexName,
    sum(p.rows) as RowCounts,
    sum(a.total_pages) as TotalPages, 
    sum(a.used_pages) as UsedPages, 
    sum(a.data_pages) as DataPages,
    (sum(a.total_pages) * 8) / 1024 as TotalSpaceMB, 
    (sum(a.used_pages) * 8) / 1024 as UsedSpaceMB, 
    (sum(a.data_pages) * 8) / 1024 as DataSpaceMB
FROM 
    sys.tables t
INNER JOIN      
    sys.indexes i ON t.OBJECT_ID = i.object_id
INNER JOIN 
    sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id
INNER JOIN 
    sys.allocation_units a ON p.partition_id = a.container_id
WHERE 
    t.NAME NOT LIKE ‘dt%’ AND
    i.OBJECT_ID > 255 AND   
    i.index_id <= 1
GROUP BY 
    t.NAME, i.object_id, i.index_id, i.name 
–ORDER BY 
—    object_name(i.object_id) 

ORDER BY SUM(p.rows) DESC

27 thoughts on “T-SQL script to find the highly populated tables in database

  1. Pingback: Nuestro Mundo
  2. Pingback: botox
  3. Pingback: 바카라사이트
  4. Pingback: w88club
  5. Pingback: CBD oil
  6. Pingback: kompas qq
  7. Pingback: Samsara Market
  8. Pingback: fun 88
  9. Pingback: Slager hengelo
  10. Pingback: i99bet
  11. Pingback: qq online terbaik
  12. Pingback: sahabat qq
  13. Pingback: hondaqq
  14. Pingback: www.1lapakqq.site
  15. Pingback: Cecilia
  16. Pingback: vinyl truck signs
  17. Pingback: Alexandra

Leave a Reply