How do I see how much space each table occupies in the SQL Server database?

Source: Internet
Author: User
How do I see how much space each table occupies in the SQL Server database?

To create a stored procedure:

CREATE PROCEDURE [dbo]. [Sys_viewtablespace]
As

BEGIN

SET NOCOUNT on;

CREATE TABLE [dbo]. #tableinfo (
Table name [varchar] (COLLATE) chinese_prc_ci_as NULL,
Number of records [INT] NULL,
reserved space [varchar] (COLLATE) chinese_prc_ci_as NULL,
Use space [varchar] (COLLATE) chinese_prc_ci_as NULL,
index occupy space [varchar] (COLLATE) chinese_prc_ci_as NULL,
unused space [varchar] (COLLATE) chinese_prc_ci_as NULL
)

INSERT into #tableinfo (table name, number of records, reserved space, use space, index occupy space, unused space)
exec sp_msforeachtable "exec sp_spaceused '?"

SELECT * FROM #tableinfo
ORDER BY record number desc

drop table #tableinfo

END

When used directly: Exec sys_viewtablespace

How do I see how much space each table occupies in the SQL Server database?

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.