Is there an out of the box way to view/track individual SQL database table sizes for a SQL database that's being monitored with "AppInsight for SQL". I've seen there are ways to view the current snapshot of "Top 10 Tables by Size" for a given database, and for the database-level data file and transaction file sizes. But is there a way to drilldown and view the historical size of an individual table?
Thanks in advance.
I believe that you could find some inspiration in this template: SQL Database Size
SQL query can be easily modified to watch just single selected table like this:
SELECT TOP 1
SUM(CONVERT(BIGINT, a.total_pages)) * 8192 AS TableSize
sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id
sys.allocation_units a ON p.partition_id = a.container_id
WHERE i.object_id = OBJECT_ID('dbo.YourTable')
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.