Revisions to Show data and disk use breakdown by table

replaced http://stackoverflow.com/ with https://stackoverflow.com/

Source Link

edited May 23, 2017 at 12:40

1

The query linked to, and copied by, @Nelson is inaccurate: it ignores Indexed Views, Full Text Indexes, XML Indexes, etc.

If you want a query that will include everything without executing sp_spaceused via sp_MSForEachTable, then I have already posted two variations of it (one here on DBA.StackExchange and the other on StackOverflow) so I won't copy them here:

Per each Table / Indexed View: sp_spaceused - How to measure the size in GB in all the tables in SQL sp_spaceused - How to measure the size in GB in all the tables in SQL
Per each Index: space usage on sys.allocation_units and sp_spaceused

The query linked to, and copied by, @Nelson is inaccurate: it ignores Indexed Views, Full Text Indexes, XML Indexes, etc.

If you want a query that will include everything without executing sp_spaceused via sp_MSForEachTable, then I have already posted two variations of it (one here on DBA.StackExchange and the other on StackOverflow) so I won't copy them here:

Per each Table / Indexed View: sp_spaceused - How to measure the size in GB in all the tables in SQL
Per each Index: space usage on sys.allocation_units and sp_spaceused

The query linked to, and copied by, @Nelson is inaccurate: it ignores Indexed Views, Full Text Indexes, XML Indexes, etc.

If you want a query that will include everything without executing sp_spaceused via sp_MSForEachTable, then I have already posted two variations of it (one here on DBA.StackExchange and the other on StackOverflow) so I won't copy them here:

Per each Table / Indexed View: sp_spaceused - How to measure the size in GB in all the tables in SQL
Per each Index: space usage on sys.allocation_units and sp_spaceused

replaced http://dba.stackexchange.com/ with https://dba.stackexchange.com/

Source Link

edited Apr 13, 2017 at 12:43

Community Bot

1

The query linked to, and copied by, @Nelson is inaccurate: it ignores Indexed Views, Full Text Indexes, XML Indexes, etc.

If you want a query that will include everything without executing sp_spaceused via sp_MSForEachTable, then I have already posted two variations of it (one here on DBA.StackExchange and the other on StackOverflow) so I won't copy them here:

Per each Table / Indexed View: sp_spaceused - How to measure the size in GB in all the tables in SQL
Per each Index: space usage on sys.allocation_units and sp_spaceused space usage on sys.allocation_units and sp_spaceused

The query linked to, and copied by, @Nelson is inaccurate: it ignores Indexed Views, Full Text Indexes, XML Indexes, etc.

If you want a query that will include everything without executing sp_spaceused via sp_MSForEachTable, then I have already posted two variations of it (one here on DBA.StackExchange and the other on StackOverflow) so I won't copy them here:

Per each Table / Indexed View: sp_spaceused - How to measure the size in GB in all the tables in SQL
Per each Index: space usage on sys.allocation_units and sp_spaceused

The query linked to, and copied by, @Nelson is inaccurate: it ignores Indexed Views, Full Text Indexes, XML Indexes, etc.

If you want a query that will include everything without executing sp_spaceused via sp_MSForEachTable, then I have already posted two variations of it (one here on DBA.StackExchange and the other on StackOverflow) so I won't copy them here:

Per each Table / Indexed View: sp_spaceused - How to measure the size in GB in all the tables in SQL
Per each Index: space usage on sys.allocation_units and sp_spaceused

Source Link

created Aug 26, 2015 at 4:37

Solomon Rutzky

69.5k
8
155
300

The query linked to, and copied by, @Nelson is inaccurate: it ignores Indexed Views, Full Text Indexes, XML Indexes, etc.

If you want a query that will include everything without executing sp_spaceused via sp_MSForEachTable, then I have already posted two variations of it (one here on DBA.StackExchange and the other on StackOverflow) so I won't copy them here:

Per each Table / Indexed View: sp_spaceused - How to measure the size in GB in all the tables in SQL
Per each Index: space usage on sys.allocation_units and sp_spaceused

Stack Exchange Network

Return to Answer